Dapper Orm delete exception

Question

I'am triying to delete with dapper orm. But im getting this exception:

When using the multi-mapping APIs ensure you set the splitOn param if you have keys other than Id

My code is shown below:

public void DeleteRole(int ID)
    {
        using (var conn = new SqlConnection(connectionString))
        {
            conn.Open();
            conn.Query("DELETE FROM [Role] WHERE ID=@ID", new {ID=ID });
        }
    }

Any idea?

The code changed drastically on your edit. Is this the code that's throwing? And why are you using Query here instead of Execute? — Mike Perrenoud

Sergey Berezovskiy Sergey Berezovskiy · Accepted Answer · 2013-11-21T10:17:39

Either specify return type for query (integer)

int rowsCount = conn.Query<int>("DELETE FROM [Role] WHERE ID = @ID", new { ID });

Or use Execute method, as Michael pointed

NOTE: You don't need to open connection manually - Dapper will open it for you.

BTW generic query will work for your original question:

int id = conn.Query<int>(@"INSERT [Role] (Name, CreatedDate,UpdatedDate) 
                           VALUES (@Name, @CreatedDate,@UpdatedDate) 
                           SELECT CAST(scope_identity() as INT)", model).First();

Dapper Orm delete exception

2 Answers