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.

Article: http://www.codeproject.com/KB/linq/BulkOperations_LinqToSQL.aspx

2 comments:

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 stokyboz@hotmail.co.uk.

Thanks

Syed

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.