How to manage multiple database on MVC 4

Question

0.00/5 (No votes)

See more:

I've been looking through different sites on the internet for a solution to my problem. I need to manage multiple databases for a web app. Let's say that I have 2 clients, they will be having their own database (so that's 2 database), also i need to check if their account exist on my primary database. The code will basically target the primary database to check if their account exist, then programatically change the connection/ or point them to the database that they own. I'm tried to alter the web.config after checking their accounts, but this seems to be a bad program flow for each time a user attempts to log in, the web config will be altered and the logged in users will be directed to the new database connection.

I hope to hear a good answer from you guys.

Posted 20-Apr-14 23:41pm

john villafania

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manas Bhardwaj · Answer 1 · 2014-04-20T23:50:00

What you are dealing with is Multi Tenancy. Not directly related to your question, but here is a good book on best practices in multi tenant environment.

http://msdn.microsoft.com/en-us/library/ff966499.aspx[^]

Coming back to you question, I don't think it's a good idea to maintain static connection strings for various tenants. Potentially, you can have 10 or even 100 tenants tomorrow.

My suggestion would be do implement a ConnectionStringManager sort of class which can give you the connection string for a specific client.

john villafania · Answer 2 · 2014-04-20T23:57:00

Configuration config = WebConfigurationManager.OpenWebConfiguration("~");
            ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection;
            var connection = WebConfigurationManager.ConnectionStrings["ClientConnection"].ConnectionString;
            string[] conn = connection.Split(';');
            string dataSource = conn[0];
            string initialCatalog = conn[1];
            string persistentSecInfo = conn[2];
            string userID = conn[3];

            string dbName=initialCatalog.Substring(16,9);

            if (!dbName.Equals(officeID))
            {
                connection = connection.Replace(dbName, officeID);
                section.ConnectionStrings["ClientConnection"].ConnectionString = connection;
                config.Save();
            }

This is the code I use to change my connection based on the officeID (which refers to the client's database name), I replace the value of the Initial Catalog to point to the database I need.

Any suggestions or comments?

How to manage multiple database on MVC 4

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0