Perform bulk data insertion

Namespace: Wiker.WIDatabase
Assembly: 

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

CopyC#
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();

See Also