Query With Join

Question

I'm working with C# MVC3 and Entity Framework. I have a table that contains 2 FK's. So, I want to execute this query:

SELECT *
  FROM TABLE1 f,
       TABLE2       r,
       TABLE3       c
 WHERE f.codx = r.codx
   AND f.cody = c.cody

TABLE1 = Contains FK's

So, I need to Include at his DbSet a reference the tables.... But, How can I add two tables at my DbSet? The problem that I receive this DbSet from another class, and add in my query:

return ((from table1 in this.GetContext<Fake>().TABLE1.Include("TABLE2") //Here I need to Include another table, was working with just one
        where (
      ............. )
        select).ToList<Table1>());

How can I do this?

Thanks!

Mike Christensen · Accepted Answer · 2012-07-11 20:22:50Z

1

You can chain multiple .Include methods together:

return ((from table1 in this.GetContext<Fake>().TABLE1.Include("TABLE2").Include("TABLE3")
        where (
      ............. )
        select).ToList<Table1>());

answered Jul 11, 2012 at 20:22

Mike Christensen

91.8k52 gold badges223 silver badges349 bronze badges

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

2 Comments

Lücks Over a year ago

But, I'll not Include Table3 ON table2?

Mike Christensen Over a year ago

The order is not relevant. All the mappings are known through the model.

Collectives™ on Stack Overflow

Query With Join

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related