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); } }