DEV Community

How to map column names to class properties with Dapper

Michel on February 18, 2020

Last week, I used Dapper instead of NHibernate to perform a simple processing on a table in our Oracle database. Since this is an ancient table, th...

Read full post

Evaldas Buinauskas • Feb 18 '20 • Edited

I do prefer to do it slightly different by keeping classes clean. This code could still break if someone changes alias and keeps description attribute untouched.

You can assign correct aliases by using nameof(Class.PropertyName) within your query string. This guarantees that column names are mapped correctly and makes refactoring so much easier in case you want to change a property name.

var sql = $@"
    SELECT Contact_Cli_ID AS {nameof(Contact.Contact_ID)},
        Clt_ID AS {nameof(Contact.Client_ID)},
        Contact_Cli_Nom AS {namoef(Contact.Nom)},
        Contact_Cli_Prenom AS {nameof(Contact.Prenom)},
        Contact_Tel_Fixe AS {nameof(Contact.Telephone)},
        Contact_Cli_Fax AS {nameof(Contact.Telecopie)},
        Contact_Cli_Mail AS {nameof(Contact.Mail)},
        Contact_Portable AS {nameof(Contact.Portable)}
    FROM Contact_Clients
    ...";

Then your class can stay as is.
🙂

public class Contact
{
  public int Contact_ID { get; set; }
  public int Client_ID { get; set; }
  public string Nom { get; set; }
  public string Prenom { get; set; }
  public string Telephone { get; set; }
  public string Telecopie { get; set; }
  public string Mail { get; set; }
  public string Portable { get; set; }
}