How to use IQToolKit for MySql in VS 2010?

mgweeks

I have been able to use LinqPad to query a MySql database using the IQToolKit. I was hoping to just be able to change the connection string/provider in my VS2010 project (which currently works with SQL2008) to allow it to work with the MySql DB. Can someone please let me know what I'm missing?

JoeAlbahari

Unfortunately, it's not that simple. Querying MySQL in LINQ requires not just a different connection string, but a different API. LINQPad uses Matt Warren's IQToolkit. You could use either that, or DevArt's LINQ provider for MySQL which does a similar thing. I recommend you try DevArt's LINQ provider, because it will give a better experience in Visual Studio.