MsSqlCe40Dialect trim function bug

Description

When using a Linq statement "Where(x=>x.Name.Trim().ToLowerInvariant()==name)" against MsSqlCe40Dialect, it gets translated into incorrect sql statement.
Register the trim function in MsSqlCe40Dialect with the following fix the problem: RegisterFunction("trim", (ISQLFunction)new AnsiTrimEmulationFunction())

Environment

None

Activity

Show:
Duplicate

Details

Assignee

Reporter

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created July 14, 2014 at 2:19 AM
Updated July 25, 2014 at 1:30 PM
Resolved July 25, 2014 at 1:30 PM
Who's Looking?