dotConnect for MySQL allows using MySQL-specific functions in Entity SQL and LINQ to Entities. You can use these functions in your Entity SQL statements for Entity Framework v4 - v6.

The following Entity SQL example is for ObjectContext only:

        var q = from c in db.PersonContacts.Where(@"Devart.Data.MySql.Soundex(it.LastName) == 
            Devart.Data.MySql.Soundex(@new)", new ObjectParameter("new", name))
                select c;

These functions are members of the MySqlFunctions class, that is located in the Devart.Data.MySql.Entity assembly.

The following example can be used both for ObjectContext and for DbContext:

        var q = from c in db.PersonContacts
                where MySqlFunctions.Soundex(c.LastName, "Q") == MySqlFunctions.Soundex(name)
                select c;

See Also

Entity Framework  | Entity Framework Canonical Functions