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 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 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());
}
}
