Question about timeout. (Database connection timed out)

jxph125133

Sometimes you have to insert N records and then the database connection times out.
Because the end of the code needs to turn the inserted record into an Excel file for download by the client, once the timeout occurs, some single encrypted information will be lost (such as md5 encrypted password), so it takes time and effort to update the password.
How can I handle this situation? Can C # catch SQL database timeout errors? Or is there any better way? ?

苹果小刀

Set SqlConnection.ConnectionTimeout longer!

wsry82

<add key="ConnectionString" value="Data Source=.;Initial Catalog=MiaDB;User ID=sa;Password=sa;Max Pool Size=300;Connect Timeout=20" />

wdh3139593

Timeout=100000000000000000000000000

一桶姜山

Can only help you up.

jxph125133

However, the plain text of the connection password appears in the web.config, which is not very secure. How to avoid it? ?