c# dapper 动态参数

来源：互联网发布：天猫商城淘宝店编辑：程序博客网时间：2024/06/05 11:16

 string where = null;            var p = new DynamicParameters();            if (classId != null)            {                where = " and classId=:classId ";                p.Add("classId", classId);            }            if (key != null)            {                where = " and (name like :key or description like :key) ";                key = string.Format("%{0}%", key);                p.Add("key", key);            }       ```

        using (OracleConnection conn = DapperFactory.CrateOracleConnection())        {            DataSet ds = new DataSet();            for (int i = 0; i < sql.Count; i++)            {                DataTable dt = new DataTable();                if (paras != null)                {                    dt.Load(conn.ExecuteReader(sql[i], paras[i]));                }                else                {                    dt.Load(conn.ExecuteReader(sql[i]));                }                ds.Tables.Add(dt);            }            return ds;        }

“`

0 0