private static IDbDataParameter CreateSingleParameter(IDbParameterFactory parameterFactory, object value, string name, Column column)
{
var parameter = parameterFactory.CreateParameter(name, column);
parameter.Value = CommandHelper.FixObjectType(value);
return(parameter);
}
public static void SetParameterValues(this IDbCommand command, IList <object> values)
{
int index = 0;
foreach (var parameter in command.Parameters.Cast <IDbDataParameter>())
{
parameter.Value = CommandHelper.FixObjectType(values[index]);
index++;
}
}
private static IDbDataParameter CreateSingleParameter(IDbParameterFactory parameterFactory, object value, ParameterTemplate template)
{
if (template.Column != null)
{
return(CreateSingleParameter(parameterFactory, value, template.Name, template.Column));
}
var parameter = parameterFactory.CreateParameter(template.Name, template.DbType, template.MaxLength);
parameter.Value = CommandHelper.FixObjectType(value);
return(parameter);
}
public static void SetParameterValue(this IDbCommand command, int index, object value)
{
((IDbDataParameter)command.Parameters[index]).Value = CommandHelper.FixObjectType(value);
}
