private DataTable Select(string query)
{
using (var guard = new ConnectionGuard(Connection))
{
var dt = new DataTable();
var adapter = new SQLiteDataAdapter(query, Connection as SQLiteConnection);
adapter.Fill(dt);
return(dt);
}
}
private bool Update(string query, params object[] args)
{
using (var guard = new ConnectionGuard(Connection))
{
var command = Connection.CreateCommand();
command.CommandText = string.Format(query, args);
var count = command.ExecuteNonQuery();
return(count != 0);
}
}
private uint Insert(string query, params object[] args)
{
using (var guard = new ConnectionGuard(Connection))
{
var command = Connection.CreateCommand();
command.CommandText = String.Format(query, args);
command.ExecuteNonQuery();
command.CommandText = "select last_insert_rowid()";
var id = (uint)(long)command.ExecuteScalar();
return(id);
}
}
