CODEWITHSUNDEEP
c#mysqlentity-frameworkentity-framework-6mysql-connector
Dede
Dede

Reputation: 1640

MySQL Connector .NET EF6 operator LIKE not working

I am using MySQL Connector .NET with EntityFramework 6, version 6.9.5.0.

I build a query with a "LIKE" like this :

        var q = from u in ctx.Db.users
                where u.name.StartsWith(query)
                select u;

It is compiled to this :

SELECT
...
FROM `user` AS `Extent1`
 WHERE `Extent1`.`name` LIKE 'p__linq__0%'

So my query fails, because my users' name will never be like this... (maybe one day ?)

Is it a bug, an expected behavior or do I have missed something ?

Thanks.

Upvotes: 1

Views: 591

Answers (2)

Hai
Hai

Reputation: 51

You could use the following code

        var q = from u in ctx.Db.users
                where u.name.StartsWith(query.Trim())
                select u;

it works fine

Upvotes: 0

Dede
Dede

Reputation: 1640

Found two tickets in MySQL Bugtracker :

Upvotes: 2

Related Questions