public DataAccessLayer()
{
string dbFilePath = GlobalConfiguration.Get("Data.DB.DbFilePath", "./TestDb.sqlite");
string connectionString = GlobalConfiguration.Get("Data.DB.ConnectionString", "Data Source='./TestDb.sqlite';Version=3;");
if (!File.Exists(dbFilePath))
{
SQLiteConnection.CreateFile(dbFilePath);
}
_dbConnection = new SQLiteConnection(connectionString);
}
