Dapper contrib get data having varchar primary key

Question

I have a varchar key column. I am trying to use the Get method of Dapper contrib. I get an exception:

Get only supports an entity with a [Key] or an [ExplicitKey] property.

My Entity:

public class State : BaseModel
{
    [Key]       
    public string state_code { get; set; }
    public string state_name { get; set; }
    public int language_code { get; set; }
    public bool is_active { get; set; }
}

My Dapper Method

public IEnumerable<State> FindByCode(string code)
{
    return this._db.Get<State>(code);
}

I even tried to set Explicit Key, still I get the same error. What am I doing wrong?

Are you using `System.ComponentModel.DataAnnotations.KeyAttribute` or `Dapper.Contrib.Extensions.KeyAttribute`? — stuartd, Aug 27 '19 at 10:42
What do you have inside BaseModel? Are you sure you have tried with [ExplicitKey] from Dapper.Contrib.Extensions ? — Popa Andrei, Aug 27 '19 at 11:55
Right now there is nothing in BaseModel. It is created for general functionality. It is part of architecture. And Ya i had tried with [ExplicitKey] from Dapper.Contrib.Extensions but it give me same exception. — ros2008, Aug 27 '19 at 12:01
@ros2008 Why do you return IEnumerable since Get() returns only one object? Btw for me it's working with both [Key] and [ExplicitKey] — Popa Andrei, Aug 27 '19 at 12:11
can you please tell me which version of Dapper.Contrib you are using in your application? — ros2008, Aug 27 '19 at 12:20
How did you create the database? If you combine EF Core and `Dapper.Contrib`, you need to use both keys with `[Key]` under `System.ComponentModel.DataAnnotations` and `Dapper.Contrib.Extensions`. — Edward, Aug 28 '19 at 07:33

score 3 · Answer 1 · answered Aug 28 '19 at 07:33

Try to check your code like:

public class State : BaseModel
{
    [System.ComponentModel.DataAnnotations.Key]
    [Dapper.Contrib.Extensions.Key]
    public string state_code { get; set; }
    public string state_name { get; set; }
    public int language_code { get; set; }
    public bool is_active { get; set; }
}

Dapper contrib get data having varchar primary key

1 Answers1