Access multiusers and multidatabases

Question

0.00/5 (No votes)

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.

A user can access to the application according to its credentials: user, pwd and company. The issue is that if the user enters since Mexico, it has the enviroment from Mexico but if a users enters from Brazil, both enviroments are from Brazil and viceversa.

How can i do if there are many users working simultaneously but
each one must access to the database and enviroment only from its country

Thank you!

Posted 6-Feb-15 8:24am

huicho

Add a Solution

1 solution

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)

Afzaal Ahmad Zeeshan · Answer 1 · 2015-02-06T20:28:00

You can use the globalization in ASP.NET web application of yours, or a simple method would be to use the UserID of the logged in user and show him the data that he has to see.

Connecting to different database won't be a good idea (until your application is of enterprise level of sophistication). You can create different tables for the users from different locale and show the data to each user depending on the locale the user belongs to.

Multiple users are handled by your web server (hopefully, which will be IIS) and thus you do not have to worry about that feature, all you need to take care of is the way of representing the data to the user.