Devart Forums

Code: Select all

"
EnableCaching="True" SelectCommand="SELECT bstid, bstnam, bstgsl, bstadr, bsthnr, bstpcd, bstplt, bsttel FROM bestel" ProviderName="" UpdateCommand="UPDATE bestel SET bstnam = ?, bstgsl = ?, bstadr = ?, bsthnr = ?, bstpcd = ?, bstplt = ?, bsttel = ? WHERE bstid = ?"> 
    
        
        
        
        
        
        
        
        
    
 

Code: Select all

    private static TimeSpan Chronometer(IDbConnection conn) {

      if (conn.State != ConnectionState.Open)
        conn.Open();

      DateTime start = DateTime.Now;

      try { 
        for (int i = 0; i < 100; ++i) {
          IDbCommand command = conn.CreateCommand();
          command.CommandText = "select * from cust";
          command.CommandType = CommandType.Text; 
          using (IDataReader reader = command.ExecuteReader());
            //while (reader.Read()) {}
        }
      }
      finally { 
        conn.Close();
      } 

      return DateTime.Now - start;
    }

    static void Main(string[] args)
    {
      System.Data.Odbc.OdbcConnection odbcConnection = new System.Data.Odbc.OdbcConnection();
      odbcConnection.ConnectionString = "DSN=mysource;user id=root;initial catalog=test;password=root;Port=3308";
      odbcConnection.Open(); 
      Console.WriteLine(Chronometer(odbcConnection).TotalMilliseconds);
      
      MySql.Data.MySqlClient.MySqlConnection netConnection = new MySql.Data.MySqlClient.MySqlConnection();
      netConnection.ConnectionString = "User Id=root;Database=test;Password=root;Port=3308;Host=server";
      netConnection.Open(); 
      Console.WriteLine(Chronometer(netConnection).TotalMilliseconds);      
      
      CoreLab.MySql.MySqlConnection mySqlConnection = new CoreLab.MySql.MySqlConnection();
      mySqlConnection.ConnectionString = "User Id=root;Database=test;Password=root;Port=3308;Host=server";
      mySqlConnection.Open(); 
      Console.WriteLine(Chronometer(mySqlConnection).TotalMilliseconds);
    }

Code: Select all

//while (reader.Read()) {}