Connection String Problem

• • Reply

  12 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 14 years ago

  Hi all,

  At present I am using a connection string stored in my web.config file. What I want to know is that, when I deploy this appication on another network(intranet), how can I manage this connection string?

  Certain issues related to this are:

  - In my web application I have an option to create a new company. If a new company is created, I want that the blank database should be created with the company name. how this is possbile and in this case how I'll manage my connection string?

  Regards,

  Royal

  Report abuse
• • Reply

  12 years ago

  by Freon22

  Freon22

  , United States

  Joined 15 years ago

  The web.config is an xml file and I think there are a few 3th party tools that you can buy to work with it on a live server. But I would not do that because I believe that anytime you change your web.config you force your whole site to recompile.

  I think the best way to handle these database connections is to put them in a main database. Which is a smart way to do it anyway it makes managing these other companies alot easyer. You can create a class that will pull the right database connection from the main database for each companies.

  Report abuse
• • Reply

  12 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 14 years ago

  Thanks Freon. I am working on it, if I get struct at any point I'll get back to you.

  Regards,

  Royal

  Report abuse