How can I easily store my C# data structure(XML serialiazable) into a database?

Question

I have a C# data structure which consists of classes and collections which have references to each other. Currently I am using Serialization to store the structure in XML, which works as a handy way to save/load the structure into my application.

If I want to be able to save/load the structure into a database, is there a simple way? Should I use LINQ?

Answer 1

Have you tried NHibernate?

EDIT: I don't know if this would be ok for you, but if you can define DB tables to hold your data structures, you could have code auto-generated using LINQ to SQL. Check ScottGu's tutorial on LINQ to SQL. If your data structures are not changing too often this could be a good way to go.

Answer 2

Just to be 100% clear LINQ has nothing to do with storing data in a database. LINQ is a language query for c# with syntax that resembles SQL.

So in order to answer your question you could look at the Entity Framework (I'd recommend this if you are using .NET 4.0) or LINQ to SQL

Answer 3

If you are using Oracle as a backend database. You can serilize your object graph using BinaryFormatter into a memorystream and strore bytes using BLOB datatype in Oracle Database.

Answer 4

It currently depends on your needs, and the db engine you are using:

• If you need to perform queries against the XML contents you can use a XML field (mssql and oracle do support them).
• If you only need to store/retrieve it, just store it in a long string field (NText in sqlserver. NCLob in Oracle).