All geek questions in one place

How can I use MySQL with Visual Studio 2012 Lightswitch?

How can I use MySQL with Visual Studio 2012 Lightswitch? I want to use Amazon AWS RDS for a MySQL server. I get the error message: Could not find or load the registered .Net Framework data provider.

+4
source share
2 answers

Here are the steps for using MySQL with Visual Studio 2012 Lightswitch:

  • Install the MySQL community installer . I used mysql-installer-community-5.6.12.1.msi.
  • Additionally install Amazon AWS Tools and SDK: AWSToolsAndSDKForNet.msi
  • If necessary, install Microsoft SQL Server Data Tools: SSDTSetup.exe.
  • Create a LightSwitch project.
  • Select: Attach to an external data source to call the Data Source Connection Wizard.
  • Select: Database as source.
  • In the connection properties: click the "Change data source" button, select "MySql database".
  • Enter the server name: (Amazon AWS RDS endpoint), username (awsuser?), Password (password).
  • Database Name: Click Uncheck. Select a database. Click OK.
  • Import database objects.
  • In Solution Explorer, select View Files.
  • Go to server links. Right click, add the link, find the MySQL links, add MySql.Data.Entities. I was offered several options: 6.6.5.0 is the one that worked. YMMV.
  • You should be good to go.

Step 12 resolves the error: the registered .Net Framework data provider could not be found or downloaded.

+8
source

For VS 2013, I had to do the following:

Install / upgrade your MySQL using the MySQL community installer

  • Be sure to add the application function in the image below:

enter image description here

Now I get the MySQL database as a data source in Visual Studio:

enter image description here

+4
source

Source: https://habr.com/ru/post/1489995/

More articles:


All Articles