Set manual Entity framework connection string

Question

I have a model that is created by EF6 ,by default my connection string is initialized in app.config as you can see here :

<connectionStrings>
    <add name="ShirazRailwayEntities" connectionString="metadata=res://*/RailWay.csdl|res://*/RailWay.ssdl|res://*/RailWay.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=****;initial catalog=DB-Metro;user id=sa;password=****;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

I have 3 layers in my application Model ,UI ,Domain class .my connection string is initialized in 'Model' and 'UI' layers,I need to set connection string by user , i mean the connection string should be set by user.

My question :

As i said i have 2 layers that the connection string are initialized inside them ,Is it necessary to initialized both connection by user ? Or just the UI is enough ?Which connection string should be initialized ?

The next question is how can i set the connection string by user?

I have a repository layer between my EF model and UI called repository :

   public class StationRepository : GenericRepository<ShirazRailWay.ShirazRailwayEntities, DomainClass.Station>
    {
    }

My Ui calls this repository .

best regards

StriplingWarrior · Accepted Answer · 2014-07-14 15:54:31Z

3

how can i set the connection string by user?

The DbContext class that underlies your Entity Framework context class has a constructor that takes in a connectionString parameter. If you expose that in your context, you can pass whatever connection string you want to it at runtime.

using(var ctx = new MyContext(GetCurrentUserConnectionString())
{
   ...
}

As for your other questions, I didn't really understand what you're asking. If you want a better answer, please clarify.

answered Jul 14, 2014 at 15:54

StriplingWarrior

158k29 gold badges261 silver badges326 bronze badges

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

6 Comments

Ehsan Akbar Over a year ago

My model and Ui are in separate project i should initialize the ui connection string too ?

Ehsan Akbar Over a year ago

I don't call my dbcontext directly i have an repository between my model and ui how can i pass the connection string to my model.i mean i call my dbcontext in repository but my connection string should be initialized in ui

Erik Funkenbusch Over a year ago

@EA - And why is that a problem?

Ehsan Akbar Over a year ago

@ErikFunkenbusch you know in my ui i have an app.config that my connection string is there ,in my repository layer i call my dbcontext ,i don't know how can i set connection string in ui by user and out it in dbcontext layer

Erik Funkenbusch Over a year ago

@EA - The same way you do in your ui... I don't understand what problem you're having... it works exactly the same way.

|

Kirill Bestemyanov · Accepted Answer · 2014-07-16 07:57:33Z

1

You can initialize your dbcontext with custom connection string:

var context = new DbContext(connectionString);

update:

In your repository you can add parameter to constructor of repository that will initialize connection string for dbcontext.

Example:

public class StationRepository : GenericRepository<ShirazRailWay.ShirazRailwayEntities, DomainClass.Station>
{
    public StationRepository(string connectionstring):base(connectionstring){}
}

public class GenericRepository<T1, T2>
{
    protected GenericRepository(string connectionstring)
    {
        //initialize dbcontext using connection string
    }
}

edited Jul 16, 2014 at 7:57

answered Jul 14, 2014 at 15:52

Kirill Bestemyanov

12k2 gold badges26 silver badges38 bronze badges

7 Comments

Ehsan Akbar Over a year ago

yes you are right but my problem is i have 3 layers in my app ,one of them is My model that my entities are there and ui and domain class ,if i set the connection string in model i should initialize it in ui too

Kirill Bestemyanov Over a year ago

Does every user has his own connection string? And how do you authenticate this user in your program?

Ehsan Akbar Over a year ago

I just need the user be able to choose ip address of server

Kirill Bestemyanov Over a year ago

In your repository you can add parameter to constructor of repository that will initialize connection string for dbcontext.

Ehsan Akbar Over a year ago

@it is that i want ,so could you please tell m in details?

|

Collectives™ on Stack Overflow

Set manual Entity framework connection string

2 Answers 2

6 Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related