Unable to convert runtime connection string to its design-time equivalent

c# entity-framework visual-studio-2013

Question

I updated to Visual Studio 2013 last week and I can no longer update my Entity Data model through the visual studio designer (.edmx file).

When I right click > update model from database I now receive this error:

An Exception of type 'System.ArgumentException' occurred while attempting to update from the database. The exception message is: 'Unable to convert runtime connection string to its design-time equivalent. Connection string: server=192.168.100.103;user id=xxx;password=xxx;database=xxx;persist security info=True'.

My connection string is as follows:

  <connectionStrings>
<add name="DbEntities" connectionString="metadata=res://*/Db.csdl|res://*/Db.ssdl|res://*/Db.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=192.168.100.103;user id=xxx;password=xxx;database=xxx;persist security info=True&quot;" providerName="System.Data.EntityClient" />

The process still works fine in Visual Studio 2012

1
11
10/26/2015 1:28:39 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Apparently MySql and Visual Studio 2013 don't work together yet.

Here is a link on the MySql forums: http://forums.mysql.com/read.php?174,594798,600466#msg-600466

You'll probably need to wait for the next release of the MySql connector.

I can't even create a connection to a MySql DB from Server Exploer in Visual Studio 2013. Can you?

6
11/21/2013 10:51:33 AM

Popular Answer

You need to download Mysql connector 6.8.3.0 and Mysql for Visual Studio 1.1.1(https://cdn.mysql.com/Downloads/MySQLInstaller/mysql-visualstudio-plugin-1.1.1.msi)

After that, it worked for me.

Erti-Chris Eelmaa

Related Questions

Change the database name in the connection string in Entity Framework during runtime.

In my project I want to run some unit tests on the DAL layer that is using EntityFramework. I'm creating from scrips a new database before each run of the tests (in order to have always the same initial data when doing the tests). At the end of the tests, this database is dropped, (all is made automatically with the help of [ClassInitialize()] and ...
.net entity-framework runtime
asked by Lucian

Entity Framework runtime connection string

I'd like to supply the connection string for my database at runtime. I am using the Entity Framework. This is what I have so far...class MyClassDBContext:DbContext { public MyClassDBContext(string str) : base(str) { this.Database.Connection.ConnectionString = str; } } ...To use the above code, I tried...//create connection string EntityCo...
asp.net-mvc-3 c# entity-framework
asked by user1625066

Set Entity Framework Connection String at Runtime in C#

I need to set my Entity Framework connection string at runtime. Right now, I have the following:...string connectionString = "metadata=res://*/DataModels.CustomerDataModel.csdl|res://*/DataModels.CustomerDataModel.ssdl|res://*/DataModels.CustomerDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=tcp:{serverNam...
c# entity-framework
asked by JQuery Mobile

Change DbContext connection at run-time

I have 3 DBs that I want to work with: A,B and C. each one have the same tables (for example: users, products)....I want to let the user decide (on run-time) which DB he wants to work with. So... I used EF5 and created 3 edbx files which created the following classes: ADBEntities, BDBEntities and CDBEntities....How can I let him decide the selected...
c# database entity entity-framework reflection
asked by user3017270

SQLite EF6 programmatically set connection string at runtime

I try to migrate form EF 3.5 to 6 (with SQLite as database). We can not set the connection string in the app config file (this works without problems with ef6). We have to set connection string programmatically at runtime (after user has selected the SQLite file)....Here is our app.config...<?xml version="1.0" encoding="utf-8"?> <configuration> <...
.net connection-string entity-framework-6 runtime sqlite
asked by WebDucer

Entity Framework : Change connection string at runtime

Assuming there is an ASP.NET MVC application that uses Entity Framework 6 with code-first approach and StructureMap as IoC.... Also It uses Unit Of Work pattern. Here are the codes : ...Domain Class ...    public class Product     {         public int Id { get; set; }         public string Name { get; set; }         ...
asp.net-mvc c# dependency-injection entity-framework structuremap
asked by Shahin

using connection string at runtime

I have created my model using database first approach. The issue is that my connection string changes at runtime. Therefore I have added an overloaded constructor for the DBContext class that takes connection string....public partial class MyDataContext: DbContext { public MyDataContext: () : base("name=DbEntities") ...
c# entity-framework-6
asked by BKS

Entity Framework 6 set connection string runtime

We are in a mixed environment where our application is using both ADO.NET and Entity Framework.... Since both are pointing to the same physical SQL server, we would like to remove the Entity Framework connection string from the config file and then auto build the string based on the current ADO.NET connection strings.... This saves us from mistakes...
.net entity-framework entity-framework-6
asked by goroth

WinForms Entity Framework database connection exception at design-time

Environment: I have a Visual Studio 2017 solution with a Model project containing Entity Framework (EF6) DbContext and POCOs, a data access layer project implementing the Repository and Unit Of Work patterns, and a WinForms UI project. In the UI main form there is a tab control and on one of the tab-pages there is a UserControl. On the UserControl ...
c# design-time entity-framework-6 visual-studio-2017 winforms
asked by Matthew Bishop

Connection String Issue: System.Data.SqlClient.SqlException (0x80131904) - Unable to connect to SQL Server Management Studio

I am trying to connect Visual Studio 2017 to SQL Server 2016 Express using the following code in my app.config:...<?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> <section name="entityFramework" type="System....
c# entity-framework-6
asked by Bing Li

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow