private IEnumerable <T> PerformFind(string whereClause)
{
IEnumerable <T> models;
using (var connection = GetDatabaseConnection())
{
connection.Open();
Logger.Verbose($"{RepositorySql.GetFindStatement()} {whereClause}");
models = connection.Query <T>($"{RepositorySql.GetFindStatement()} {whereClause}");
}
return(models);
}
private IEnumerable <T> PerformFetch(T model)
{
IEnumerable <T> models;
using (var connection = GetDatabaseConnection())
{
connection.Open();
Logger.Verbose(RepositorySql.GetFetchStatement());
models = connection.Query <T>(RepositorySql.GetFetchStatement(), model);
}
return(models);
}
private int?PerformInsert(T model)
{
int?id;
using (var connection = GetDatabaseConnection())
{
connection.Open();
Logger.Verbose(RepositorySql.GetCreateStatement());
id = connection.Query <int>(RepositorySql.GetCreateStatement(), model).First();
}
return(id);
}
private int PerformDelete(T model)
{
int rows = 0;
using (var connection = GetDatabaseConnection())
{
connection.Open();
Logger.Verbose(RepositorySql.GetDeleteStatement());
rows = connection.Execute(RepositorySql.GetDeleteStatement(), model);
}
return(rows);
}
private int PerformUpdate(T model)
{
int rows = 0;
using (var connection = GetDatabaseConnection())
{
connection.Open();
Logger.Verbose(RepositorySql.GetUpdateStatement());
Logger.Verbose($"ID: {GetId(model)}, GUID: {GetGuid(model)}");
rows = connection.Execute(RepositorySql.GetUpdateStatement(), model);
}
return(rows);
}
