Invoke SQLiteTable

NAME

Invoke-SQLiteTable

SYNOPSIS

Bulk insert to SQLite Database

DESCRIPTION

Bulk insert [System.Data.DataTable] to SQLite database

PARAMETERS

INPUTS

None. You cannot pipe objects to Invoke-SQLiteTable.

OUTPUTS

Work in progress (maybe count of updates/inserts)

EXAMPLES

-------------------------- EXAMPLE 1 --------------------------
C:\PS>Invoke-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>]
Inserts or ignores records to database table.

-------------------------- EXAMPLE 2 --------------------------
C:\PS>Invoke-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [[-Update] <Column>]
Inserts or ignores records then updates row where -Update <Column> = Row.Value

-------------------------- EXAMPLE 3 --------------------------
C:\PS>Invoke-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [-Replace]
Inserts records or replaces row.

-------------------------- EXAMPLE 4 --------------------------
C:\PS>Invoke-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [-WhatIf]
Shows import query, runs the import but rollsback the changes so no changes are made to database. (debug)

RELATED LINKS

http://www.proxx.nl/