Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums How to join Multiple tables using Repository Pattern & Entity Framework? – MindStick
Ask Question

1 Answers

Pravesh Singh
Pravesh Singh 17 Dec 2013
Report Abuse

Hi Ashish, 


In EF, joining tables is done through the use of Navigation Properties. Basically, EF does it for you. When implementing in your Repositories, may it be Generic or not, you can call the Include method when building your query expression to tell EF to populate the navigation properties for you.


public class Dog
{
    public int DogId { get; set; }
    public string Name { get; set; }
    public int OwnerId { get; set;}
    public Owner Owner { get; set; } // the navigation property
}
public class Owner
{
    public int OwnerId { get; set; }
    public string Name { get; set; }
    // another navigation property
    // all the dogs that are related or owned by this specific owner
    public ICollection<Dog> DogList { get; set; }
    public ICollection<Cat> CatList { get; set; }
}


Here's a sample code snippet using Include:


public virtual IEnumerable<Dog> Retrieve()
{
    var _query = context.Dog.Include(a => a.Owner);
    ...
    ...// rest of your code
}


And for multiple tables you can nest the include method like so:



public virtual IEnumerable<Owner> Retrieve()
{
    // you can nest as many as you want if there are more nav properties
    var _query = context.Owner
        .Include(a => a.DogList)
        .Include(a => a.CatList);
    ...
    ...// rest of your code
}

Once you include nav properties  then that is basically joining those other tables. Just look at the SQL being generated by the query. Hope this helps!

MindStick Training
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md