SQL Server to SQL Server CE table data copy using SqlBulkCopy

Question

I'm working on a Windows CE application, and I need to copy server table data to SQL Server CE database (local) using C# programming. I'm using Visual Studio 2008, SQL Server 2008 for the development.

Below is the code I'm working with, but it seems in VS2008 SqlBulkCopy isn't supported. Do we have any alternatives to achieve this functionality?

SqlConnection source = new SqlConnection(Con_s);// server connection string SQL Server

SqlCeConnection destination = new SqlConnection(Con_l);// Local connection string SQL Server CE DB
SqlCeCommand cmd = new SqlCeCommand("DELETE FROM ProductList", destination);
source.Open();

destination.Open();
cmd.ExecuteNonQuery();

cmd = new SqlCommand("SELECT * FROM Products", source);

SqlDataReader reader = cmd.ExecuteReader();

SqlBulkCopy bulkData = new SqlBulkCopy(destination);
bulkData.DestinationTableName = "ProductList";

bulkData.WriteToServer(reader);

bulkData.Close();
destination.Close();
source.Close();

Add: I have included both using System.Data.SqlClient; & using System.Data; in the code

The local SQL Server CE connection must use SqlCeConnection and SqlCeCommand !! — marc_s
– marc_s, Commented Aug 7, 2016 at 15:56
This has nothing to do with VS2008 - the problem is: SqlBulkCopy is only for "real" SQL Server (Express and others) - but NOT for the Compact Edition (which is really a totally different, separate product). But maybe this project on CodePlex could be of help to you — marc_s
– marc_s, Commented Aug 7, 2016 at 17:03
@jobin Can we know what kind of exception you are getting while compiling/executing the above code?. — Hameed Syed
– Hameed Syed, Commented Aug 8, 2016 at 11:01

Hameed Syed · Accepted Answer · 2016-08-09 07:17:04Z

1

Since I cannot paste image in the comments,I am including it as answer. SqlBulkcopy is present under System.Data.SqlClient namespace. Just navigate to SqlBulkcopy namespace,you must get navigated to the below

If not I think your dll is corrupted may be you need to reload new one.

answered Aug 9, 2016 at 7:17

Hameed Syed

4,3532 gold badges23 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server to SQL Server CE table data copy using SqlBulkCopy

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related