static void CreateClientsTable()
{
string sql = ""
+ "CREATE TABLE clients "
+ "(client_Id serial NOT NULL, "
+ "last_name Text NOT NULL, "
+ "first_name Text NOT NULL, "
+ "email Text NOT NULL, "
+ "CONSTRAINT client_pkey PRIMARY KEY (client_Id))";
var Model = new PGTable<Client>(_connectionStringName);
Model.Execute(sql);
}
static void DropTable(string tableName)
{
string sql = string.Format("DROP TABLE {0}", tableName);
var Model = new PGTable<dynamic>(_connectionStringName);
Model.Execute(sql);
}
void CreateWTFTable()
{
string sql = ""
+ "CREATE TABLE wtf "
+ "(\"CLient_Id\" serial NOT NULL, "
+ "\"Last Name\" Text NOT NULL, "
+ "\"first_name\" Text NOT NULL, "
+ "\"Email\" Text NOT NULL, "
+ "CONSTRAINT wtf_pkey PRIMARY KEY (\"CLient_Id\"))";
var Model = new PGTable<dynamic>(_connectionStringName);
Model.Execute(sql);
}
