How to automate trimming strings in Entity Framework

When working with legacy data where the data being loaded into SQL server tables contains trailing spaces, the trailing spaces will remain in the fields regardless of whether the fields are varchar  This poses problems when doing compares or extracting data to files as you may not get the results you are looking for.

One solution would be to add a trim to each field where this occurs.  This will result in having trims scattered all over your code base.

Another and better solution would be to add an interception for Entity Framework that will trim all fields of certain data types.

String Interceptor class

StringTrimmerInterceptor

As you can see, this will trim fields of types nvarchar, varchar, char, and nchar.  In the SQL generated, it will add a LTRIM and RTRIM to each field.

To implement this interceptor, you just need to register it in a separate class within the same assembly.

EfConfiguration

I found this solution based on Rowan Miller’s EF6.1–Workaround Trailing Blanks Issue In String Joins

Speak Your Mind

*