private DbCommand GetDbCommandFromCommandText(DbUtility actualData) { DbCommand cmd = actualData.CreateDbCommand(); if (cmd != null) { cmd.CommandText = CommandText.Trim(); cmd.CommandTimeout = TimeOut; cmd.CommandType = (CommandType)Enum.Parse(typeof(CommandType), CommandType.ToString()); MatchCollection paramsName = Regex.Matches(CommandText, REGEX_GET_PARAMS, RegexOptions.IgnoreCase); MatchCollection localDefParams = Regex.Matches(CommandText, REGEX_GET_LOCAL_PARAMS, RegexOptions.IgnoreCase); var tempParams = new List <string>(); var tempLocalParams = new List <string>(); foreach (Match match in paramsName) { tempParams.Add(match.Value); } foreach (Match match in localDefParams) { tempLocalParams.Add(match.Value); } tempParams.RemoveAll(tempLocalParams.Contains); foreach (string match in tempParams) { if (!cmd.Parameters.Contains(match)) { DbParameter param = cmd.CreateParameter(); param.ParameterName = match; param.Direction = ParameterDirection.Input; param.DbType = DbType.String; cmd.Parameters.Add(param); } } return(cmd); } return(null); }
private DbCommand GetDbCommandFromCommandText(DbUtility actualData) { DbCommand cmd = actualData.CreateDbCommand(); if (cmd != null) { cmd.CommandText = CommandText.Trim(); cmd.CommandTimeout = TimeOut; cmd.CommandType = (CommandType) Enum.Parse(typeof (CommandType), CommandType.ToString()); MatchCollection paramsName = Regex.Matches(CommandText, REGEX_GET_PARAMS, RegexOptions.IgnoreCase); MatchCollection localDefParams = Regex.Matches(CommandText, REGEX_GET_LOCAL_PARAMS, RegexOptions.IgnoreCase); var tempParams = new List<string>(); var tempLocalParams = new List<string>(); foreach (Match match in paramsName) { tempParams.Add(match.Value); } foreach (Match match in localDefParams) { tempLocalParams.Add(match.Value); } tempParams.RemoveAll(tempLocalParams.Contains); foreach (string match in tempParams) { if (!cmd.Parameters.Contains(match)) { DbParameter param = cmd.CreateParameter(); param.ParameterName = match; param.Direction = ParameterDirection.Input; param.DbType = DbType.String; cmd.Parameters.Add(param); } } return cmd; } return null; }
private DbCommand GetDbCommand(DbUtility actualData) { DbCommand cmd = actualData.CreateDbCommand(); if (cmd != null) { cmd.CommandText = CommandText.Trim(); cmd.CommandTimeout = TimeOut; cmd.CommandType = (CommandType) Enum.Parse(typeof (CommandType), CommandType.ToString()); if (Parameters != null && Parameters.Param != null && Parameters.Param.Length > 0) { foreach (DataOperationsDataCommandParametersParam param in Parameters.Param) { cmd.Parameters.Add(param.GetDbParameter(cmd)); } } return cmd; } return null; }
private DbCommand GetDbCommand(DbUtility actualData) { DbCommand cmd = actualData.CreateDbCommand(); if (cmd != null) { cmd.CommandText = CommandText.Trim(); cmd.CommandTimeout = TimeOut; cmd.CommandType = (CommandType)Enum.Parse(typeof(CommandType), CommandType.ToString()); if (Parameters != null && Parameters.Param != null && Parameters.Param.Length > 0) { foreach (DataOperationsDataCommandParametersParam param in Parameters.Param) { cmd.Parameters.Add(param.GetDbParameter(cmd)); } } return(cmd); } return(null); }