Connection string for different logged in users

Question

Connection string for different logged in users

Asked 7 years, 11 months ago

Viewed 150 times

0

I am doing a job and I came up with a possibility that I would like to know if it is possible to realize: the purpose of this idea is to alternate a certain connection string as per the user logged in. That is, I will have a connection string general, which will contain the user information for him to log in, and in the database of this connection string I will have the information from another database that this user must connect to. That is, each group of users will have a different database to connect to and from the database information that the user must connect to, I would mount the connection string for him.

It is possible to implement something like this or there is a better solution?

I’ve answered that before. See if it meets you: http://answall.com/questions/146885/%C3%89-possible-let-connectionstring-de-forma-din%C3%A2mica/149343#149343

– Leonel Sanches da Silva

2017/02/22 at 15:22

1 answer

Browser other questions tagged asp.net-mvc asp.net asp.net-mvc-5 asp.net-mvc-4

You are not signed in. Login or sign up in order to post.

by Anderson Souza • **376** points · Answer 1 · 2016-11-18T11:30:05+00:00

you can use the dynamic string Connection approach by changing the data from a generic string Connection to the database data the user should use, the storage of the connection data can be in the initial login database.

The link below has an interesting example of how to use this resource.

http://www.c-sharpcorner.com/UploadFile/bd6c67/dynamic-connecting-string-of-mssql-database-in-C-Sharp/

I hope I’ve helped.