public void CreateRecordInDatabase(DbRecord dbRecord)
{
string createQuery = BuildCreateString(dbRecord);
var odbcColumnParameters = dbRecord.Values.Select(t => new OdbcParameter(t.Key, t.Value)).ToArray();
using (OdbcWrapper odbcWrapper = new OdbcWrapper(connection.GetConnection() as OdbcConnection))
{
odbcWrapper.ExecuteNonQuery(createQuery, odbcColumnParameters);
}
}
public void UpdateRecordInDatabase(DbRecord dbRecord)
{
string updateQuery = BuildUpdateString(dbRecord);
var odbcColumnParameters = dbRecord.Values.Select(t => new OdbcParameter(t.Key, t.Value)).ToArray();
var odbcWhereParameters = dbRecord.Identifiers.Select(t => new OdbcParameter(t.Key, t.Value)).ToArray();
using (OdbcWrapper odbcWrapper = new OdbcWrapper(connection.GetConnection() as OdbcConnection))
{
odbcWrapper.ExecuteNonQuery(updateQuery, odbcColumnParameters.Concat(odbcWhereParameters).ToArray());
}
}
