Articles

Include

Include...In Entity Framework, the ...Include... method loads the related objects to include in the query results. It can be used to retrieve some information from the database and also want to include related entities....We have a simple model which contains two entities....public class Book { public int Id { get; set; } public string Title { get; set; } public int AuthorId { get; set; } [ForeignKey("AuthorId")] public Author Author { get; set; } } public class Author { ...

Include Multiple Levels

Include Multiple Levels...How to Include multiple levels?...Eager loading is the process whereby a query for one type of entity also loads related entities as part of the query. Eager loading is achieved by use of the Include method....The Include() method works quite well for Lists on objects, but what if there is a need for multiple levels of depth. For example, Customer contains a list of invoices and each invoice then contains a list of items....StackOverflow Related Questions...Entity Frame...

Include with Where Clause

Include With Where Clause...How to Include with Where clause?...To retrieve some information from the database and also want to include related entities conditionally. For example, if we have a simple model containing two entities, Customers, and Invoices. Now to retrieve any customer information and also include all the invoices of that customer generated in last seven days....using (var context = new EntityContext()) { var fromDate = DateTime.Now.AddDays(-7); var customer = context.Cu...

When to use Include

When to Use Include...When to use Include() with Entity Framework?...When to use Include with Entity Framework and is it related to lazy loading?...Answer...Before jumping into the answer of when to use Include, let's have a look at the following simple example which contains three entities....public class Customer { public int CustomerID { get; set; } public string Name { get; set; } public virtual List<Invoice> Invoices { get; set; } } public class Invoice { public int InvoiceID { get; se...