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