ASP.Net MVC: Dynamically send the Connection string to the Entity Framework Context on DB First approach

Dynamically send the connection string to the Entity Framework context.

 In some situation we need to pass on the connection string dynamically when needed. But one more thing that the both DB should have same structure.

 as in case of my project i have more then one connection string inside the web.config. when user try to login he need to select the site name he wants to login and based on that the user is validated.

 <connectionStrings>
    <clear />
    <add name="Site1" connectionString="metadata=res://*/HarmonySITContext.csdl|res://*/HarmonySITContext.ssdl|res://*/HarmonySITContext.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=sqlservername;initial catalog=databasename;persist security info=True;user id=sa;password=sa;MultipleActiveResultSets=True;App=EntityFramework&quot;"
      providerName="System.Data.EntityClient" />
    <add name="Site2" connectionString="metadata=res://*/HarmonySITContext.csdl|res://*/HarmonySITContext.ssdl|res://*/HarmonySITContext.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=sqlservername;initial catalog=databasename;persist security info=True;user id=sa;password=sa;MultipleActiveResultSets=True;App=EntityFramework&quot;"
      providerName="System.Data.EntityClient" />

  </connectionStrings>

 You need to generate edmx file from the Db you want to connect and then it will automatically generate the context class. You need to create a new context class with the same class name as generated context and inherit the generated context. in that generated context you need to specify the connection string variable and pass that to the base.
namespace App.Name.Data
{
    public partial class AppNameContext
    {
        public AppNameContext(string connectionString) //:base()
            : base(connectionString)
        {
           

         }
    }

}

 I think this will help. :)

Comments

Post a Comment

Popular posts from this blog

LINQ: Using int.TryParse() within a LINQ where clause

I pretty new to LINQ, and I’m keen to get more experience using it, so whenever an opportunity arises I like to try writing LINQ queries. I needed to write a method to extract a comma separated list of numbers from a config file, and return this as List. I was looking at ways to do this using LINQ, but hit a problem. I wanted my LINQ query to filter out any values in the CSV string that could not be parsed as an int, without causing an exception. Using int.TryParse() seemed like a possible solution, but I had problems because the TryParse() method has an out parameter to store the parsed result. I ended up with the code below, which seems to work, but looks very messy, because I think it is parsing the string twice. public static List<int> AuthorisedGroups { get       {             string[] authorisedGroupsStr = ConfigurationManager.AppSettings["AuthorisedGroups"].Split(new char[] { ...
Read more

ASP.Net MVC: Configuring asp.net session state in SQL Server.

Image
Step 1 : Go to the command prompt and run the following  commanad aspnet_regsql.exe -S <ServerName>- E -ssadd -sstype p where < ServerName > is the  name of the server where your  Database is located. here for my local machine we have given (local). Before running the command we need to check  file v4.0.30319 on the following path C:\Windows\Microsoft.NET\Framework if it is not found then we need to install  it.   After running the command it will create database for SQL session tables. So now go to the SQL server and there we can see that it has created Database named “ASPState”. For more option here is the Link http://msdn.microsoft.com/en-us/library/ms229862(v=vs.80).aspx See the following image. Step 2: Now go to the Security Tab (outside the Database)> Login >app pool  user here for my local system it is pspl-PC21\pspl Right click on app pool user ( pspl-PC21\p...
Read more

IIS: Publish Project to remote IIS with Web Deploy.

Image
To Push a build is too much hectic task. Like you need to publish to local machine and then copy to the remote IIS. Then can be eased by directly push the build to the remote IIS through web deploy. For this there is 2 things you need configure on in the remote IIS and other on your project file. Configuration on Remote IIS To make this whole thing work you need to install Microsoft Web Deploy and you need to choose all the feature to be install on the machine. you need to add the feature of IIS Management Service. for this you need to make sure you have added Management tool feature to the IIS. Configuration on the Project side In the Visual Studio right click on the solution and make a rebuild. Then right click on the web project and select the menu "Publish". On the Profile tab Drop down list select New Custom Profile. Give a name to the publish Profile and click OK. Then click next and on the next tab "Connection" sele...
Read more