Syntax for Entity Framework .Include()

Question

I am going crazy trying to get a handle on Linq include.

My main file is "Application" that has a GUID key of "Id" but I can't figure out the syntax to get it back without error.

public static Guid? ApplicationIdGet(string pApplicationName)
{
    return BrunoEntities.Set<AppApplication>().Include("Id").FirstOrDefault(p => p.LoweredName == pApplicationName.ToLower()).Id;
    //return BrunoEntities.AppApplications.Include(a => a.Id).FirstOrDefault(p => p.LoweredName == pApplicationName.ToLower()).Id;
    //return brunoEntities.AppApplications.Include("Id").FirstOrDefault(p => p.LoweredName == pApplicationName.ToLower()).Id;
}

Robert Levy · Accepted Answer · 2014-06-21 03:42:50Z

2

Include is for where you want EF to load in related entities. You don't need it to get normal properties of the entity you are requesting. If you do want to have EF only fetch certain columns from the database, the Select function will let you control that

answered Jun 21, 2014 at 3:42

Robert Levy

29.1k6 gold badges65 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax for Entity Framework .Include()

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related