Bug #70527 Convert to LIKE instead of LOCATE when using Contains in EF Code First
Submitted: 4 Oct 2013 21:46 Modified: 6 Dec 2013 23:16
Reporter: Roberto Ezequiel Garcia Ballesteros Email Updates:
Status: Can't repeat Impact on me:
Category:Connector / NET Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Fernando Gonzalez.Sanchez CPU Architecture:Any

[4 Oct 2013 21:46] Roberto Ezequiel Garcia Ballesteros
When generating the SQL query on a Contains Linq expression using EF Code First, it uses LOCATE instead of LIKE. It could have different results depending on accent and case sensitive data.

How to repeat:
Create a Linq expression using Contains in EF Code First.

Suggested fix:
Modify the sql generator to use LIKE instead of LOCATE in EF Code First.