我遇到了用LINQ和Lambda编写的查询的麻烦。到目前为止，我得到了很多错误，这是我的代码:
int id = 1;
var query = database.Posts.Join(database.Post_Metas,
post => database.Posts.Where(x => x.ID == id),
meta => database.Post_Metas.Where(x => x.Post_ID == id),
(post, meta) => new { Post = post, Meta = meta });
我不确定这个问题是否正确。
当前回答
可能是这样的
var myvar = from a in context.MyEntity
join b in context.MyEntity2 on a.key equals b.key
select new { prop1 = a.prop1, prop2= b.prop1};
其他回答
Daniel很好地解释了语法关系，但是为了让我的团队更容易理解，我把这个文档放在一起。希望这对大家有所帮助
可能是这样的
var myvar = from a in context.MyEntity
join b in context.MyEntity2 on a.key equals b.key
select new { prop1 = a.prop1, prop2= b.prop1};
我发现如果你熟悉SQL语法，使用LINQ查询语法会更清晰、更自然，并且更容易发现错误:
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 };
如果您真的坚持使用lambdas，那么您的语法就有很大的问题。下面是相同的查询，使用LINQ扩展方法:
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
您的键选择器不正确。它们应该接受与所讨论的表类型相同的对象，并返回在连接中使用的键。我想你的意思是:
var query = database.Posts.Join(database.Post_Metas,
post => post.ID,
meta => meta.Post_ID,
(post, meta) => new { Post = post, Meta = meta });
您可以随后应用where子句，而不是作为键选择器的一部分。
1 = 1两个不同的表连接
var query = from post in database.Posts
join meta in database.Post_Metas on 1 equals 1
where post.ID == id
select new { Post = post, Meta = meta };
