Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to store data objects to SQL server? (BLOBs?)

Author  Topic 

Rafferty Uy
Starting Member

23 Posts

Posted - 2004-12-03 : 01:02:24
Hello there,

I'm planning to insert C# objects to a database table in SQL Server. I plan to use BLOBs but the way I found was to first serialize the objeect into a file before inserting that file into the database table. Is there a direct way to do this? (without going through files?)

Thanks!

Rafferty

-Rafferty

Andraax
Aged Yak Warrior

790 Posts

Posted - 2004-12-03 : 03:31:13
Hey!

If you can serialize the object to a stream, you should be able to get that into the database using ADO.NET.

Also, there are several good Object Relational Mapper tools out there, for example hibernate.net. I would advise you to have a look at www.sourceforge.net or www.gotdotnet.com, where several open source projects are building .NET O/R mappers.
Go to Top of Page
   

- Advertisement -