public void Update(string table, IRecord record)
{
using (var cnn = new SQLiteConnection(LoadConnectionString()))
{
cnn.Execute($"UPDATE {table} ({record.AllColumns()}) VALUES ({record.AtAllColumns()}) WHERE id={record.Id};", record);
}
}
public void Create(string table, IRecord record)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
var str = $"INSERT INTO {table} ({record.AllColumns()}) Values ({record.AtAllColumns()});";
cnn.Execute(str, record);
}
}
