Dapper and user defined database types

Question

Let's say I have a user defined data type in the database: MySuperType which as two bigint properties in it (Id + Code)

And I have a stored procedure which takes in those parameters:

@MySuperType, @Price, @dateModified, etc...

Now in my code, I am using Dapper like this:

using (var connecion = new SqlConnection(_connectionString))
{
    result = connection.Execute("SP_name", 
                new {mySuperType, price, date}, 
                commandType: CommandType.StoredProcedure);
}

But I keep getting an error

Type Operand clash: Dapper is not able to map the user defined type: MySuperType from the parameters to the stored procedure.

Changing the stored procedure or replacing the user-defined type isn't an option

Does anyone have an idea what I can do to map the types and send the parameters (all of them) to the stored procedure?

madoxdev · Accepted Answer · 2017-02-14 10:04:04Z

1

Tha names of parameters must correspond to parameters defined in procedure:

using (var connecion = new SqlConnection(_connectionString))
        {
            result = connection.Execute("SP_name", 
                new {MySuperType = mySuperType, Price = price, dateModified = date}, 
                commandType: CommandType.StoredProcedure);
        }

Dapper is case sensitive in mapping in 2 directions (as parameters and as results).

If you want to avoid specifying names of the parameters, make sure you have it exactly same in variables in c# and stored procedure.

edited Feb 14, 2017 at 10:04

answered Feb 14, 2017 at 9:39

madoxdev

3,9301 gold badge26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dapper and user defined database types

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related