Represents an open connection to a cloud application.
The following sample demonstrates how using base classes helps to create data source-independent code.
|
|---|
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();
}
} |
|
|---|
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 |
