C# 클래스 Rhino.Etl.Core.Operations.SqlBulkInsertOperation

Allows to execute an operation that perform a bulk insert into a sql server database

상속: Rhino.Etl.Core.Operations.AbstractDatabaseOperation

공개 프로퍼티들

프로퍼티	타입	설명
Mappings	string>.IDictionary

공개 메소드들

메소드	설명
CreateInputSchema ( ) : void	Use the destination Schema and Mappings to create the operations input schema so it can build the adapter for sending to the WriteToServer method.
Execute ( IEnumerable rows ) : IEnumerable	Executes this operation
PrepareMapping ( ) : void	Prepares the mapping for use, by default, it uses the schema mapping. This is the preferred appraoch

보호된 메소드들

메소드	설명
IsOptionOn ( SqlBulkCopyOptions option ) : bool	Returns `true` if the option is turned on, otherwise `false`
PrepareSchema ( ) : void	Prepares the schema of the target table
SqlBulkInsertOperation ( ConnectionStringSettings connectionStringSettings, string targetTable ) : System	Initializes a new instance of the SqlBulkInsertOperation class.
SqlBulkInsertOperation ( ConnectionStringSettings connectionStringSettings, string targetTable, int timeout ) : System	Initializes a new instance of the SqlBulkInsertOperation class.
SqlBulkInsertOperation ( string connectionStringName, string targetTable ) : System	Initializes a new instance of the SqlBulkInsertOperation class.
SqlBulkInsertOperation ( string connectionStringName, string targetTable, int timeout ) : System	Initializes a new instance of the SqlBulkInsertOperation class.
ToggleOption ( SqlBulkCopyOptions option, bool on ) : void	Turns a bulkCopyOptions on or off depending on the value of on
TurnOptionOff ( SqlBulkCopyOptions option ) : void	Turns the option off.
TurnOptionOn ( SqlBulkCopyOptions option ) : void	Turns the option on.
onSqlRowsCopied ( object sender, System.Data.SqlClient.SqlRowsCopiedEventArgs e ) : void	Handle sql notifications

비공개 메소드들

메소드	설명
CompareSqlColumns ( SqlConnection connection, SqlTransaction transaction, IEnumerable rows ) : void
CreateSqlBulkCopy ( SqlConnection connection, SqlTransaction transaction ) : System.Data.SqlClient.SqlBulkCopy	Creates the SQL bulk copy instance
GetFriendlyName ( Type type ) : string
TypesMatch ( Type schemaType, Type databaseType, bool isNullable ) : bool

메소드 상세

CreateInputSchema() 공개 메소드

Use the destination Schema and Mappings to create the operations input schema so it can build the adapter for sending to the WriteToServer method.

public CreateInputSchema ( ) : void
리턴	void

Execute() 공개 메소드

Executes this operation

public Execute ( IEnumerable rows ) : IEnumerable
rows	IEnumerable
리턴	IEnumerable

IsOptionOn() 보호된 메소드

Returns true if the option is turned on, otherwise false

protected IsOptionOn ( SqlBulkCopyOptions option ) : bool
option	SqlBulkCopyOptions	The option to test for.
리턴	bool

PrepareMapping() 공개 메소드

Prepares the mapping for use, by default, it uses the schema mapping. This is the preferred appraoch

public PrepareMapping ( ) : void
리턴	void

PrepareSchema() 보호된 추상적인 메소드

Prepares the schema of the target table

protected abstract PrepareSchema ( ) : void
리턴	void

SqlBulkInsertOperation() 보호된 메소드

Initializes a new instance of the SqlBulkInsertOperation class.

protected SqlBulkInsertOperation ( ConnectionStringSettings connectionStringSettings, string targetTable ) : System
connectionStringSettings	System.Configuration.ConnectionStringSettings	Connection string settings to use.
targetTable	string	The target table.
리턴	System

SqlBulkInsertOperation() 보호된 메소드

Initializes a new instance of the SqlBulkInsertOperation class.

protected SqlBulkInsertOperation ( ConnectionStringSettings connectionStringSettings, string targetTable, int timeout ) : System
connectionStringSettings	System.Configuration.ConnectionStringSettings	Connection string settings to use.
targetTable	string	The target table.
timeout	int	The timeout.
리턴	System

SqlBulkInsertOperation() 보호된 메소드

Initializes a new instance of the SqlBulkInsertOperation class.

protected SqlBulkInsertOperation ( string connectionStringName, string targetTable ) : System
connectionStringName	string	Name of the connection string.
targetTable	string	The target table.
리턴	System

SqlBulkInsertOperation() 보호된 메소드

Initializes a new instance of the SqlBulkInsertOperation class.

protected SqlBulkInsertOperation ( string connectionStringName, string targetTable, int timeout ) : System
connectionStringName	string	Name of the connection string.
targetTable	string	The target table.
timeout	int	The timeout.
리턴	System

ToggleOption() 보호된 메소드

Turns a bulkCopyOptions on or off depending on the value of on

protected ToggleOption ( SqlBulkCopyOptions option, bool on ) : void
option	SqlBulkCopyOptions	The to turn on or off.
on	bool	true to set the on otherwise false to turn the off.
리턴	void

TurnOptionOff() 보호된 메소드

Turns the option off.

protected TurnOptionOff ( SqlBulkCopyOptions option ) : void
option	SqlBulkCopyOptions
리턴	void

TurnOptionOn() 보호된 메소드

Turns the option on.

protected TurnOptionOn ( SqlBulkCopyOptions option ) : void
option	SqlBulkCopyOptions
리턴	void

onSqlRowsCopied() 보호된 메소드

Handle sql notifications

protected onSqlRowsCopied ( object sender, System.Data.SqlClient.SqlRowsCopiedEventArgs e ) : void
sender	object
e	System.Data.SqlClient.SqlRowsCopiedEventArgs
리턴	void

프로퍼티 상세

Mappings 공개적으로 프로퍼티

The mapping of columns from the row to the database schema. Important: The column name in the database is case sensitive!

public IDictionary Mappings
리턴	string>.IDictionary