l2e

Why do LINQ to Entities does not recognize certain Methods?

Why cant I do this: usuariosEntities usersDB = new usuariosEntities(); foreach (DataGridViewRow user in dgvUsuarios.Rows) { var rowtoupdate = usersDB.usuarios.Where( u => u.codigo_usuario == Convert.ToInt32(user.Cells[0].Value) ).First(); rowtoupdate.password = user.Cells[3].Value.ToString(); } usersDB....

Is there a way to make Linq to Entities map unrecognized methods/functions to MySql functions?

Is there a way to make Linq to Entities map unrecognized methods/functions to MySql functions? I want to add support to some functions like Convert.* ...