Devart Forums

Code: Select all

MyDataContext context = new MyDataContext()
  { Log = Console.Out };

// Since the cache is empty, we query the database at this point.
Dept first = context.Depts
  .OrderBy(d => d.Deptno)
  .First();

// No SQL is executed now, because the entity with the smallest key is already cached.
Dept first1 = context.Depts
  .Where(d => d.Deptno == first.Deptno)
  .SingleOrDefault();

// The cache isn't empty, but no entity with the specified key was found.
// Hence has to search for it in the database.
Dept second = context.Depts
  .Where(d => d.Deptno == first.Deptno + 10)
  .SingleOrDefault();

Code: Select all

Dept first1 = context.Depts
  .SingleOrDefault(d => d.Deptno == first.Deptno);