Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » LINQ to SQL   (RSS)
Monday, September 07, 2009 3:28 PM

"System.Data.Linq.ChangeConflictException: Row not found or changed" Finding the culprit

When updating a data table in SQL Server using LINQ to SQL and the SubmitChanges() method you may encounter the following exception: System.Data.Linq.ChangeConflictException: Row not found or changed. at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode
Posted by maspeng | 0 Comments
Filed under:
Tuesday, September 01, 2009 3:45 PM

Why massive inserts using SubmitChanges lack in performance.

Bulk inserting using LINQ to SQL, why is it so slow? Well, the short answer is that it is not designed to do bulk inserts. But out of curiosity, why is it slow? Well, let us do it by example (my preferred way). First create a table in SQL Server like
Posted by maspeng | 0 Comments
Filed under:
Monday, May 11, 2009 2:04 PM

How use Convert in a DataTable select?

How to use Convert() when doing DataTable.Select ? Sometimes you may need or want to select out a number of rows from a DataTable using the LIKE operator, this is no problem on a column with a string type. But what if you wish to do it on a column with,
Posted by maspeng | 1 Comments
Filed under: ,
Thursday, December 18, 2008 3:40 PM

Create a LINQ/WCF/Silverlight application in 10 simple steps.

Ok, today I will show how to create a super simple application that uses some of the new stuff you find in .Net 3.5. Try this and then you can throw cool words like Windows Communication Foundation (WCF), LINQ to SQL and Silverlight around you. This is
Posted by maspeng | 1 Comments
Filed under: , ,
Thursday, September 25, 2008 3:03 PM

“Deferred vs. Immediate Loading” or “Lazy vs. Eager Loading”, simplyfied, I hope....

Have you ever been thinking “When using LINQ to SQL, when does the data get loaded? Is it one huge query, or do I get a lot of database round tripping?”. If you have thought about it once or twice, fine. If you think about it all the time, you may have
Posted by maspeng | 0 Comments
Filed under:
 
Page view tracker