DOC: Corrections to Visual C# .NET Samples in "Sample .NET Data Provider" Documentation

TemplateCommand.cs

1. Open TemplateCommand.cs. Replace the code in the CreateParameter method with the following code:

       public IDbDataParameter CreateParameter()
       {
         return (IDbDataParameter)(new TemplateParameter());
       }
   					

2. Add the following code to TemplateCommand.cs before the end of the class:

       void IDisposable.Dispose() 
       {
         this.Dispose(true);
         System.GC.SuppressFinalize(this);
       }
   
       private void Dispose(bool disposing) 
       {
         /*
          * Dispose of the object, and perform any cleanup.
          */ 
   
       }
   					

3. Save and close TemplateCommand.cs.

TemplateDataReader.cs

1. Open TemplateDataReader.cs. Replace the code in the GetValues method with the following code:

       public int GetValues(object[] values)
       {
         int i = 0, j = 0;
         for ( ; i < values.Length && j < m_resultset.metaData.Length; i++, j++)
         {
           values[i] = m_resultset.data[m_nPos, j];
         }
   
         return i;
       }
   					

2. Add the following code to TemplateDataReader.cs before the end of the class:

       void IDisposable.Dispose() 
       {
         this.Dispose(true);
         System.GC.SuppressFinalize(this);
       }
   
       private void Dispose(bool disposing) 
       {
         if (disposing) 
         {
           try 
           {
             this.Close();
           }
           catch (Exception e) 
           {
             throw e;
           }
         }
       }
   					

3. Save and close TemplateDataReader.cs.

TemplateTransaction.cs

1. Open TemplateTransaction.cs. Add the following code before the end of the class:

       public IDbConnection Connection
       {
         /*
          * Return the connection for the current transaction.
          */ 
   
         get  { return this.Connection; }
       }    
   
       public void Dispose() 
       {
         this.Dispose(true);
         System.GC.SuppressFinalize(this);
       }
   
       private  void Dispose(bool disposing) 
       {
         if (disposing) 
         {
           if (null != this.Connection) 
           {
             // Implicitly roll back if the transaction still valid.
             this.Rollback();
           }                
         }
       }
   					

2. Save and close TemplateTransaction.cs.

TemplateConnection.cs

1. Open TemplateConnection.cs. Add the following code before the end of the class:

       void IDisposable.Dispose() 
       {
         this.Dispose(true);
         System.GC.SuppressFinalize(this);
       }
   
       private void Dispose(bool disposing) 
       {
         /*
          * Dispose of the object, and perform any cleanup.
          */ 
   
         if (m_state == ConnectionState.Open)
           this.Close();
       }
   					

2. Save and close TemplateConnection.cs.
3. Compile and run the sample.