HnD | Whats the fastest way to save a very very large entity collection, Page 1

Whats the fastest way to save a very very large entity collection

Posts

Anonymous
User

Posts: 0
Joined: 11-Nov-2006

# Posted on: 25-Mar-2009 15:51:55

Hi Guys,

I have to a very large entity collection (50,000+) simple entities. Whats the fastest way to get them to saved into the database. Is there a bulk save operation?

Cheers

Pete

Walaa
Support Team

Posts: 14950
Joined: 21-Aug-2005

# Posted on: 25-Mar-2009 16:24:09

This has been discussed before several times. Please search the forum for either 'bulk insert' or 'SQLBulkCopy' (without the single quotes)

Examples of such recent discussions: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=15195 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=12462

Anonymous
User

Posts: 0
Joined: 11-Nov-2006

# Posted on: 25-Mar-2009 17:55:41

Thanks for the pointer. SqlBulkCopy will do nicely.

Pete