How to store object created with C# in SQL Server 2000

[Guest]

I want to store the objects that i create in run time in database. In a way
that, for a product a create an object from a class written with C#, define
its properties and functions that it has, and want to store it in a database
(SQL Server 2K). I want the columns to be created and filled dynamically when
an object is inserted in db (Just like in J2EE, which is called i think
relational mapping, or something like this).

How can I do that?

 

[Robbe Morris [C# MVP]]

Write it yourself...

Is there a reason you wouldn't have your objects tied to
an existing schema? Why the need to create it at runtime?

The whole concept of doing this dynamically just smacks
of performance and scalability issues.

You could use this to generate your class from your
existing schema in SQL Server.

http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp