Thursday, January 21, 2010

Bulk / Batch database operations like INSERT, UPDATE and DELETE in LINQ To SQL

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.



Anonymous said...

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



Muhammad Shujaat Siddiqi said...

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.