Friday, 15 July 2011

.net - How many objects can LINQ used to create per second? -


I used Linq to insert objects into the database. But if I create 20 objects within 1 second If I use the thread, then failed to add 20 items to the system database.

And I found out that it is not possible due to the limit of SQL Server, so is Linq possible, any one idea? How can I make 20 records or more in 1 second within 1 second?

You mentioned that if you are using Threads to enter 20 records in your database If you are using the same database reference, this may be your problem. I do not believe the L2S database context object thread is secure.

Randy


No comments:

Post a Comment