How to store an object in a SQL Server table ?

Question

Hi everyone I'm not so experienced in SQL Server and I would appreciate if someone could give me some direction about how could I store an instance of a class in a db table for later use. Do I have to do something special while this table is created?

Adam Erstelle · Answer

I'm not sure if SQL Server has the ability to save an entire instance and its variables. What you may have to do is create a table with colums for each variable in your class and insert/update the appropriate row. Restoring the object will be simple as you read the values from the database into the appropriate variable. If your class has instances of other classes additional tables would have to be created and loaded/read from in the same manner.