Invoke SQLiteFill

.NAME

Invoke-SQLiteFill

.SYNOPSIS

Bulk insert <DataTable> to SQLite Table. WARNING: this will overwrite all Rows in table

.PARAMETERS

 -Connection <SQLiteConnection>
     
     Required?                    true
     Position?                    1
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -InputObject <DataTable>
     
     Required?                    true
     Position?                    2
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Name <String>
     
     Required?                    true
     Position?                    3
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Whatif [<SwitchParameter>]
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false

.INPUTS

None. You cannot pipe objects to Invoke-SQLiteFill.

.OUTPUTS

Count of rows inserted to SQLite Table

.NOTES

 Author: Proxx
 Web:    www.Proxx.nl 
 Date:    10-06-2015

.EXAMPLES

 -------------------------- EXAMPLE 1 --------------------------
 
 PS C:\>Invoke-SQLiteFill -conn <SQLiteConnection> -InputObject <DataTable> -Name <String>
 
 
 
 Fills Table in SQLite (WARNING: this will overwrite all Rows in table)
 
 
 
 
 
 -------------------------- EXAMPLE 2 --------------------------
 
 PS C:\>Invoke-SQLiteFill -conn <SQLiteConnection> -InputObject <DataTable> -Name <String> -WhatIf
 
 
 
 Creates SQLite transaction inserts rows and then rollsback the transaction

.RELATED LINKS

http://www.proxx.nl/Wiki/Invoke-SQLiteFill