两表
SQL to Linq
SQL:
strQuery = "SELECT A.*, B.LABEL_DESC FROM LBLMATREL A, LBLDEF B"
+ " WHERE A.FACTORY = B.FACTORY"
+ " AND A.LABEL_ID = B.LABEL_ID"
+ " AND A.FACTORY=?"
+ " AND A.MAT_ID=?"
+ " AND A.MAT_VER=?"
+ " AND A.LABEL_ID>=?"
+ " ORDER BY A.FACTORY ASC"
+ " , A.MAT_ID ASC"
+ " , A.LABEL_ID ASC";
Linq语句:
var listResult=ctx.Lblmatrel.Where(t => t.Factory == sFactory && t.MatId == sMatId && t.MatVer == iMatVer && //查询条件拼接
t.LabelId.CompareTo(sLabelId) >= 0).Join( //连接外表