SqlShimConnection Class

In This Topic

Represents an open connection to a cloud application.

Syntax

Visual Basic
C#

'Declaration
 
Public MustInherit Class SqlShimConnection 
   Inherits Devart.Common.DbConnectionBase
   Implements System.ComponentModel.IComponent, System.Data.IDbConnection, System.IDisposable

public abstract class SqlShimConnection : Devart.Common.DbConnectionBase, System.ComponentModel.IComponent, System.Data.IDbConnection, System.IDisposable

Remarks

The abstract SqlShimConnection class implements the common cloud connection functionality.

Example

The following sample demonstrates how using base classes helps to create data source-independent code.

csharp

public void PrintData(SqlShimConnection myConnection) {
        SqlShimCommand myCommand = (SqlShimCommand)myConnection.CreateCommand();
        myCommand.CommandText = "SELECT id, firstname, lastname FROM customers";
        myConnection.Open();
        SqlShimDataReader myReader = myCommand.ExecuteReader();
        try {
                while (myReader.Read()) {
                        Console.WriteLine(myReader.GetInt32(0).ToString() + " " + 
                                myReader.GetString(1) + " " + myReader.GetString(2));
                }
        }
        finally {
                myReader.Close();
                myConnection.Close();
        }
}

Visual Basic

Public Sub PrintData(ByVal myConnection As SqlShimConnection)
        Dim myCommand As SqlShimCommand = myConnection.CreateCommand()
        myCommand.CommandText = "SELECT id, firstname, lastname FROM customers"
        myConnection.Open()
        Dim myReader As SqlShimDataReader = myCommand.ExecuteReader()
        Try
                While myReader.Read()
                        Console.WriteLine(String.Concat(myReader.GetInt32(0).ToString(), " ", _
                                myReader.GetString(1), " ", myReader.GetString(2)))
                End While
        Finally
                myReader.Close()
                myConnection.Close()
        End Try
End Sub

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DbConnection
            Devart.Common.DbConnectionBase
               Devart.Data.SqlShimConnection
                  Devart.Data.Bigcommerce.BigcommerceConnection

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

SqlShimConnection Members
Devart.Data Namespace
DbConnectionBase Class
BigcommerceConnection Class

Send Feedback