title: Trim String with Dapper.NET
body: <p>I have been using <code>Dapper.NET</code> for a while now. I was just wondering if it's possible to get Dapper to trim strings as it assigns them to the properties of the object.</p>
  
  <p>I currently use <code>LTRIM(RTRIM(fieldname))</code> in the SQL, and / or <code>value.Trim()</code> in the property setter.</p>
  
  <p>I am however working with a legacy database that uses chars instead of varchar, and I was wondering if there was a way to reduce my time of having to trim everything.</p>
  
  <p>I had a go myself by editing the source code of dapper but ended up breaking other mappings etc so gave in.</p>
  
  <p>Just wondered if anyone had any suggestions that could reduce this overhead. (I may be missing something very simple!)</p>
  
  <p>I am working with C# 3.5 by the way.</p>