3
shouts

Linq2Sql: Prevent performance issues when operating on multiple rows with Stored Procedures

posted by grabnerandigrabnerandi 323 days, 29 minutes ago
Thursday, April 30, 2009 2:35:22 PM GMT

Many of you bloggers out there have already covered the fact that Stored Procedures should be used for INSERTS, UPDATES and DELETES or in general when modifying multiple rows in a batch like statement. I also came across other blogs that discussed deleting or updated multiple entities with the standard interfaces of Linq2Sql - not highlighting the actual performance problem when marking entities with DeleteAllOnSubmit. Whats going on when we delete multiple entities? I wrote a test that clears two of m...

category: Foundation | clicked: 20 | | source: blog.dynatrace.com | show counter code
tags: Linq2Sql, Performance

No comments yet, be the first one to post comment.

To post your comment please login or signup