Class MySqlBulkLoader

Inheritance
System.Object
MySqlBulkLoader
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: MySql.Data.MySqlClient
Assembly: NFX.MySQL.dll
Syntax
public sealed class MySqlBulkLoader

Constructors

MySqlBulkLoader(MySqlConnection)

Declaration
public MySqlBulkLoader(MySqlConnection connection)
Parameters
Type Name Description
MySqlConnection connection

Properties

CharacterSet

Declaration
public string CharacterSet { get; set; }
Property Value
Type Description
System.String

Columns

Declaration
public List<string> Columns { get; }
Property Value
Type Description
System.Collections.Generic.List<System.String>

ConflictOption

Declaration
public MySqlBulkLoaderConflictOption ConflictOption { get; set; }
Property Value
Type Description
MySqlBulkLoaderConflictOption

Connection

Declaration
public MySqlConnection Connection { get; set; }
Property Value
Type Description
MySqlConnection

EscapeCharacter

Declaration
public char EscapeCharacter { get; set; }
Property Value
Type Description
System.Char

Expressions

Declaration
public List<string> Expressions { get; }
Property Value
Type Description
System.Collections.Generic.List<System.String>

FieldQuotationCharacter

Declaration
public char FieldQuotationCharacter { get; set; }
Property Value
Type Description
System.Char

FieldQuotationOptional

Declaration
public bool FieldQuotationOptional { get; set; }
Property Value
Type Description
System.Boolean

FieldTerminator

Declaration
public string FieldTerminator { get; set; }
Property Value
Type Description
System.String

FileName

The name of the local (if Local is true) or remote (otherwise) file to load. Either this or SourceStream must be set.

Declaration
public string FileName { get; set; }
Property Value
Type Description
System.String

LinePrefix

Declaration
public string LinePrefix { get; set; }
Property Value
Type Description
System.String

LineTerminator

Declaration
public string LineTerminator { get; set; }
Property Value
Type Description
System.String

Local

Declaration
public bool Local { get; set; }
Property Value
Type Description
System.Boolean

NumberOfLinesToSkip

Declaration
public int NumberOfLinesToSkip { get; set; }
Property Value
Type Description
System.Int32

Priority

Declaration
public MySqlBulkLoaderPriority Priority { get; set; }
Property Value
Type Description
MySqlBulkLoaderPriority

SourceStream

A System.IO.Stream containing the data to load. Either this or FileName must be set. The Local property must be true if this is set.

Declaration
public Stream SourceStream { get; set; }
Property Value
Type Description
System.IO.Stream

TableName

Declaration
public string TableName { get; set; }
Property Value
Type Description
System.String

Timeout

Declaration
public int Timeout { get; set; }
Property Value
Type Description
System.Int32

Methods

Load()

Declaration
public int Load()
Returns
Type Description
System.Int32

LoadAsync()

Declaration
public Task<int> LoadAsync()
Returns
Type Description
System.Threading.Tasks.Task<System.Int32>

LoadAsync(CancellationToken)

Declaration
public Task<int> LoadAsync(CancellationToken cancellationToken)
Parameters
Type Name Description
System.Threading.CancellationToken cancellationToken
Returns
Type Description
System.Threading.Tasks.Task<System.Int32>

Extension Methods