LINQ2SQLExtensions

The LINQ2SQLExtensions pack was designed to extend LINQ to SQL. The inherent weakness of LINQ to SQL is that it prescribes a model in which more than one object representing a single relational entity may exist.

This is still true when using LINQ2SQLExtensions. However, LINQ2SQLExtensions enables a master/transient paradigm in which one master object exists per entity which is shared throughout the application.   All changes are made to transient instances of the entity objects. Once a set of changes (CUD) is complete the EntityOperationRegister replays this change set on the master DataContext. This empowers developers to build richer event driven data layer components than are possible using LINQ to SQL directly.

.NET 3.5 SP1 includes an enhancement to LINQ to SQL whereby when querying for a single result the pipeline will check the internal cache first before looking at the database. This has a dramatic effect on LINQ2SQLExtensions performance as LINQ2SQLExtensions uses Entity.GetOnContext(DataContext) extensively.