Dapper Tutorial - Knowledge Base (KB)

Unable to run update statement using Dapper (parameters error)

I am trying to update a row using Dapper but I am having error on specifying parameters in my update statement...An exception of type 'System.InvalidOperationException' occurred in IBM.Data.DB2.iSeries.dll but was not handled in user code Additional infor...

Insert error with dapper dot net Cannot update identity column

I'm new add dapper dot net so do forgive me if this question is quite easy for you....I have my object wich I would like to save to te database. But when I execute my update command I get an error saying that I cannot update the identy column. ...I'm not ...

Use Dapper.Contrib Update, with classes that have special helper properties

I am new to ...Dapper... and ...Dapper.Contrib.... There is a class like this and there is a table in database with the same name:...public class Ware { public int ID { get; set; } public string Name { get; set; } public short UnitID {...

Dapper Execute function that can call PostgreSQL function and return rows affected from update or insert

I am trying to create a postgresql function that does an update. I want to get the rows affected. I know this can be done by using ...GET DIAGNOSTICS rows_affected = ROW_COUNT.... But I am trying to use the Dapper ...Execute... function which can return r...

How correctly declare variables in SQL update request with Dapper when it isn't an object?

I would like to do this request : ...public int UpdateOneColumn(string dbName, string tableName, string columnName, string newValue, string whereColumnName, string whereColumnNameValue) { string sql = @"update @tableName set @columnName = @newValue wh...