public void AddParameter()
{
InsertCommandBuilder builder = new InsertCommandBuilder(TestSettings.CreateConnection());
builder.TableName = "Table1";
builder.AddParameter("p1", DbType.Date);
builder.AddParameter("p2", typeof(DateTime));
builder.AddParameter("p3", 1);
builder.AddParameter("p4", "par4", true);
IDbCommand command = builder.Build();
Assert.AreEqual(command.CommandType, CommandType.Text);
Assert.IsNotNull(command.Parameters["@p1"]);
Assert.IsNotNull(command.Parameters["@p2"]);
Assert.IsNotNull(command.Parameters["@p3"]);
Assert.IsNotNull(command.Parameters["@par4"]);
}
public void Test()
{
DBConnection connection = TestSettings.CreateConnection();
InsertCommandBuilder builder = new InsertCommandBuilder(connection);
builder.TableName = "Table1";
builder.AddParameter("value", "1");
IDbCommand command = builder.Build();
Assert.IsNotNull(command);
Assert.AreEqual(1, connection.ExecuteNonQuery(command));
}
/// <summary>
/// Creates the insert command.
/// </summary>
/// <returns></returns>
private void CreateInsertCommand()
{
var builder = new InsertCommandBuilder(_connection.Factory);
builder.TableName = TableName;
foreach (PropertyInfo field in _fields)
{
builder.AddParameter(field.Name, field.PropertyType);
}
_insertCommand = builder.Build();
//insertCommand.Prepare();
}
private SendParameter PreparePrimitive(Type parameterType)
{
var builder = new CreateTableCommandBuilder(_connection.Factory)
{
TableName = TableName
};
builder.AddColumn("value", parameterType);
_connection.ExecuteNonQuery(builder.Build());
var builderInsert = new InsertCommandBuilder(_connection.Factory)
{
TableName = TableName
};
builderInsert.AddParameter("value", parameterType);
_insertCommand = builderInsert.Build();
//insertCommand.Prepare();
return(SendPrimitive);
}