I am attempting to map a column name that has a space in it. I am pretty restricted as far as bringing in any external dependency's or modifications to dapper. In my situation is there any tricks I can do, or should I manually query without dapper?
This works fine:
var sql = @"select top 1 person_id PersonId, first_name FirstName, last_name LastName from Person";
using (var conn = ConnectionFactory.GetConnection())
{
var person = conn.Query<Person>(sql).ToList();
return person;
}
Dapper has no facility that allows you to specify a Column Attribute, I am not against adding support for it, providing we do not pull in the dependency.
For some time, the following should work:
Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true;