EntityFramework and MySQL with LINQ

Question

I'm trying to use EntityFramework to work with MySQL database from c#. I'm using MySQL Connector 6.3.3, but i'm unable to use the linq syntax like

context.Items.Where(x => x.Id == 3)

I only see the following overload for Where:

Where(string predicate, params ObjectParameter[] parameters);

Is there a provider or something that could help me to work with MySQL from EF with the common LINQ syntax?

Thomas Levesque · Accepted Answer · 2010-08-15 17:12:10Z

3

You're probably missing a using clause :

using System.Linq;

You also need to reference the System.Core assembly.

The Where method you're seeing is the one defined by the ObjectSet<T>. The other query operators are extension methods defined in the System.Linq.Queryable class

answered Aug 15, 2010 at 17:12

Thomas Levesque

294k73 gold badges639 silver badges769 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shaddix Over a year ago

Thanks a lot! Shame on me - forgot such an easy thing :)

Collectives™ on Stack Overflow

EntityFramework and MySQL with LINQ

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related