Re: Make MySql Connector/.NET 6.7.4 use LIKE instead LOCATE with Contains?
Posted by: Fernando Gonzalez Sanchez
Date: December 06, 2013 05:20PM

Hi Gonzalo,

Regarding this bug, http://bugs.mysql.com/bug.php?id=70527, it seems I cannot reproduce it.

I have tried a simple CodeFirst app with
- VS2010, Cnet 6.7.4, Entity Framework 5, .NET 4.0.
- VS2012, Cnet 6.7.4, Entity Framework 5, .NET 4.5.

Do you have more details on how to repro?

My query sample:
q = from m in ctx.Movies
where m.Title.Contains("re'")
orderby m.Title
select m;

Is translated correctly to

SELECT
`Extent1`.`ID`,
`Extent1`.`Title`,
`Extent1`.`ReleaseDate`,
`Extent1`.`Genre`,
`Extent1`.`Price`,
`Extent1`.`Data`,
`Extent1`.`Director_ID`
FROM `Movies` AS `Extent1`
WHERE `Extent1`.`Title` LIKE '%re''%'
ORDER BY
`Extent1`.`Title` ASC

*** My opinions do not necessarily reflect the opinions of my employeer ***
Fernando Gonzalez Sanchez
Sr. Software Engineer
MySql Connector/NET Team
Oracle Corporation

Options: ReplyQuote


Subject
Written By
Posted
Re: Make MySql Connector/.NET 6.7.4 use LIKE instead LOCATE with Contains?
December 06, 2013 05:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.