enum handling on insert with dapper

Question

How can i make dapper use the string value of an enum. In the example below it uses the numerical value of the enum. On read from the database, dapper correctly converts string to enum.

public enum Category { A, B }

public Product 
{ 
    public Category Cat {get;set;}
    public int Id {get;set;}
}

Product p  = new Product() {Cat = Category.A, Id=22} ;
connection.Execute("Insert into Products (Cat, Id) Values ",p);

In this case in the database in the column Cat I have value 1 instead of A

Not sure if you can. You cannot with EF, think that Enum are internally represented as numeric values, the name is just something you use from C# code. — Juan
– Juan, Commented Mar 6, 2015 at 16:30

stefankmitph · Accepted Answer · 2015-03-09 13:03:05Z

2

The easiest way I think is:

connection.Execute("Insert into Products (Cat, Id) Values ", new { p.Id, Cat = p.Cat.ToString());

answered Mar 9, 2015 at 13:03

stefankmitph

3,3062 gold badges20 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

enum handling on insert with dapper

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