SqlCeBulkCopy | NET Library for loading data | SQL Database library
kandi X-RAY | SqlCeBulkCopy Summary
kandi X-RAY | SqlCeBulkCopy Summary
.NET Library for loading data fast (doing bulk inserts) into a SQL Server Compact database file. Attempts to mimic the SqlClient SqlBulkCopy API.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of SqlCeBulkCopy
SqlCeBulkCopy Key Features
SqlCeBulkCopy Examples and Code Snippets
Community Discussions
Trending Discussions on SqlCeBulkCopy
QUESTION
Here is the thing: I can copy data from a SQL Server database to my local (.sdf
) using SQL Server CE using this code:
ANSWER
Answered 2017-Oct-27 at 05:43Do not use DataTable, it incurs a lot of unneded overhead, but get the data from SQL Server via a SqlDataReader.
Then you can use my SqlCeBulkCopy library to do very fast INSERTs into the SQL Compact database. (May require you to work with empty tables, though)
using ErikEJ.SqlCe;
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install SqlCeBulkCopy
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page