Single Code Base with Multiple MS SQl Databse RSS

• • Reply
  

  venkatesh.na...

  Member

  11 Points

  62 Posts

  Single Code Base with Multiple MS SQl Databse

  Jan 18, 2013 08:56 AM|LINK

  Hi,

    I am developing a application in SAAS model,

  I have one code base and want to access different databases.

  Thanks You

  Venkatesh D N
• • Reply
  

  KanwalH

  Member

  98 Points

  19 Posts

  Re: Single Code Base with Multiple MS SQl Databse

  Jan 18, 2013 09:43 AM|LINK

  Hi,

  There can be multiple ways to handle this...the simplest being...

  When a user logs-in, along with username/password ask for community/organization he belongs to.

  Then you can use this community/organization to decide which connection to be used for this customer. These connection string can be stored in web.config or any other config file of your choice.

  Thanks

  Regards
  Kanwal
  ____________________________________________
  Please "Mark as Answer", if it helps you
  • Marked as answer by Angie xu - MSFT on Jan 25, 2013 10:54 AM