Perform bulk data insertion
Namespace: Wiker.WIDatabaseAssembly:
Syntax
C# |
---|
public bool Bulk( Collection<CInsertItem> inserts ) |
Visual Basic |
---|
Public Function Bulk ( _ inserts As Collection(Of CInsertItem) _ ) As Boolean |
Visual C++ |
---|
public: bool Bulk( Collection<CInsertItem^>^ inserts ) |
Parameters
- inserts
- Type: System.Collections.ObjectModel..::..Collection<(Of <(<'CInsertItem>)>)>
Collection of CInsertItem to be inserted
Return Value
bool
Remarks
Upon completion WIDatabase.SQLStatement contains SQL command generated by the library
Examples

WIDatabase WIDB; Collection<CInsertItem>Inserts; CInsertItem Insert; int i; Inserts = new Collection<CInsertItem>(); for (i = 0; i < 10; i ++) { Insert = new CInsertItem(); Insert.Column("Bool", BoolData); Insert.Column("Byte", ByteData); Insert.Column("Int16", Int16Data); Insert.Column("Int32", Int32Data); Insert.Column("Int64", Int64Data); Insert.Column("Decimal", DecimalData); Insert.Column("Double", DoubleData); Insert.Column("Float", FloatData); Insert.Column("DateTime", DateTimeData); Insert.Column("Char", CharData); Insert.Column("VarChar", VarCharData); Insert.Column("Text", TextData); Insert.Column("Image", ImageData); Insert.Column("Binary", BinaryData); Inserts.Add(Insert); } WIDB.Insert.Table("tblDataType"); if (!WIDB.Insert.Bulk(Inserts) return(false); WIDB.Close();