SqlStatementCollection Class

On this page

Represents collection of statements that constitute MongoDB script.

Syntax

Visual Basic
C#


'Declaration Public Class SqlStatementCollection Inherits System.Collections.CollectionBase Implements System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList


public class SqlStatementCollection : System.Collections.CollectionBase, System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList

Remarks

The collection is read-only. You can not add your own SqlStatement objects or remove them.

SqlStatementCollection is used to execute statements in a script one by one. To populate the collection with data use DbScript.Statements property.

Example

This sample shows how to retrieve collection of statements that make up the script and execute them one by one.

csharp


string script = "INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+ "INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+ "INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+ "INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+ "SELECT * FROM DEPT"; MongoDBConnection mongoDBConn = new MongoDBConnection( "Host=localhost;Port=27017;Database=sample;User Id=user;Password=pwd;"); MongoDBScript mongoDBScript = new MongoDBScript(script,mongoDBConn); SqlStatementCollection mongoDBColl = mongoDBScript.Statements; IDataReader mongoDBReader; mongoDBConn.Open(); foreach (SqlStatement mongoDBStatement in mongoDBColl) { Console.WriteLine(mongoDBStatement.Text); try { mongoDBReader = mongoDBStatement.Execute(); Console.WriteLine(" Records affected " + mongoDBReader.RecordsAffected); while (mongoDBReader.Read()) { Console.WriteLine(mongoDBReader.GetString(0)); } mongoDBReader.Close(); Console.WriteLine(); } catch { Console.WriteLine(" Failed"); } } mongoDBConn.Close();

string script =

  "INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+
  "INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+
  "INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+
  "INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+
  "SELECT * FROM DEPT";
MongoDBConnection mongoDBConn = new MongoDBConnection(
    "Host=localhost;Port=27017;Database=sample;User Id=user;Password=pwd;");
MongoDBScript mongoDBScript = new MongoDBScript(script,mongoDBConn);
SqlStatementCollection mongoDBColl = mongoDBScript.Statements;
IDataReader mongoDBReader;
mongoDBConn.Open();
foreach (SqlStatement mongoDBStatement in mongoDBColl)
{
  Console.WriteLine(mongoDBStatement.Text);
  try
  {
    mongoDBReader = mongoDBStatement.Execute();
    Console.WriteLine("  Records affected " + mongoDBReader.RecordsAffected); 
    while (mongoDBReader.Read()) 
    { 
      Console.WriteLine(mongoDBReader.GetString(0)); 
    } 
    mongoDBReader.Close(); 
    Console.WriteLine();
  }
  catch
  {
    Console.WriteLine("  Failed");
  }
}
mongoDBConn.Close();

Visual Basic


Dim script As String = _ "INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');" & _ "INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');" & _ "INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');" & _ "INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');" & _ "SELECT * FROM DEPT" Dim mongoDBConn As MongoDBConnection = New MongoDBConnection( _ "Host=localhost;Port=27017;Database=sample;User Id=user;Password=pwd;") Dim mongoDBScript As MongoDBScript = New MongoDBScript(script, mongoDBConn) Dim mongoDBColl As SqlStatementCollection = mongoDBScript.Statements Dim mongoDBReader As IDataReader mongoDBConn.Open() For Each mongoDBStatement As SqlStatement In mongoDBColl Console.WriteLine(mongoDBStatement.Text) Try mongoDBReader = mongoDBStatement.Execute() Console.WriteLine(" Records affected " & mongoDBReader.RecordsAffected) While mongoDBReader.Read() Console.WriteLine(mongoDBReader.GetString(0)) End While mongoDBReader.Close() Console.WriteLine() Catch ex As Exception Console.WriteLine(" Failed") End Try Next mongoDBStatement mongoDBConn.Close()

Dim script As String = _

    "INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');" & _
    "INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');" & _
    "INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');" & _
    "INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');" & _
    "SELECT * FROM DEPT"
Dim mongoDBConn As MongoDBConnection = New MongoDBConnection( _
    "Host=localhost;Port=27017;Database=sample;User Id=user;Password=pwd;")
Dim mongoDBScript As MongoDBScript = New MongoDBScript(script, mongoDBConn)
Dim mongoDBColl As SqlStatementCollection = mongoDBScript.Statements
Dim mongoDBReader As IDataReader
mongoDBConn.Open()
For Each mongoDBStatement As SqlStatement In mongoDBColl
  Console.WriteLine(mongoDBStatement.Text)
  Try
    mongoDBReader = mongoDBStatement.Execute()
    Console.WriteLine("  Records affected " & mongoDBReader.RecordsAffected)
    While mongoDBReader.Read()
      Console.WriteLine(mongoDBReader.GetString(0))
    End While
    mongoDBReader.Close()
    Console.WriteLine()
  Catch ex As Exception
    Console.WriteLine("  Failed")
  End Try
Next mongoDBStatement
mongoDBConn.Close()

Inheritance Hierarchy

System.Object
System.Collections.CollectionBase
Devart.Common.SqlStatementCollection

Reference

SqlStatementCollection Members
Devart.Common Namespace
Statements Property

Send Feedback