Storing objects in SQL Server table

[Diego F.]

Hello. I need to store custom objects in a SQL Server 2000 table. Which is
the easiest way to do it? Do I need to write methods to store each attribute
separately from C# app to the table and the opposite as well?

Regards,

Diego F.

 

[Frans Bouma [C# MVP]]

Hello. I need to store custom objects in a SQL Server 2000 table. Which is
the easiest way to do it? Do I need to write methods to store each attribute
separately from C# app to the table and the opposite as well?

Use binary formatter to serialize the object to a memory stream. Then store
the byte array in teh memory stream in an Image field in sqlserver. To read
an object back, first create a memory stream from the Image field's data,
then deserialize the data using the binary formatter.

Frans.

 

[Val Mazur]

Hi,

You could use binary or image datatypes to store any binary information.
These two types are both binaries, but difference just in a size
limitation - 8000 bytes for the binary type and 2,147,483,647 for image one.
See next KB about for to work with the binary (BLOB) fields using ADO.NET

http://support.microsoft.com/default.aspx?scid=kb;EN-US;309158

 

[Diego F.]

The problem I see with binary serialization is that I need later to manage
the fields in the table. Is a better idea for my application to write a
method that maps attributes to fields?
I don't need to build objets back again, just storing them in the database.

Regards,

Diego F.