Edit connection string at interface (EntityFramework)

Question

I am writing an application on WPF (MVVM) using the Entity Framework (DataBase first). I want users to set the server name through interface, tell me how to do it please. If I pass the variable from the settings, I get a: System.ArgumentException keyword not supported 'data source'.

 using (var db = new PronetsDataBaseEntities(Properties.Settings.Default.ConnectionString)) { ...}

The ConnectionString is the same as it generated EntityFramework

(metadata=res://*/Data.PronetsDB.csdl|res://*/Data.PronetsDB.ssdl|res://*/Data.PronetsDB.msl;provider=System.Data.SqlClient;provider connection string="data source=DESKTOP-D6JRGFG\SQLEXPRESS;initial catalog=PronetsDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework")

Constructor on Entity:

public PronetsDataBaseEntities(string connectionString)
            : base(connectionString)
{
}

Oliver Hauck · Accepted Answer · 2019-10-16 16:19:05Z

0

The connection string must only be the part after "provider connection string=", so in your case: "data source=DESKTOP-D6JRGFG\SQLEXPRESS;initial catalog=PronetsDB;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"

answered Oct 16, 2019 at 16:19

Oliver Hauck

811 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Андрей Бобрюк Over a year ago

I tried it before this I ask. This is not work. System.Data.Entity.Infrastructure.UnintentionalCodeFirstException: The context is used in Code First mode with code generated from an .edmx file for developing Database First or Model First.

Oliver Hauck Over a year ago

did you omit the quotation marks in the string itself?

Андрей Бобрюк Over a year ago

Thanks, I solved the problem of creating my connection method

Collectives™ on Stack Overflow

Edit connection string at interface (EntityFramework)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related