Dapper contrib: Why is the key not found?

Question

Dapper contrib: Why is the key not found?

c# dapper dapper-contrib

Question

I am trying to use the GetAll method of Dapper contrib. Even though I have set a Key in my entity, I get an exception:

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

My entity:

using Dapper.Contrib.Extensions;
public class Customer
{
    [Key]
    int Recid { get; set; }
    public string Name { get; set; }

    public Customer()
    {

    }
}

And my Dapper method:

public IEnumerable<Customer> GetAllCustomers()
{
    using (connection)
    {
        connection.Open();
        return connection.GetAll<Customer>();
    }
}

What am I doing wrong?

Maxime

View more on Stack Overflow

Maxime · Accepted Answer · 2/22/2018 9:55:02 AM

Accepted Answer

After fiddling around, I got it. The Key field need to be public:

using Dapper.Contrib.Extensions;
public class Customer
{
    [Key]
    public int Recid { get; set; }
    public string Name { get; set; }

    public Customer()
    {

    }
}

Maxime

Dapper contrib: Why is the key not found?

Question

Fastest Dapper Plus Extensions

Accepted Answer

Performance

Expression Evaluator