Stack Overflow
Stack Overflow

Questions tagged [sql-server-ce-4]

Microsoft SQL Server Compact version 4 is a SQL Server embedded database for building standalone and occasionally connected applications for mobile devices, desktops, and Web clients.

Use this tag if you encounter issues specific for version 4.0 of sql-server-ce. For not version specific issues use the generic tag .

The tag would be primarily used for questions addressing these features:

  • Using CE in combination with Microsoft WebMatrix
  • Designer and debugging capabilities in Visual Studio
  • Medium or partial trust environments in the web servers
  • Sit-by-site deployment
  • The SHA2 encryption algorithms for encrypting the databases
  • T-SQL syntax for OFFSET and FETCH
  • New APIs like SqlCeConnection.GetSchema
  • Server generated keys like identity, rowguid etc.

Taken from the download page

254 questions
0
votes
1 answer

Please Wait While Windows Configures Application - SQL Compact 4 & EF - App Launch

I recently switched a windows forms application to use SQL Compact 4 database and Entity Framework. I handle the updates to the application through the application (no windows services). When an update is sent out to the device, all data is cleared…
teynon
  • 7,540
  • 10
  • 63
  • 106
0
votes
1 answer

Determining Rows Inserted After A Period of Time

I have a list of students in a SQL CE 4.0 database. Each one has an insert time associated with the student. Here is the context setup. public class Student { public int StudentId { get; set; } public string Name { get; set;…
cgatian
  • 22,047
  • 9
  • 56
  • 76
0
votes
0 answers

SQL Server CE 4.0 - DbUpdate Exception was unhandled

I am struggling with SQL Server CE 4.0 almost all day. I get this error when I try to save new record (entity) to my database. First a little preview - I installed SQL Server CE 4.0 via NuGet and I created a database for my project. Then I created…
Leron
  • 9,546
  • 35
  • 156
  • 257
0
votes
0 answers

SQL Server compact 4 silent install

My program uses SQL Ce 4 and I want to install my program and install the SQL CE4 at the same time, but silently. Searching the internet, someone says that I need to copy/paste the .dll to the instalation folder. But it's not working, I don't know…
Nicke Manarin
  • 3,026
  • 4
  • 37
  • 79
0
votes
1 answer

does SQL Server compact 4.0 requries sql server installed

I'm doing some testing with sql server compact 4.0 added into an mvc application. do you know if this is required to be installed on an sql server 8.0 when i deploy to web server or does the compact version come with a pre-built sql server engine,…
user1929393
  • 4,089
  • 7
  • 30
  • 48
0
votes
0 answers

SQL Server CE 4.0 error when installed before Net framework 4 on my app setup

I have my app that needs SQL Server CE 4.0 (using Entity Framework) and net framework 4. I put into requirements net framework 4 and SQL Server CE 4.0 (for this last one I have to make a special requirement because it is not in the default…
emmanuel sio
  • 1,935
  • 3
  • 24
  • 26
0
votes
1 answer

Why whenever touching Server Explorer, database contents is erased?

Update I've just found what's causing it but couldn't solve it : When running the project, VS copies the SDF file to bin\Debug, therefore, any changes made to it, even if only refreshing the DB will cause it to be overwritten... I've created a…
aybe
  • 15,516
  • 9
  • 57
  • 105
0
votes
1 answer

ClickOnce deploy of WPF app with SQL Server Compact database

I read this post which apparently solves the issue with WPF app publishing which has SQL Server Compact dependency. I went through all the steps prescribed by the author of this post but it just doesn't work for me. Once I add all the DLLs from SQL…
Michael IV
  • 11,016
  • 12
  • 92
  • 223
0
votes
1 answer

Windows XP The specified locale is not supported on this operating system. [ LCID = 16393 ]

I Use the Sql Server Compact edition 4.0 and have installed on my System (windows 7). From my Solution when i run this works fine basically the line of code SqlCeConnection.Open() with the connection string as "DataSource='E://S.sdf';" There is No…
user581157
  • 1,327
  • 4
  • 26
  • 64
0
votes
1 answer

Is there any tool with which I can upgrade my CE database to 4.0?

I'm having trouble creating a .NET project. I already have some database with extension .sdf and whenever I intend to connect to it I get the following error: The database file has been created by an earlier version of SQL Server Compact. Please…
ye9ane
  • 1,959
  • 3
  • 18
  • 31
0
votes
1 answer

SQL Server CE 4 very poor performance on XP SP3

I have a SQL Server Compact 4.0 database with Entity Framework 4.3 and Encryption enabled with Platform Default mode and this is its connection string: Data Source={Database File};Password={MyPassword}; Encryption Mode=Platform Default;Persist…
mrtaikandi
  • 6,753
  • 16
  • 62
  • 93
0
votes
0 answers

Moving to SQL Server CE 4 from SQL Server

I have a website where I have an SQL Server database, but I want to get rid of SQL Server and move into a more compact/modular system. SQL Server CE 4 suits my needs, but I have a problem. I've searched for hours and couldn't find a tool to move my…
Can Poyrazoğlu
  • 33,241
  • 48
  • 191
  • 389
0
votes
1 answer

Strategy for implementing a composite key of which the second part is rarely discriminating. Entity Framework Code First

I have the following scenario: An Atom Entity is usually unique and can be stored in the database using a single AtomID field as its primary key.. In rare cases theAtomneeds to be split. In that case a second record must be created in the database…
Dabblernl
  • 15,831
  • 18
  • 96
  • 148
0
votes
0 answers

SQL Server CE 4 Asynchronous calls

I'm trying to create async calls to SQL Server CE 4 database. As I understand there is no asynchronous processing param for connection string and BeginExecuteReader command for the command object. My aim is to provide async calls to SELECT command…
Denis Kucherov
  • 369
  • 3
  • 15
0
votes
2 answers

Change password of SDF database file (SQL Server Compact 4.0)

I would like to change the password of my SQL Server Compact 4.0 database. Is this possible out of Visual Studio 2010 (Ultimate, SP1)? Any help would be appreciated!
K B
  • 1,330
  • 1
  • 18
  • 30
1 2 3
…
16
17