Hello,

I'm currently developing a tool called SQLWrapper, which aims to automatically generate a C# wrapper from SQL queries:

SQLWrapper NuGet Package
SQLWrapper GitHub Repository

Presently, the SQL wrapper does not include a command timeout feature.

I understand that there are scenarios where modifying the command timeout, especially for large queries, is necessary to increase query execution time.

I see two potential solutions to address this:

1. Adding Command Timeout as a Parameter in Each SQL Wrapper Method:

 public static async Task<SelectResult?> Select(MySqlConnection conn, MySqlTransaction transaction, long productId, int timeout)
 {
 using MySqlCommand sqlCmd = new MySqlCommand
 {
 CommandTimeout = timeout,

2. Defining a Connection String with Command Timeout=XXX

• I'm seeking your feedback to determine which solution would be preferable: Solution 1 or 2?

• Additionally, if you have the opportunity to test my SQLWrapper tool, I would greatly appreciate any feedback you can provide.