Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to make my asp mvc support mutiple connection string for support different user using? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear Master

    Today I am learning about connect many database with asp mvc , and still have issue with multi user using different task .  I have 10 user to using me asp  mvc , and my connection is 10 database on SQL server, and my issue is generate the path connection string while 10 people using the function reporting sale summary from 10 database

    please suggest me about it, if you have the best way  for me

    note : currently my app asp mvc is supporting only 1 user

    thank  you

    best regards

    kevin

    • Moved by CoolDadTx Monday, November 4, 2019 3:02 PM ASP.NET related
    Monday, November 4, 2019 9:09 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I would recommend not having a database per user but instead have one database where the design has a user table with a primary key for each user that is used throughout the database tables.

    The concept is shown here.

    Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.

    NuGet BaseConnectionLibrary for database connections.

    StackOverFlow
    profile for Karen Payne on Stack Exchange

    Monday, November 4, 2019 10:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    This forum is for C# specific questions only. Please post questions related to MVC in the ASP.NET forums.

    Michael Taylor http://www.michaeltaylorp3.net

    Monday, November 4, 2019 3:01 PM