I am facing a trailing space issue in joining tables through Entity Framework. With this below post, I could handle the space trimming in Entity Framework level through the interceptor How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
However, I would not require this is in EF level. I need that just for a query.
I can see there is an AddInterceptor function. I don't know how to unsubscribe or remove the interceptor after the query execution.
Can someone help?
