KineticaAdo.FileInsertOptions Class Reference

Options for INSERT FROM FILE operations. More...

Properties
FileFormat	Format = FileFormat.Auto [get, set]
	File format. Default: Auto (detected from extension). More...
int	BatchSize = 10000 [get, set]
	Batch size for bulk insert operations. Default: 10000. More...
char	Delimiter = ',' [get, set]
	Field delimiter character. Default: comma for CSV, auto-detected from extension. More...
char	QuoteChar = '"' [get, set]
	Quote character for string fields. Default: double-quote. More...
char	EscapeChar = '\0' [get, set]
	Escape character for special chars. Default: none. More...
string	NullString = "\\N" [get, set]
	String that represents NULL values. Default: \N. More...
string?	CommentPrefix [get, set]
	Comment line prefix (lines starting with this are skipped). More...
int	Skip = 0 [get, set]
	Number of lines to skip from beginning. Default: 0. More...
int	Limit = 0 [get, set]
	Maximum number of rows to read. Default: unlimited (0). More...
bool	HasHeader = true [get, set]
	Whether the file has a header row. More...
bool	InitialClear = false [get, set]
	Whether to clear the table before inserting. Default: false. More...
FileErrorMode	ErrorMode = FileErrorMode.Abort [get, set]
	Error handling mode. More...
bool	IgnoreExistingPk = false [get, set]
	Whether to ignore records with duplicate primary keys. Default: false. More...
bool	UpdateOnExistingPk = false [get, set]
	Whether to update records with duplicate primary keys. Default: false. More...
bool	TruncateStrings = false [get, set]
	Whether to truncate strings that exceed column length. Default: false. More...
bool	DryRun = false [get, set]
	Whether this is a dry run (validate without inserting). Default: false. More...

Detailed Description

Options for INSERT FROM FILE operations.

Matches JDBC driver's supported options.

Definition at line 3359 of file KineticaAdo.cs.

Property Documentation

BatchSize

int KineticaAdo.FileInsertOptions.BatchSize = 10000

getset

Batch size for bulk insert operations. Default: 10000.

Definition at line 3365 of file KineticaAdo.cs.

CommentPrefix

string? KineticaAdo.FileInsertOptions.CommentPrefix

getset

Comment line prefix (lines starting with this are skipped).

Definition at line 3380 of file KineticaAdo.cs.

Delimiter

char KineticaAdo.FileInsertOptions.Delimiter = ','

getset

Field delimiter character. Default: comma for CSV, auto-detected from extension.

Definition at line 3368 of file KineticaAdo.cs.

DryRun

bool KineticaAdo.FileInsertOptions.DryRun = false

getset

Whether this is a dry run (validate without inserting). Default: false.

Definition at line 3407 of file KineticaAdo.cs.

ErrorMode

FileErrorMode KineticaAdo.FileInsertOptions.ErrorMode = FileErrorMode.Abort

getset

Error handling mode.

Definition at line 3395 of file KineticaAdo.cs.

EscapeChar

char KineticaAdo.FileInsertOptions.EscapeChar = '\0'

getset

Escape character for special chars. Default: none.

Definition at line 3374 of file KineticaAdo.cs.

Format

FileFormat KineticaAdo.FileInsertOptions.Format = FileFormat.Auto

getset

File format. Default: Auto (detected from extension).

Definition at line 3362 of file KineticaAdo.cs.

HasHeader

bool KineticaAdo.FileInsertOptions.HasHeader = true

getset

Whether the file has a header row.

Definition at line 3389 of file KineticaAdo.cs.

IgnoreExistingPk

bool KineticaAdo.FileInsertOptions.IgnoreExistingPk = false

getset

Whether to ignore records with duplicate primary keys. Default: false.

Definition at line 3398 of file KineticaAdo.cs.

InitialClear

bool KineticaAdo.FileInsertOptions.InitialClear = false

getset

Whether to clear the table before inserting. Default: false.

Definition at line 3392 of file KineticaAdo.cs.

Limit

int KineticaAdo.FileInsertOptions.Limit = 0

getset

Maximum number of rows to read. Default: unlimited (0).

Definition at line 3386 of file KineticaAdo.cs.

NullString

string KineticaAdo.FileInsertOptions.NullString = "\\N"

getset

String that represents NULL values. Default: \N.

Definition at line 3377 of file KineticaAdo.cs.

QuoteChar

char KineticaAdo.FileInsertOptions.QuoteChar = '"'

getset

Quote character for string fields. Default: double-quote.

Definition at line 3371 of file KineticaAdo.cs.

Skip

int KineticaAdo.FileInsertOptions.Skip = 0

getset

Number of lines to skip from beginning. Default: 0.

Definition at line 3383 of file KineticaAdo.cs.

TruncateStrings

bool KineticaAdo.FileInsertOptions.TruncateStrings = false

getset

Whether to truncate strings that exceed column length. Default: false.

Definition at line 3404 of file KineticaAdo.cs.

UpdateOnExistingPk

bool KineticaAdo.FileInsertOptions.UpdateOnExistingPk = false

getset

Whether to update records with duplicate primary keys. Default: false.

Definition at line 3401 of file KineticaAdo.cs.

---

The documentation for this class was generated from the following file:

• AdoDotnetDriver/KineticaAdo.cs