I want to inquire, is it a best practice to use one database (sqlserver) user (which stored in web.configure) to access database in asp.net application. On other hand if used database user get dead locked the will be not accessable to users and get
stuck. using one database user also raise transaction level security issues.
Please your recommendation and best practices are required in this regards
Member
34 Points
147 Posts
Constant database User and connection string from web.net
Apr 10, 2014 03:39 AM|asad_dba|LINK
Hi Friends,
I want to inquire, is it a best practice to use one database (sqlserver) user (which stored in web.configure) to access database in asp.net application. On other hand if used database user get dead locked the will be not accessable to users and get stuck. using one database user also raise transaction level security issues.
Please your recommendation and best practices are required in this regards
thank you.
regards,
asad
Asad Mahmood
Star
13653 Points
5480 Posts
Re: Constant database User and connection string from web.net
Apr 10, 2014 03:53 AM|Ashim Chatterjee|LINK
you can add a number of connection strings for different users and on codebehind use using statement to check the state of connection.