Is there a way to map column names to properties from my entity using Dapper?

Question

c# dapper database stored-procedures

I'm considering in using dapper for my project, but first, I need to know if it:

1-) Can it map column name to my class properties? In my project, i have legacy tables that has no cool names.

2-) It works well with stored procedures? All my queryes relies on stored procedures. Its a company determination.

Thanks

View more on Stack Overflow

ipr101 · Accepted Answer · 3/29/2012 1:53:53 PM

To map column names to class properties you can do something like this -

class YourClass {
   public int id { get; set; }
   public string name { get; set; }
}

Then -

var yourclasscollection = connection.Query<YourClass>(@"select notcoolid as id, notcoolname as name from legacytable");

ipr101