void DropTransctionTable()
{
string sql = ""
+ "DROP TABLE Transactions ";
var Model = new SQLServerTable <Transaction>(_connectionString);
Model.Execute(sql);
}
// UTILITY METHODS:
void DropTransctionTable()
{
string sql = ""
+ "DROP TABLE Transactions ";
var Model = new SQLServerTable <Transaction>(CONNECTION_STRING_NAME);
Model.Execute(sql);
}
void CreateTransctionTable()
{
string sql = ""
+ "CREATE TABLE Transactions "
+ "(TransactionId int IDENTITY(1,1) PRIMARY KEY NOT NULL, "
+ "Amount Money NOT NULL, "
+ "Comment Text NOT NULL, "
+ "Identifier Text NOT NULL)";
var Model = new SQLServerTable <Transaction>(_connectionString);
Model.Execute(sql);
}
void DropTable(string tableName)
{
string sql = string.Format("DROP TABLE {0}", tableName);
var Model = new SQLServerTable<dynamic>(_connectionStringName);
Model.Execute(sql);
}
void CreateWTFTable()
{
string sql = ""
+ "CREATE TABLE WTF "
+ "(Client_Id int IDENTITY(1,1) PRIMARY KEY NOT NULL, "
+ "[Last Name] Text NOT NULL, "
+ "first_name Text NOT NULL, "
+ "Email Text NOT NULL)";
var Model = new SQLServerTable<dynamic>(_connectionStringName);
Model.Execute(sql);
}
