Search

Aug 8, 2008

Inserting value of Collection into Database

We always require thing like this, when you need to Insert list of object at the same time with single database operation.

Generally what we are doing is inserting individual object from front end, which is not good idea; in case where you have 100 of object needs to be inserted same time.

With the new feature Extension Method included in C# 3.0 and the XML datatype provided in SQL Server 2005, with combining these two we can achive the goal with less affort in terms of traffic and compactness of code.

I posted code on Code Project, it has description of each important phase you can download and customize according your need.

No comments: