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
at

2 comments:

  1. AnonymousMarch 6, 2010 at 2:29 PM

    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

    ReplyDelete
  2. Muhammad Shujaat SiddiqiMarch 8, 2010 at 7:31 PM

    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.

    ReplyDelete