API documentation in HTML format is available for download sqlcebulkcopydoc.1.1.zip

Last edited Aug 16, 2011 at 7:01 AM by ErikEJ, version 3


flobadob Mar 5, 2015 at 10:13 AM 
One can combine the SqlBulkCopy and the SqlCeBulkCopy quite easily by taking Jarod Ferguson's sample code from here...

And altering the first few lines to this...

public static void BulkInsert<T>(string connection, string tableName, IList<T> list, MetadataConnectionType connectionType)
dynamic bulkCopy = null;
if (connectionType == MetadataConnectionType.MicrosoftSqlExpress)
bulkCopy = new SqlBulkCopy(connection);
else if (connectionType == MetadataConnectionType.MicrosoftSqlCompactEdition)
bulkCopy = new ErikEJ.SqlCe.SqlCeBulkCopy(connection);

where connectionType is just an enum.

flobadob Mar 5, 2015 at 8:40 AM 
Hi Erik, the link to the docs is currently broken.