public void CreateDatabaseIfNotExist(string dbGenerationProcedure, string initialDataProcedure, string tableName, ConnectionData connectionData)
{
if (!File.Exists(connectionData.SQLiteFilePath) || !DoesTableExist(tableName, connectionData))
{
CreateInitialDatabase(dbGenerationProcedure, initialDataProcedure, connectionData);
}
}
private static void CreateInitialDatabase(string dbGenerationProcedure, string initialData, ConnectionData connectionData)
{
using (IDbConnection connection = new SqliteConnection(connectionData.SQLiteConnectionString))
{
connection.Open();
connection.Execute(dbGenerationProcedure);
}
CreateInitialContent(initialData, connectionData);
}
public async Task <List <T> > LoadData <T, U>(string procedure, U parameters, ConnectionData connectionData)
{
using (IDbConnection connection = new SqliteConnection(connectionData.SQLiteConnectionString))
{
var result = await connection.QueryAsync <T>(procedure, parameters);
return(result.ToList());
}
}
