1、where条件查询语法,匹配SQL语句where条件
var query = (from t in ry_GoodsInfo
where (string.IsNullOrEmpty(typeId) || t.GoodsTypeID == typeId) //判断条件是否为空
select t
2、 like ‘%%’ 条件
var ss =from rin db.Am_recProScheme
where r.SortsText.Contains("张")
select r;
3、join连接语法
a、匹配SQL inner join... on... 语句
var query = (from t in ry_GoodsInfojoin p in ry_GoodsType on t.GoodsTypeID equals p.Id.ToString()
select new
{...
};
b、匹配SQL left join... on... 语句
var query = (from t in ry_GoodsInfo