I have an application that deploys fine using SQL Compact 3.5 (on Windows 2008 Server). However, when I changed the references, the provider string, and the dll's to SQL Compact 4.0 I get the message:
...

Im not sure whether this is the place for this question but here goes:
I have a read-only database, it contains many tables which are accessed and searched using c# desktop application.
I am looking ...

I have WPF application that is using EF6 with local SQL Server Compact Edition 4.0 database.
I’m using private deployment for SQL Server Compact Edition.
Application works without any errors on 99% ...

I am using an SqlCe 4 database with an Entity Framework 6 code first data model.
I set the connection string in the DbContext constructor like so:
private static readonly string DATABASE_PASSWORD = ...

I have an odd problem - I have a table called Item which links to a table called brand via a BrandID key in the Item table.
I have a EF Code First model that has the Navigation property as follows in ...

Similar to this question I am running through a datatable, using the data to fill a new dataset for the purposes of data migration.
The migration inserts into a data set then every 5000 records the ...

I have an empty database which will contain a migrated form of an old legacy database.
I read in all of the old data into DataTables which works fine.
There is one master table which contains links ...

I have a data migration tool which until recently seemed to work really well.
I run through a collection of data rows using Parallel.Foreach, calculate some variables to be inserted into a new record ...

I have a C# application intended to migrate data from MS Access to SQL Server Compact 4.0
There is a large amount of data and as such I am utilising a large number of Parallel.Foreach statements to ...

Okay, this one is really puzzling me, and I apologize if the title of the question doesn't accurately describe what my problem is.
I have a program made in C#, using Entity Framework and SQL Server ...

I'm trying to add my existing "SQL Server Compact 4.0" database into my C# WinForm application, for that I'm following this msdn article but when I browse to the location of database file (.sdf) and ...

I have code to create a database (tables plus indexes) written in C++ using ATL/OLEDB.
The fact that my code has to be aware of the DB schema for DB file creation purposes is very undesireable.
One ...

I have an application using the Code First model with Entity Framework 6.1 and SQL Server Compact Edition 4. Inserting into a simple table with an ID, 1 DateTime 2 singles, 2 doubles, and 3 Ints is ...

I am currently using SQL Server CE 4.0 and accessing the database using the ATL OLEDB C++ API.
I am using a shared connection (CDataSource object) across threads with a separate CSession object per ...

I am running some very large databases (500 MB and 300 MB) in my application on several different machines.
From a hardware perspective, the machines have been identically configured.
I am using SQL ...

I'm looking for a very simple example of SyncFrameworkToolkit with a SQL Server CE local database synchronizing with the templated web service and provisioned remote sql server. Seems like a rather ...

I'm attempting to combine the logic for some of my SQL queries, and I can't seem to figure out this problem. Obviously SQL Server CE has many limitations compared to SQL Server or mySQL, but surely ...

I'm new to SQL and have inherited a database which uses nvarchar(50) as the data type for the "Date" column. I want to convert this column into datetime format but I cannot figure out how to do so as ...

I'm using Sql Server Compact for automated integration tests of our web application, which runs the latest version of Sql Server (large? uncondensed?). The idea was to use a more lightweight database ...

I have a SQL Compact 4.0 database with a table that has about 20 columns and about 1,000,000 rows.
The problem I have is with performance which because users might use these 20 columns to filter the ...

I want to try using code first to connect to an existing SQL Server Compact Edition database, as described here. The tutorial however shows how to connect to a SQL Server or LocalDb.
The main problem ...