public void TestBulkLoadOnStoredProcedureCommand()
{
using (NuoDbConnection connection = new NuoDbConnection(TestFixture1.connectionString))
{
connection.Open();
new NuoDbCommand("drop table temp if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create table temp (col string)", connection).ExecuteNonQuery();
new NuoDbCommand("drop procedure nunit_test if exists", connection).ExecuteNonQuery();
new NuoDbCommand("create procedure nunit_test(input_data string) " +
" as " +
" insert into temp values (input_data); " +
" end_procedure", connection).ExecuteNonQuery();
DataTable metadata = new DataTable("dummy");
metadata.Columns.Add("xyz", typeof(string));
DataRow[] rows = new DataRow[10];
for (int i = 0; i < rows.Length; i++)
{
rows[i] = metadata.NewRow();
rows[i][0] = Convert.ToString(i);
}
NuoDbCommand loader = new NuoDbCommand(connection);
loader.CommandType = CommandType.StoredProcedure;
loader.CommandText = "nunit_test";
loader.ExecuteBatch(rows);
DbCommand command = new NuoDbCommand("select count(*) from temp", connection);
object val = command.ExecuteScalar();
Assert.AreEqual(10, val);
command = new NuoDbCommand("select col from temp", connection);
val = command.ExecuteScalar();
Assert.AreEqual("0", val);
}
}