sql sugar 查询学习记录

使用where 参数化查询 使用元组

    var where1 = " ( lower(asset_status) = @asset_status0 ) and ( lower(asset_domain_id) in (@asset_domain_idIn0) ) ";
    var dic = new Dictionary<string, object>();
    dic.Add("asset_status", "1");
    dic.Add("asset_domain", "acs");
    var pa = new ValueTuple<string,object>(where1, dic);
    var list4 = _db.Queryable<AssetMsrtAndCheckdetView>().Where(pa.Item1, pa.Item2).ToList();