Problem :
System.Exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
Cause :
sqlcommand has a property called commandTimeout. Its default value is 30 seconds. If the query execution time is more than this value, It will throw above exception.
