Kinetica   C#   API  Version 7.2.3.1
KineticaAdo Namespace Reference

Classes

class  CsvFileReader
 Reads CSV/TSV/PSV files and inserts records into Kinetica using bulk insert. More...
 
class  CsvParser
 Simple CSV parser that handles quoted fields and escapes. More...
 
class  FileInsertOptions
 Options for INSERT FROM FILE operations. More...
 
class  InsertBatchManager
 Manages bulk insert operations for the ADO.NET driver. More...
 
class  InsertBatchOptions
 Options for batch insert operations. More...
 
class  InsertFromFileInfo
 Information about an INSERT INTO...SELECT FROM FILE statement. More...
 
class  InsertStatementParser
 SQL INSERT statement parser that extracts table name, column names, and values. More...
 
class  KineticaCommand
 
class  KineticaConnection
 
class  KineticaConnectionException
 
class  KineticaConnectionPool
 
class  KineticaConnectionStringBuilder
 Provides a comprehensive connection string builder with JDBC-compatible properties. More...
 
class  KineticaDataReader
 
class  KineticaException
 
class  KineticaPagingDataReader
 A paging data reader that fetches records in batches for large result sets. More...
 
class  KineticaParameter
 
class  KineticaParameterCollection
 
class  KineticaProviderFactory
 
class  KineticaProviderRegistration
 
class  KineticaSchemaProvider
 
class  KineticaSqlException
 
class  KineticaTransaction
 Provides ADO.NET transaction API compatibility for Kinetica. More...
 
class  ParsedCommand
 Represents a parsed SQL command with extracted metadata. More...
 
class  ParsedInsert
 Parsed INSERT statement result. More...
 
class  QueryHints
 Query optimization hints extracted from SQL. More...
 
class  SQLParser
 SQL parser with support for JDBC-compatible features including: More...
 
class  TableBatchContext
 Manages batch context for a single table using BulkInserter<GenericRecord>. More...
 
class  UserImpersonationInfo
 User impersonation information for SET USER/EXECUTE AS commands. More...
 

Enumerations

enum  ParsedCommandType {
  ParsedCommandType.Select,
  ParsedCommandType.Insert,
  ParsedCommandType.InsertFromFile,
  ParsedCommandType.Update,
  ParsedCommandType.Delete,
  ParsedCommandType.CreateTable,
  ParsedCommandType.DropTable,
  ParsedCommandType.SetUser,
  ParsedCommandType.ExecuteAsUser,
  ParsedCommandType.Revert,
  ParsedCommandType.SetSchema,
  ParsedCommandType.Other
}
 Types of parsed SQL commands. More...
 
enum  ImpersonationType {
  ImpersonationType.SetUser,
  ImpersonationType.ExecuteAs,
  ImpersonationType.Revert
}
 Types of user impersonation commands. More...
 
enum  FileFormat {
  FileFormat.Auto,
  FileFormat.DelimitedText,
  FileFormat.Parquet,
  FileFormat.Json,
  FileFormat.Avro,
  FileFormat.Shapefile
}
 Supported file formats for INSERT FROM FILE operations. More...
 
enum  FileErrorMode {
  FileErrorMode.Abort,
  FileErrorMode.Skip,
  FileErrorMode.Permissive
}
 Error handling modes for file insert operations. More...
 

Enumeration Type Documentation

◆ FileErrorMode

Error handling modes for file insert operations.

Enumerator
Abort 

Abort on first error.

Skip 

Skip problematic rows and continue.

Permissive 

Attempt to insert partial records.

Definition at line 3432 of file KineticaAdo.cs.

◆ FileFormat

Supported file formats for INSERT FROM FILE operations.

Enumerator
Auto 

Auto-detect format from file extension.

DelimitedText 

Delimited text (CSV, TSV, PSV).

Parquet 

Apache Parquet format.

Json 

JSON format.

Avro 

Apache Avro format.

Shapefile 

Shapefile format.

Definition at line 3413 of file KineticaAdo.cs.

◆ ImpersonationType

Types of user impersonation commands.

Enumerator
SetUser 

SET USER "username" - Changes execution context.

ExecuteAs 

EXECUTE AS USER "username" - Temporary context switch (can be reverted).

Revert 

REVERT - Returns to previous user context.

Definition at line 3312 of file KineticaAdo.cs.

◆ ParsedCommandType

Types of parsed SQL commands.

Enumerator
Select 
Insert 
InsertFromFile 
Update 
Delete 
CreateTable 
DropTable 
SetUser 
ExecuteAsUser 
Revert 
SetSchema 
Other 

Definition at line 3189 of file KineticaAdo.cs.