I have just started implementing a data access layer using dyansql. My application is entirely configuration driven and has no knowledge of the schemas it is interacting with (beyond the configuration). I have run into a block when I have a dictionary of
function(string tableName, dictionary<string, object> updateValues, dictionary<string, object> whereValues)
DBQuery query = DBQuery.Update(tableName)
.Set(???) //Need to fill in my key value pairs from columnValues here
.WhereFieldEqual(???) //Need to fill in my key value pairs from updateValues here
I'm sure there is probably a way to do this and I am just missing something.