EntityFramework 6 DatabaseFirst disable lazy loading

Viewed 1072

How disable all lazy loading

After generation model from database first I have

public partial class company
{
    public int id { get; set; }
    public string name { get; set; }
    public virtual ICollection<user> user { get; set; }
}

public partial class user
{
    public int id { get; set; }
    public int company_id { get; set; }
    public virtual company company { get; set; }
}

I want load only user and their company

db = new Entities();
db.Configuration.ProxyCreationEnabled = false;
db.Configuration.LazyLoadingEnabled = false;
var result = db.user.Include(x => x.company).ToList();

I don`t want load result[0].company.user

Now collection filled with all users of company

result[0].company.user must be null

if i want load result[0].company.user I want use .Include(x => x.company.user)

1 Answers
Related