Version 2.1 of my SQL Server Compact Bulk Insert Library has now been released. This library exposes an API similar to the SqlBulkCopy API implemented for the SqlClient (working against SQL Server). The library allows you to quickly load data inot a SQL Server Compact database.
New features in this release include:
3 editions of the library:
One for .NET Compact Framework for version 3.5 databases – ErikEJ.SqlCe.NetCF.dll
One for full .NET Framework for version 3.5 databases – ErikEJ.SqlCe.dll
One for full .NET Framework for version 4.0 databases – ErikEJ.SqlCe40.dll
– New overloads of the WriteToServer method allows you to load any .NET list that implements IEnumerable or IEnumerable<T>
– API Documentation is now available in HTML format here. The API documentation was created very easily using the open source ImmDoc.NET utility. All this command line utility requires is XML comments file and the DLL file(s).
– NuGet package available
A NuGet package, that includes the SQL Server Compact 4.0 library is now available via the NuGet Package Manager.
If you need to load data fast from a DataTable, DataReader or .NET List to a SQL Server Compact database file, this is the library for you.