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

Time (CLR Timespan) column using EF4.1 Code-First approach and SqlCe 4.0

I'be been trying to map a Timespan property to a SqlCe 4.0 database using EntityFramework 4.1 Code-First approach, and of course I'm getting a NotSupportedException saying there's no store corresponding EDM type 'Time' and CLR type 'Timespan'. I was…
Guilherme Duarte
  • 3,371
  • 1
  • 28
  • 35
0
votes
1 answer

How can I update only submitted fields?

I need to update various fields in a table. Question part 1: How can I only send the necessary arguments? I can do that in JavaScript like below: myUpdateFunction( {tableID: 45, personFirstName: 'Blah'} ); // and then myUpdateFunction(…
Nime Cloud
  • 6,162
  • 14
  • 43
  • 75
0
votes
1 answer

SQLCE: How to Count Datepart

For a long time I am struggling with the following subject: I want to count datepart values. I use SQL Compact Edition 4.0 and have no idea on how to get the following: select datepart(week, CreateDate) as Week, count(*) from tblOrders where…
Pete
  • 77
  • 3
  • 10
0
votes
1 answer

MSSQLCE: Subquery returns parsing error

I've added an ID column (personID) into a table (personList) instead of another field: personPin Now I need to fill empty foreign key field (seenPersonID) of another table (personAttendances) UPDATE personAttendances SET seenPersonID = (SELECT…
Nime Cloud
  • 6,162
  • 14
  • 43
  • 75
0
votes
1 answer

Using SQL Compact 4 in Visual C# 2010 express

It is posible to use SQL Server Compact 4 inside Visual C# 2010 Express? I tried reinstall it many times (with Web Platform Installer and without it) but I still cannot see option for SQL Compct 4 in Data Source selection window. But what is…
Lukas Pirkl
  • 1,417
  • 3
  • 15
  • 31
0
votes
1 answer

Asynchronous synchronization Sql Server CE 4.0 to centralized Sql Server 2008

If Sql Server CE 4.0 is being used as an edge cache for a distributed web application, how would one asynchronously synchronize the data back to a centralized database for reporting purposes? Secondly, would this be possible inside of shared hosting…
Chris Marisic
  • 32,487
  • 24
  • 164
  • 258
0
votes
2 answers

Entity Framework 4.1 DatabaseGeneratedOption.Identity Performance

I currently working on a application that use Entity Framework 4.1 (code first) and SQL Server CE 4.0. One of the new things I really like from SQL Server CE 4.0 are the computed values. But I have some performance problem while importing old data…
Fox32
  • 13,126
  • 9
  • 50
  • 71
0
votes
1 answer

Run exe file to downsize SQL Server to SQL Server CE

I'm trying to convert a SQL Server 2008 R2 database to SQL Server CE 4. The only solution I can find is detailed here: http://erikej.blogspot.com/2010/02/how-to-use-exportsqlce-to-migrate-from.html. However, I've downloaded the .exe and opened…
Dan
  • 5,836
  • 22
  • 86
  • 140
0
votes
1 answer

Entity Framework 6 and SQL Server CE with code-first

I'm using Entity Framework (code-first approach) and a SQL Server CE database. I have the problem that the SQL Server CE database is not created and it seems that the app.config file isn't used because there is a false connection string inside the…
DrCrazyApe
  • 21
  • 3
0
votes
1 answer

Exception changing password of existing SQL Server CE database

Using SQL Server CE 4.0.8876.1 (NuGet package). I'm trying to change the password of an existing SQL Server CE database as per this article:…
dan
  • 801
  • 15
  • 41
0
votes
2 answers

SQL-query slow in SQL Server CE but fast in SQL Server

I'm working on a product where I need to support both SQL Server and SQL Server CE (4.0). I have two tables where one is an entity and the other is relation-table, something like…
Markus Knappen Johansson
  • 1,461
  • 17
  • 19
0
votes
0 answers

Disable button click after first click

I am developing a point of sale system using vb.net and SQL Server Compact 4.0. I have a new transaction button that generates a new invoice number using id once clicked. But the problem is its generates a new invoice even when an existing…
kelvin
  • 1
0
votes
1 answer

SQL Ce 4 - How can I run DBCC CHECKIDENT

I want to run DBCC CHECKIDENT on a SqlCe4 database but it wont let me. I need to reset the identity column as its messed up. I think because IDENTITY was turned off, an import of data was done and then IDENTITY turned on again so I guess its out of…
jon
  • 37
  • 2
  • 4
0
votes
1 answer

Auto generate DB with entity framework model first design

I have used both the EF code first and model first apporaches. In my case the model first approach has overall been better for my use. The only thing I miss from code first is that it would auto generate the mappings, and then use those mappings…
Mathflair
  • 47
  • 5
0
votes
2 answers

Scripting / backing up a SqlServerCE db to management studio

I have been developing a site using entity framework and sql server compact edition that is no wready to be deployed. SqlCE along with EF code first has been great - it has dramatically reduced my development time. However, I am hosting the site…
jcvandan
  • 14,124
  • 18
  • 66
  • 103
1 2 3
…
16 17