我需要获得这个linq查询的sql查询,我使用linqpad。我使用变量调用与Id .When一起执行linq查询获取错误
)或预期表达式的结束(将多语句查询的查询语言更改为“C#语句”)
查询语言是C#表达式。
如何解决这个问题?
Id=110000;
from u in BusProvinces
where (from s in BusProvinces
join buscities in BusCities on s.Id equals buscities.ProvinceId
join buspath in BusPaths on buscities.Id equals buspath.DesId
where (buspath.DepId == Id || Id == 0)
select s.Id).Contains(u.Id)
select u

发布于 2017-07-17 11:23:29
问题是您在这里混合了两种类型的Query Languages。虽然Id=110000;是single-line statement,
from u in BusProvinces
where (from s in BusProvinces
join buscities in BusCities on s.Id equals buscities.ProvinceId
join buspath in BusPaths on buscities.Id equals buspath.DesId
where (buspath.DepId == Id || Id == 0)
select s.Id).Contains(u.Id)
select u是一个Expression。
简单的解决方案:将Linq表达式封装在var中。
var query = (from u in BusProvinces
where (from s in BusProvinces
join buscities in BusCities on s.Id equals buscities.ProvinceId
join buspath in BusPaths on buscities.Id equals buspath.DesId
where (buspath.DepId == Id || Id == 0)
select s.Id).Contains(u.Id)
select u);完整代码:
Id=110000;
var query = (from u in BusProvinces
where (from s in BusProvinces
join buscities in BusCities on s.Id equals buscities.ProvinceId
join buspath in BusPaths on buscities.Id equals buspath.DesId
where (buspath.DepId == Id || Id == 0)
select s.Id).Contains(u.Id)
select u);发布于 2017-07-17 11:10:13
将查询语言从代码编辑器上面的工具栏更改为C# statements:

https://stackoverflow.com/questions/45142515
复制相似问题