connection string for multiple database in a single application.

Question

0.00/5 (No votes)

See more:

Hi,
I have a web application that will be use by multiple company.For this purpose I create n database.

Now I want according to the company connection string generate.
How can we do this??

Or What is best option to do this type of application.?

PLEASE GIVE ME BEST CHOICE.

THNAX
SEEMA

Posted 23-Jul-10 6:59am

Seema Gosain

Add a Solution

Comments

Rajesh Sajjanar 23-Jul-10 15:51pm

HiThe application should support for which database server SQL/ Oracle or any database server ?

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)

AspDotNetDev · Answer 1 · 2010-07-23T07:06:00

Solution 1

Allow the user to enter database information.
Create pre-defined users (aka, companies) and, when the user logs in, have a database associated with that user.
Dynamically create a database at runtime then store the connection details. This is especially easy with SQL Server CE.

Posted 23-Jul-10 7:06am

AspDotNetDev

Rajesh Sajjanar · Answer 2 · 2010-07-23T10:05:00

Hi
Database connection string you can set it in web.config file provided your application is for one database server only for ex - SQL Server.
if application should work irrespective of database server likr sqlsever, oracle, DB2 etc then you can use ADO.Net factory classes, you can do this using namespace Syste.Data.Common