private int GetRowCount(TableDefintion tableDefinition)
{
string cmd = string.Format("SELECT COUNT(*) FROM {0};", tableDefinition.GetFullQualifiedName());
using (var sqlCommand = new SqlCommand(cmd))
{
sqlCommand.Connection = connection;
sqlCommand.Transaction = transaction;
return((Int32)sqlCommand.ExecuteScalar());
}
}
private int CreateTable(TableDefintion tableDefinition)
{
string cmd = string.Format("CREATE TABLE {0}(ColInt32 int, ColString varchar(50));", tableDefinition.GetFullQualifiedName());
using (var sqlCommand = new SqlCommand(cmd))
{
sqlCommand.Connection = connection;
sqlCommand.Transaction = transaction;
return(sqlCommand.ExecuteNonQuery());
}
}
private SqlDataReader GetAllRaw(TableDefintion tableDefinition)
{
string cmd = string.Format("SELECT * FROM {0};", tableDefinition.GetFullQualifiedName());
using (var sqlCommand = new SqlCommand(cmd))
{
sqlCommand.Connection = connection;
sqlCommand.Transaction = transaction;
return(sqlCommand.ExecuteReader());
}
}
private List <TestEntity> GetAll(TableDefintion tableDefinition)
{
var results = new List <TestEntity>();
using (var reader = GetAllRaw(tableDefinition))
{
while (reader.Read())
{
results.Add(new TestEntity
{
Int32 = reader.GetInt32(reader.GetOrdinal("ColInt32")),
String = reader.GetString(reader.GetOrdinal("ColString"))
});
}
}
return(results);
}
protected override void OnSetupInTransaction()
{
tableDefinition = new TableDefintion("UnitTest", "BulkInsertSample");
}
protected override void OnSetupInTransaction()
{
tableDefinition = new TableDefintion("UnitTest", "BulkInsertSample");
subject = new SqlServerBulkInsert <TestEntity>(new TestEntityMapping());
}
