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

  • Question

  • 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


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

All replies

  • 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.

    profile for Karen Payne on Stack Exchange

    Monday, November 4, 2019 10:32 AM
  • 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