How to serialize SqlParameter ?

[Marcin]

hi, I would like to ask how to serialize class with members like
SqlParameter. I try to use BinaryFormatter .

[Serializable]
public class Example_Class
{

public SqlParameter sqlParam;

public Example_Class()
{
sqlParam = new SqlParameter("@ Data", SqlDbType.VarCh ar);
}
}

class App
{
[STAThread]
static void Main()
{
FileStream fs = new FileStream("Dat aFile.dat", FileMode.Create );

try
{
// Construct a BinaryFormatter and use it
// to serialize the data to the stream.
BinaryFormatter formatter = new

Example_Class dod = new Example_Class() ;
// Serialize the array elements.
formatter.Seria lize(fs, dod);

// Deserialize the array elements.
fs.Position = 0;
Example_Class dod2 = (Example_Class) formatter.Deser ialize(fs);
Console.WriteLi ne("Do both class refer to the same object? "
+ (dod.sqlParam == dod2.sqlParam)) ;
Console.ReadLin e();

}
catch (SerializationE xception e)
{
Console.WriteLi ne("Failed to serialize. Reason: " + e.Message);
Console.ReadLin e();
throw;
}
finally
{
fs.Close();
}
}

and error is :

"The type System.Data.Sql Client.SqlParam eter in Assembly System.Data,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9 is
not marked as serializable."

but I know that's possible. What I do wrong ?
How do I have to implement this?

Thanks,
Marcin

[Nicholas Paldino [.NET/C# MVP]]

Marcin,

You would have to mark the field with the SqlParameter as
NonSerializable (with the attribute). Then, you can implement the
IDerializationC allback interface to be notified when deserialization is
complete, so that you can re-initialize it.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Marcin" <ma*********@po czta.onet.pl> wrote in message
news:cf******** **@atlantis.new s.tpi.pl...

hi, I would like to ask how to serialize class with members like
SqlParameter. I try to use BinaryFormatter .

[Serializable]
public class Example_Class
{

public SqlParameter sqlParam;

public Example_Class()
{
sqlParam = new SqlParameter("@ Data", SqlDbType.VarCh ar);
}
}

class App
{
[STAThread]
static void Main()
{
FileStream fs = new FileStream("Dat aFile.dat", FileMode.Create );

try
{
// Construct a BinaryFormatter and use it
// to serialize the data to the stream.
BinaryFormatter formatter = new

Example_Class dod = new Example_Class() ;
// Serialize the array elements.
formatter.Seria lize(fs, dod);

// Deserialize the array elements.
fs.Position = 0;
Example_Class dod2 = (Example_Class) formatter.Deser ialize(fs);

Console.WriteLi ne("Do both class refer to the same object? "
+ (dod.sqlParam == dod2.sqlParam)) ;
Console.ReadLin e();

}
catch (SerializationE xception e)
{
Console.WriteLi ne("Failed to serialize. Reason: " + e.Message); Console.ReadLin e();
throw;
}
finally
{
fs.Close();
}
}

and error is :

"The type System.Data.Sql Client.SqlParam eter in Assembly System.Data,
Version=1.0.500 0.0, Culture=neutral , PublicKeyToken= b77a5c561934e08 9 is
not marked as serializable."

but I know that's possible. What I do wrong ?
How do I have to implement this?

Thanks,
Marcin