Linq inner join

Linq join

var id = 1;
var query =
   from post in database.Posts
   join meta in database.Post_Metas on post.ID equals meta.Post_ID
   where post.ID == id
   select new { Post = post, Meta = meta };

Source: stackoverflow.com

Linq inner join

var dealercontacts = from contact in DealerContact
                     join dealer in Dealer on contact.DealerId equals dealer.ID
                     select contact;

Similar codes

81 votes413 views6 answers
Benoit Mandelbrot
C#
0 vote289 views1 answer
Get first word in string c#
C#
1 vote341 views1 answer
Convert int to binary in c#
C#
0 vote374 views1 answer
Unity predicts rigidbody position in x seconds
C#Unity
30 votes351 views3 answers
How to create a list in c# unity
C#
0 vote330 views1 answer
How to move an object flush in unity
C#
0 vote319 views1 answer
Rgb to console color
C#
0 vote367 views1 answer
C# entity framework code first connection string
C#
0 vote357 views1 answer
C# string to control name
C#
0 vote340 views1 answer
Reference variable from another script "winforms" c#
C#