One application with multiple databases

Question

4.00/5 (1 vote)

See more:

Hi,

I have a requirement like, developed an ASP.net web application. I want to host this application for different companies with seperate database, but website shall be hosted only one copy in IIS. so, based on user login, the application should connect different database server.

For Ex: if user "xxx" login with credential and belogs to "ABC" company and the database is "ABC", then ABC data need to display on the web page.

if user "XYZ" login with credential and belogs to "HGJ" company and the database is "HGJ", then HGJ data need to display on the web page.

Can any one give good solution for the same.

Thanks in Advance
Ravikrishna

Posted 3-Mar-11 0:55am

Member 2823421

Updated 3-Mar-11 0:57am

Yusuf

v2

Add a Solution

4 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)

Yusuf · Answer 1 · 2011-03-03T01:04:00

This is not difficult to implement. In fact I have implemented an application that can talk to different database.

The first thing to sort out is, where is your login credentials to be authenticated. That is to say, when user "xxx" tried to login, do you have a centralized User's database or is it each user is going to be authenticated to their respective database.

If it is the former case then you need to add the company into the user's table, so when the user is authenticated you know which company s/he belongs to. If it is the later then you need to take company part of the user/password combination, so you know which database you to go after.

Once the user's company is identified it is straight forward from there on. May be you need to keep some sort of dictionary or map that maps company to database.

If you can work with single database, working with multiple is no different. You will need a connection string for each database. There rest is, as they say it, history.

soni uma · Answer 2 · 2011-03-03T01:07:00

Hi,

You have already describe in your question that how to do. But also see following table structure for your requirement.

MainTable
---------
Username
password
Company
Connectionstring

when you check usename and password in this table according to that you have to take a connection string and connect to that database.

In shot in ConnectionString field you have to store different connection string for different database.

muthukrishnan.s · Answer 3 · 2014-06-09T21:17:00

web.config

XML

<connectionStrings>
    <add name="ConnectionString1" connectionString="Data Source=MUTHU-PC\SQLEXPRESS;Initial Catalog=yourFirstDataBaseName;Integrated Security=False;User ID=sa5556;Password=5555" providerName="System.Data.SqlClient" />
    <add name="ConnectionString2" connectionString="Data Source=MUTHU-PC\SQLEXPRESS;Initial Catalog=yourSecondDataBaseName;Integrated Security=False;User ID=sa5556;Password=5555" providerName="System.Data.SqlClient" />
  </connectionStrings>

in code behind

public string btnlogin(role_id)
{
if(role_id==1)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString);

con.Open();
fill ur requirement

con.Close();

}
elseif(role_id==2)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString);
con.Open();
fill ur requirement

con.Close();
}

}

Member 2514896 · Answer 4 · 2014-10-17T02:05:00

Solution 4

go to multitenant concept

Posted 17-Oct-14 2:05am

Member 2514896

One application with multiple databases

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0