public static void Main(string[] args)
{
// Instanciation de la configuration
Config conf = new Config();
// Création du mapper via
DboMapper mapper = new DboMapper(conf);
// Exécution de la requête List()
List <Author> lst = DboMapper.List <Author>(@"SELECT * FROM author", new List <DboParameter>());
// Exécution de la requête List()
List <DboParameter> param = new List <DboParameter>();
param.Add(new DboParameter("@name", "Victor Hugault"));
DboMapper.Execute(@"INSERT INTO author (name) VALUES (@name);", param);
}
public void init()
{
database = new DboMapper("localhost", "1433", "devdb", "sa", "P@55w0rd", DatabaseType.MSSql);
string insertReq = @"INSERT INTO contacts (name, address, email) VALUES (@name, @address, @email)";
List <DbParameter> insertParameters = new List <DbParameter>();
insertParameters.Add(new SqlParameter("@name", "test case name"));
insertParameters.Add(new SqlParameter("@address", "test case azddress"));
insertParameters.Add(new SqlParameter("@email", "*****@*****.**"));
database.Execute <Contacts>(insertReq, insertParameters);
string insertReq2 = @"INSERT INTO contacts (name, address, email) VALUES (@name, @address, @email)";
List <DbParameter> insertParameters2 = new List <DbParameter>();
insertParameters2.Add(new SqlParameter("@name", "changed name"));
insertParameters2.Add(new SqlParameter("@address", "ADDRESS CHANGED FOR TEST"));
insertParameters2.Add(new SqlParameter("@email", "*****@*****.**"));
database.Execute <Contacts>(insertReq2, insertParameters2);
}
private static void PostgreSql()
{
// Creating the database. IF YOU WANT TO TEST IT, DON'T FORGET TO CHANGE THESE PARAMETERS
DboMapper database = new DboMapper("localhost", "5432", "devdb", "postgres", "root", DatabaseType.PostgreSql);
//Simple mapping takes only SELECT
string selectReqWithListFunction = "SELECT * FROM contacts";
List <Contacts> listMadeByListFunction = database.List <Contacts>(selectReqWithListFunction);
foreach (var item in listMadeByListFunction)
{
Console.WriteLine(item.name, item.address, item.email);
}
Console.ReadKey();
Console.Clear();
// Calling the Execute Function by giving him a INSERT Statement with parameters
string insertReq = @"INSERT INTO contacts (name, address, email) VALUES (@name, @address, @email)";
List <DbParameter> pInsert = new List <DbParameter>();
pInsert.Add(new NpgsqlParameter("@name", "TEST CASE"));
pInsert.Add(new NpgsqlParameter("@address", "RUE DU TEST"));
pInsert.Add(new NpgsqlParameter("@email", "*****@*****.**"));
List <Contacts> contactsInsert = database.Execute <Contacts>(insertReq, pInsert);
// Calling the Execute Function by giving him a SELECT Statement with parameters
string selectReqWithParameters = @"SELECT * FROM contacts WHERE email = @email";
List <DbParameter> pSelect = new List <DbParameter>();
pSelect.Add(new NpgsqlParameter("@email", "*****@*****.**"));
List <Contacts> contactsSelectWithParameter = database.Execute <Contacts>(selectReqWithParameters, pSelect);
foreach (var item in contactsSelectWithParameter)
{
Console.WriteLine(item.name, item.address, item.email);
}
Console.ReadKey();
Console.Clear();
// Calling the Execute Function by giving him a UPDATE Statement with parameters
string updateReq = @"UPDATE contacts SET name = @name, address = @address, email = @email WHERE email = @oldEmail";
List <DbParameter> pUpdate = new List <DbParameter>();
pUpdate.Add(new NpgsqlParameter("@name", "NAME CHANGED FOR TEST"));
pUpdate.Add(new NpgsqlParameter("@address", "ADDRESS CHANGED FOR TEST"));
pUpdate.Add(new NpgsqlParameter("@email", "*****@*****.**"));
pUpdate.Add(new NpgsqlParameter("@oldEmail", "*****@*****.**"));
List <Contacts> contactsUpdate = database.Execute <Contacts>(updateReq, pUpdate);
// Calling the Execute Function by giving him an SELECT Statement
String selectReq = @"SELECT * FROM CONTACTS";
List <Contacts> contactsSelect = database.Execute <Contacts>(selectReq, pSelect);
foreach (var item in contactsSelect)
{
Console.WriteLine(item.name, item.address, item.email);
}
Console.ReadKey();
Console.Clear();
// Calling the Execute Function by giving him a DELETE Statement with parameters
string deleteReq = @"DELETE FROM contacts WHERE address = @address";
List <DbParameter> pDelete = new List <DbParameter>();
pDelete.Add(new NpgsqlParameter("@address", "ADDRESS CHANGED FOR TEST"));
List <Contacts> contactsDelete = database.Execute <Contacts>(deleteReq, pDelete);
// Calling the Execute Function by giving him a SELECT Statement
contactsSelect = null;
contactsSelect = database.Execute <Contacts>(selectReq, pSelect);
foreach (var item in contactsSelect)
{
Console.WriteLine(item.name, item.address, item.email);
}
Console.WriteLine("Test is finished, you can click on enter to close this tab.");
Console.ReadKey();
}
