Non-static method requires a target. Entity Framework 5 Code First

Question

I am getting the error "Non-static method requires a target." when I run the following query:

var allPartners = DbContext.User                            .Include(u => u.Businesses)                            .Where(u => u.Businesses.Any(x => x.Id == currentBusinessId))                            .ToList(); 

My entites are defines like this:

public class User : Entity {     public virtual List<Business> Businesses { get; set; } }  public class Business : Entity {     public virtual List<User> Users { get; set; } }  public class Entity {     [Key]     [DatabaseGenerated(DatabaseGeneratedOption.Identity)]     public Guid Id { get; set; } } 

And my context is configured like this;

public class Context : DbContext, IDatabaseSession {     public DbSet<Business> Business { get; set; }     public DbSet<User> User { get; set; }      public Context()         : base("DefaultConnection")     {      }      protected override void OnModelCreating(DbModelBuilder modelBuilder)     {         base.OnModelCreating(modelBuilder);          modelBuilder.Conventions.Remove             <System.Data.Entity.ModelConfiguration.Conventions.PluralizingTableNameConvention>();          Database.SetInitializer(new MigrateDatabaseToLatestVersion<Context, Configuration>());          modelBuilder.Entity<User>()             .HasMany(u => u.Businesses)             .WithMany(b => b.Users);     } } 

What have I done wrong?

Answer 1

The problem boiled down to the query. My original question had this query:

var allPartners = DbContext.User                        .Include(u => u.Businesses)                        .Where(u => u.Businesses.Any(x => x.Id == currentBusinessId))                        .ToList(); 

Which wasn't quite accurate, I had in fact removed the error in an attempt to ask my question succinctly. The query was actually:

var currentBusiness = GetBusiness(); var allPartners = DbContext.User                        .Include(u => u.Businesses)                        .Where(u => u.Businesses.Any(x => x.Id == currentBusiness.Id))                        .ToList(); 

When the GetBusiness method returned null the error was thrown. Simply ensuring that I don't pass a null object into the expression made the error stop.