Visual Studio 2017 + entity framework + identity +

Question

I have been trying to create a REST API with visual studio 2017 using the default project. This works fine with a SQL local DB, but when I am trying to convert it to a MySQL variant using this tutorial: https://docs.microsoft.com/en-us/aspnet/identity/overview/getting-started/aspnet-identity-using-mysql-storage-with-an-entityframework-mysql-provider

I get this error:

'The Entity Framework provider type 'MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity' registered in the application config file for the ADO.NET provider with invariant name 'MySql.Data.MySqlClient' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information.'

This tutorial worked fine with visual studio 2015. I noticed that other stuff like dotnet connector from either devart or mysql do not work for visual studio 2017 yet, am I to early?

I have tried these solutions: - Enity Framework With MySQL

EDIT: Forgot to tell what I tried.

Answer 1

That tutorial is from 2013. MySQL connector doesn't yet support visual studio 2017, It's expected shortly, in the meantime Devart has a connector that works with Visual Studio 2017 and MySQL.

Edit

MySQL now natively supports Visual Studio 2017. More info at: https://dev.mysql.com/doc/visual-studio/en/visual-studio-install.html

Answer 2

Might be helpful for others. MySQL Supports Visual Studio 2017 in version 1.2.7 Click on the below link for more details

https://forums.mysql.com/read.php?3,656703,656703#msg-656703