/// <summary> /// SqlNonQuery /// </summary> /// <param name="configExecutor"></param> /// <param name="parameters">sql的参数</param> /// <returns></returns> public static int NonQuery(this ILuaSqlConfigExecutor configExecutor, params IDataParameter[] parameters) { if (parameters?.Length > 0) { return(configExecutor.NonQueryUseDict(parameters.ToDictionary(l => l.ParameterName, l => l.Value))); } else { return(configExecutor.NonQueryUseDict(null)); } }
/// <summary> /// SqlNonQuery /// </summary> /// <param name="configExecutor"></param> /// <param name="parameters">sql的参数</param> /// <param name="policies">策略对象集合</param> /// <returns></returns> public static int NonQuery(this ILuaSqlConfigExecutor configExecutor, IDataParameter[] parameters, IDictionary <string, ISqlConfigPolicy> policies) { if (parameters?.Length > 0) { return(configExecutor.NonQueryUseDict(parameters.ToDictionary(l => l.ParameterName, l => l.Value), policies)); } else { return(configExecutor.NonQueryUseDict(null, policies)); } }
/// <summary> /// SqlNonQuery /// </summary> /// <param name="configExecutor"></param> /// <param name="paramsModel">sql的参数模型对象</param> /// <param name="ignoreProptsForParamModel">sql的参数模型对象中需要忽略的属性名</param> /// <returns></returns> public static int NonQueryUseModel(this ILuaSqlConfigExecutor configExecutor, object paramsModel, params string[] ignoreProptsForParamModel) { return(configExecutor.NonQueryUseDict( EFHelper.Services.ObjReflector.GetPublicInstanceProptValues(paramsModel, ignoreProptsForParamModel))); }
/// <summary> /// SqlNonQuery /// </summary> /// <param name="configExecutor"></param> /// <param name="paramsModel">sql的参数模型对象</param> /// <param name="ignoreProptsForParamModel">sql的参数模型对象中需要忽略的属性名</param> /// <param name="policies">策略对象集合</param> /// <returns></returns> public static int NonQueryUseModel(this ILuaSqlConfigExecutor configExecutor, object paramsModel, IEnumerable <string> ignoreProptsForParamModel, IDictionary <string, ISqlConfigPolicy> policies) { return(configExecutor.NonQueryUseDict( EFHelper.Services.ObjReflector.GetPublicInstanceProptValues(paramsModel, ignoreProptsForParamModel), policies)); }