问个关于Linq查询语句的写法Canyin=dbCtxt.tCanYin.Single(p=>p.CustomerID==ctid);这句是查询tCanYin表中字段CustomerID等于ctid的那行数据就等于是select*fromtCanYinwhereCustomerID=@ctid我想再加个

Question

问个关于Linq查询语句的写法Canyin = dbCtxt.t_CanYin.Single(p => p.CustomerID == ctid); 这句是查询t_CanYin表中字段CustomerID等于ctid的那行数据 就等于是select * from t_CanYin where CustomerID = @ctid 我想再加个条件tName = N的话,应该怎么做? 也就是select * from t_CanYin where CustomerID = @ctid and tName = @N

Answer 1

用&& 连接就行了 CustomerID = ctid && tName = N 如果查询的值不是唯一的就要把Single换成where了