Type provider for MySql

f#, f#-3.0, f#-data, mysql, type-providers

Solution

I don't think there is out-of-the box type provider that would work with MySQL at the moment. However, Ross McKinlay has been working on a better type provider for SQL databases (more generally). It currently works with MS SQL server and SQL Lite.

It should be possible to write an extension to support MySQL with fairly small amount of work (but sadly, it has not been done yet). See his blog for details. I'm sure that contributions are welcome!

Problem

I've been searching for an example on how to connect to a MySql database and use F# type providers but I could not find anything online. Can anyone give me a clue? What - if any - extra packages do I need? Do I use `SqlDataConnection` or `SqlEntityConnection`. Excuse my ignorance but I'm totally lost. Any and all help is appreciated. I love the idea of type providers and have a fair amount of experience with functional programing but it's the setup around this that gets me.

Original source