I have created a c# application using .NET 4.5.2 framework. It uses a SQL database I created in SQL Server 2019 express edition. The problem I am experiencing is now that I have been using my application for some months and the database has some size, the Sql commands sent from my c# app to Sql Server and failing to complete with commandtimout errors. If I specify a commandtimeout value (ie override the default 30 seconds) it works, but it bothers me that this happens. Am I going to have to continually bump the commandtimeout value as the database grows ?
It isn't one table or stored procedure that is getting timed out, it is all of them.
Ideas and thoughts greatly appreciated.