title: How to trim values using Linq to Sql?
body: <p>In the database, I have a table called Contact.  The first name and other such string fields are designed to use a Char datatype (not my database design).  My object Contact maps to a string type in the properties.  If I wanted to do a simple test retrieving a Contact object by id, I would do something like this:</p>
  
  <pre><code>Contact contact = db.Contacts.Single(c =&gt; c.Id == myId);
  Contact test = new Contact();
  test.FirstName = "Martin";
  
  Assert.AreEqual(test.FirstName, contact.FirstName);
  </code></pre>
  
  <p>The contact.FirstName value is "Martin            " because of the char type.  Where can I intercept the FirstName property when it is being loaded?  OnFirstNameChanging(string value) does not get called on the initial load (contact), but does on the test object.</p>