public int ExecuteWithoutReplace(IDatabaseconnection _Idatabaseconnection)
{
var result = _Idatabaseconnection.SQLiteConnection.Insert(t);
return(result);
}
public T ExecuteSingle <T>(IDatabaseconnection _Idatabaseconnection) where T : new()
{
var result = _Idatabaseconnection.SQLiteConnection.Query <T>(_Query);
return(result.FirstOrDefault());
}
public int Execute <T>(IDatabaseconnection _Idatabaseconnection)
{
CreateTableResult result = _Idatabaseconnection.SQLiteConnection.CreateTable <T>();
return((int)result);
}
public List <T> Execute <T>(IDatabaseconnection _Idatabaseconnection) where T : new()
{
var result = _Idatabaseconnection.SQLiteConnection.Query <T>(_Query);
return(result);
}
public int Execute(IDatabaseconnection _Idatabaseconnection)
{
var result = _Idatabaseconnection.SQLiteConnection.Update(t);
return(result);
}
public DataLayer()
{
_databaseconnection = DatabaseConnection.Instance;
}
public int Execute(IDatabaseconnection _Idatabaseconnection)
{
var result = _Idatabaseconnection.SQLiteConnection.ExecuteScalar <int>(_Query);
return(result);
}
public int Execute(string tablename, IDatabaseconnection _Idatabaseconnection)
{
var result = _Idatabaseconnection.SQLiteConnection.Execute("delete from " + tablename);
return(result);
}
