How to store a complete dataset into database without having to do it table by table and row by row.
+1
A:
Have a look at the SqlDataAdapter. It can do bulk inserts/updates/deletes using its .Update() method.
That of course only works if you're using SQL Server as your database - you didn't mention what database you're targeting in your question....
See some tutorials on how to use SqlDataAdapter:
Marc
marc_s
2009-09-01 05:40:24
Or, you could store XML as XML in SQL Server 2005 or above, with no serialization overhead.
John Saunders
2009-09-01 05:59:31
Puzzien gave no indication of database technology
benPearce
2009-09-01 06:16:08
A:
Your question is a little ambiguous, so assuming you want to store multiple objects in a row i would recommend you investigate storing them as serialized json.
serialize the objects before you store them and un-serialize them when you need them again.
ADAM
2009-09-01 05:51:05