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);
}
