Breaking News: Grepper is joining You.com. Read the official announcement!

join linq lambda

Black Bison answered on February 4, 2021 Popularity 10/10 Helpfulness 4/10

answer join linq lambda

join linq lambda

Comment

var id = 1;
var query = database.Posts    // your starting point - table in the "from" statement
   .Join(database.Post_Metas, // the source table of the inner join
      post => post.ID,        // Select the primary key (the first part of the "on" clause in an sql "join" statement)
      meta => meta.Post_ID,   // Select the foreign key (the second part of the "on" clause)
      (post, meta) => new { Post = post, Meta = meta }) // selection
   .Where(postAndMeta => postAndMeta.Post.ID == id);    // where statement

Popularity 10/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: join lambda linq whatever

Link to this answer
Share Copy Link