Entity Framework DbEntityEntry> 'Does not contain a definition for Where

Question

This code sniper is from Adding CreatedDate to an entity using Entity Framework 5 Code First

        public override int SaveChanges()
    {
        DateTime saveTime = DateTime.Now;
        foreach (var entry in this.ChangeTracker.Entries().Where(e => e.State == System.Data.EntityState.Added))
        {
            if (entry.Property("CreateDate").CurrentValue == null)
                entry.Property("CreateDate").CurrentValue = saveTime;
        }
        return base.SaveChanges();

    }

But on my solution I get this error "System.Collection.Generic.IEnumerable 'Does not contain a definition for Where ...

Check that you have a using statement for System.Linq – Steven Wood Oct 26 '13 at 18:24 — Steven Wood, Oct 26 '13 at 18:24
You have `System.Linq` using statement? – Sriram Sakthivel Oct 26 '13 at 18:24 — Sriram Sakthivel, Oct 26 '13 at 18:24

score 5 · Accepted Answer · answered Oct 26 '13 at 18:24

5

I'm expecting that you are missing using System.Linq

answered Oct 26 '13 at 18:24

Eiaddar

180
1
13

Thank you all I was missing System.Linq but VS was not able to resolve it – Jose Oct 26 '13 at 18:38
try Resharper It's great tools for suggesting and resolving using assemblies and organizing your code – Eiaddar Oct 26 '13 at 18:43

photowalker · Answer 2 · 2014-04-10T06:03:29.260

Try having your code in another method and call it in your SaveChanges method something like this. just above your savechanges method write

private void MyRule() 
{
  DateTime saveTime = DateTime.Now;
    foreach (var entry in this.ChangeTracker.Entries().Where(e => e.State == System.Data.EntityState.Added))
    {
        if (entry.Property("CreateDate").CurrentValue == null)
            entry.Property("CreateDate").CurrentValue = saveTime;
    }
 }

and then call it in your save changes like

public override int SaveChanges()
{
 this.MyRule();
 return base.SaveChanges();
}

This should do the trick :)

Cheers!

Entity Framework DbEntityEntry> 'Does not contain a definition for Where

2 Answers2