[]> OnDalLogExecuting { get; set; } public Action OnDalLogExecuted...{ get; set; } public Func> OnDalExecutingChangeSql...[], KeyValuePair>(OnExecutingChangeSql); _entityDB = context.GetEntityDB...[]> OnExecutingChangeSql(string sql, SugarParameter[] pars) //{ // return new KeyValuePair...(sql, pars); //} #endregion } HttpRuntimeCache
tVipPayFlow> flows = _db.Ado.SqlQuery(sql, new List() { new SugarParameter("@sa_date",...GetDataTable("sp_school",new{name="张三",age=0});// GetInt SqlQuery 等等都可以用 //支持output var nameP= new SugarParameter...("@name", "张三"); var ageP= new SugarParameter("@age", null, true);//isOutput=true var dt2 = db.Ado.UseStoredProcedure...ageP.value可以拿到返回值 Oracle游标 parameter.IsRefCursor =true; 我们还可以用 GetParameters 来简化参数操作 string p=null; SugarParameter
自定义类型支持自定义类型转换器下面只是讲解怎么定义转换器,ORM自带的功能就包含下面功能,只是用来讲解public class DictionaryConvert : ISugarDataConverter{public SugarParameter...就能实现这里只是用这个用例来给大家学习var name = "@myp" + i;var str = new SerializeService().SerializeObject(value);return new SugarParameter
SqlSugar.AdoProvider.GetDataReader(string sql, SugarParameter[] parameters) 如图: ?
下面只是讲解怎么定义转换器,ORM自带的功能就包含下面功能,只是用来讲解 public class DictionaryConvert : ISugarDataConverter { public SugarParameter...就能实现这里只是用这个用例来给大家学习 var name = "@myp" + i; var str = new SerializeService().SerializeObject(value); return new SugarParameter
at SqlSugar.AdoProvider.GetDataReader(String sql, SugarParameter[] parameters) at SqlSugar.QueryableProvider
领取专属 10元无门槛券
手把手带您无忧上云