Last post Apr 10, 2014 03:53 AM by Ashim Chatterjee
Apr 10, 2014 03:39 AM|asad_dba|LINK
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
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.