I have recently written an article about bulk insert / update / delete operations using LINQ To SQL. It involves sending data in IQueryable objects as XML to the database stored procedures and running the set based SQL operations.
Article: http://www.codeproject.com/KB/linq/BulkOperations_LinqToSQL.aspx
Subscribe to:
Post Comments (Atom)
2 comments:
Hi Shujaat
I have seen your nice tutotial, i have download your example program from codeproject website but it does not have any xml file, basically i need to write bulk xml data into ms sql, so if you have any completed example
please send me on stokyboz@hotmail.co.uk.
Thanks
Syed
You don't need any xml file. The runtime would generate it for you. Just write your .net and t-sql code as i have described and it should work.
Post a Comment