SqlBatchWriter Class

Class for building a large string of SQL which will be sent to the database in batches for execution using the ApplySQL action

Inheritance Hierarchy

SystemObject
Innovator.ClientSqlBatchWriter

Namespace: Innovator.Client
Assembly: Innovator.Client (in Innovator.Client.dll) Version: 2016.1.15.1759 (2016.01.15.1759)

Syntax

public class SqlBatchWriter : IDisposable

Public Class SqlBatchWriter
	Implements IDisposable

The SqlBatchWriter type exposes the following members.

Constructors

	Name	Description
	SqlBatchWriter(IConnection)	Instantiate the writer with a connection
	SqlBatchWriter(IConnection, Int32)	Instantiate the writer with a connection and an initial capacity for the internal StringBuilder

Properties

	Name	Description
	Threshold	Nuumber of commands at which to send the query to the database

Methods

	Name	Description
	Command	Append a new line (empty command) to the SQL
	Command(String)	Append the specified command to the SQL
	Command(String, Object)	Append the specified command with parameters the SQL. @# (e.g. @0) style parameters are replaced
	Dispose	Send the current buffer to the database
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	Flush	Send the current buffer to the database
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	Part(String)	Append a part of a command to the SQL
	Part(String, Object)	Append a part of a command with parameters the SQL. @# (e.g. @0) style parameters are replaced
	ToString	Render the current buffer to a string (Overrides ObjectToString.)