Contents tagged with LINQ to SQL
-
Understanding LINQ to SQL (11) Performance
LINQ to SQL has a lot of great features like
- strong typing
- query compilation
- deferred execution
- declarative paradigm
etc., which are very productive. Of course, these cannot be free, and one price is the performance.
-
Understanding LINQ to SQL (10) Implementing LINQ to SQL Provider
So far LINQ to SQL data CRUD (Creating / Retrieving / Updating / Deleting) has been explained. This post takes a deeper look at the internal implementation of LINQ to SQL query.
-
Understanding LINQ to SQL (9) Concurrent Conflict
Conflicts are very common when concurrently accessing the same data.
Conflicts in concurrent data access
The following code demonstrates the concurrent conflict scenario:
-
Understanding LINQ to SQL (8) Transaction
Database data Changing cannot be talked about without transactions.
Implementing TRANSACTION (BEGIN / COMMIT / ROLLBACK)
The previous post has shown that, when invoking SubmitChanges(), the translated SQL (INSERT / UPDATE / DELETE) are always executed within a TRANSACTION.
Internally, DataContext.SubmitChanges() invokes DataContext.SubmitChanges(ConflictMode.FailOnFirstConflict). The latter is implemented like this:
-
Understanding LINQ to SQL (7) Data Changing
-
Understanding LINQ to SQL (6) Working With Deferred Execution
-
Understanding LINQ to SQL (5) Remote And Local Method Call
-
Understanding LINQ to SQL (4) Data Retrieving Via Query Methods
-
Understanding LINQ to SQL (3) Expression Tree
-
Understanding LINQ to SQL (2) IQueryable<T>
-
Understanding LINQ to SQL (1) Object-Relational Mapping