public static IDbCommand CreateCommand(this IDbConnection connection, AdoOptions options)
{
if (options == null || options.CommandTimeout < 0) return connection.CreateCommand();
var command = connection.CreateCommand();
command.CommandTimeout = options.CommandTimeout;
return command;
}
public IDbCommand GetCommand(IDbConnection connection, AdoOptions options)
{
var command = connection.CreateCommand(options);
command.CommandText = Text;
SetParameters(command, string.Empty);
if (options != null)
{
command.CommandTimeout = options.CommandTimeout;
}
return(command);
}
public IDbCommand GetRepeatableCommand(IDbConnection connection, AdoOptions options)
{
var command = connection.CreateCommand(options);
command.CommandText = Text;
var parameterFactory = CreateParameterFactory(command);
foreach (var parameter in _parameters.Keys)
{
command.Parameters.Add(parameterFactory.CreateParameter(parameter.Name, parameter.Column));
}
if (options != null)
{
command.CommandTimeout = options.CommandTimeout;
}
return(command);
}
internal IDbCommand CreateCommand(ICommandBuilder[] commandBuilders, IDbConnection connection, AdoOptions options)
{
var command = connection.CreateCommand(options);
for (int i = 0; i < commandBuilders.Length; i++)
{
if (!string.IsNullOrWhiteSpace(command.CommandText))
{
command.CommandText += "; ";
}
command.CommandText += commandBuilders[i].Text;
SetParameters(command, commandBuilders[i].Parameters);
}
return(command);
}
internal IDbCommand CreateCommand(ICommandBuilder[] commandBuilders, IDbConnection connection, AdoOptions options)
{
var command = connection.CreateCommand(options);
for (int i = 0; i < commandBuilders.Length; i++)
{
if (!string.IsNullOrWhiteSpace(command.CommandText)) command.CommandText += "; ";
command.CommandText += commandBuilders[i].Text;
SetParameters(command, commandBuilders[i].Parameters);
}
return command;
}
public IDbCommand GetRepeatableCommand(IDbConnection connection, AdoOptions options)
{
var command = connection.CreateCommand(options);
command.CommandText = Text;
var parameterFactory = CreateParameterFactory(command);
foreach (var parameter in _parameters.Keys)
{
command.Parameters.Add(parameterFactory.CreateParameter(parameter.Name, parameter.Column));
}
if (options != null)
{
command.CommandTimeout = options.CommandTimeout;
}
return command;
}
public IDbCommand GetCommand(IDbConnection connection, AdoOptions options)
{
var command = connection.CreateCommand(options);
command.CommandText = Text;
SetParameters(command, string.Empty);
if (options != null)
{
command.CommandTimeout = options.CommandTimeout;
}
return command;
}
