Conection string class mysql C#

Goran Bibic

I have more then 50000 records in table

Using connection sting in class
Time I spent now is more then 30 seconds, default value.
Need to setup conection life time or Conection time out
Need help

string server = ConfigurationManager.AppSettings["server"].ToString();
string username = ConfigurationManager.AppSettings["username"].ToString();
string password = ConfigurationManager.AppSettings["password"].ToString();
string database = ConfigurationManager.AppSettings["database"].ToString();
// string conection = ConfigurationManager.AppSettings["connection time"].ToString();
conn = new MySqlConnection(@"server=" + server + ";userid=" + username + ";"
+ "password=" + password + ";database=" + database);

OR

conn = new MySqlConnection("Data Source='192.168.1.135';Port=3306;Database='prijavnica_app';UID='prijavnica';PWD='prijavnica'; Connect Timeout=120;");

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Try this code:
String connectionString = "Server=myserver; Port=3306; Database=databasename; Uid=userid; Pwd=password;Connection Timeout=30";
Goran Bibic7y ago
That is not solution I need

Another?
Jaimin Shethiya7y ago
Hello Goran,

I think you have to set the timeout when you have to fetch the data in database.
here the code for that, can you please check it.

using (SqlConnection connection = new SqlConnection(connectionString))
{
   connection.Open();
   SqlCommand command = new SqlCommand(queryString, connection);
   command.CommandTimeout = 0;
   try
   {
      command.ExecuteNonQuery();
   }
   catch (SqlException e)
   {
      Console.WriteLine("Got expected SqlException due to command timeout ");
      Console.WriteLine(e);
   }
}

let me know if you have needed any other help from myside.

Thanks