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
2 answers

SQL Server CE: how to save an amound of time?

I need to save an amount of time (3 days, 1 month, 5 years, etc). Datetime seems to be for saving a date and time (4/5/14 21:03). I could save the number of days as a number, but I will like to be able to save in different units (days, weeks,…
Aimnox
  • 895
  • 7
  • 20
0
votes
0 answers

"A later version of Microsoft SQL Server Compact is already installed"

I managed to include, and deploy to Azure websites, SQL Server Compact 4.0 in a MVC project by using Nuget. I then try to install Microsoft SQL Server Compact 4.0 on my PC via this link. But it couldn't proceed with: A later version of Microosft…
Old Geezer
  • 14,854
  • 31
  • 111
  • 198
0
votes
1 answer

Setting SQL Server CE connection for a dll class library

I can build an app using Windows Forms connecting to a SQL Server CE .sdf file to read and write. Now I need to do the same for a class library .dll project which intended to be a Revit Add-in so I added app.config and Settings.settings as well but…
Ibrahem Hamdy Naeem
  • 35
  • 6
0
votes
2 answers

'System.StackOverflowException' occurred in System.Data.SqlServerCe.dll

I'm using SQL CE 4.0 and am running into a StackOverflowException when the SqlCeDataAdapter attempts to Fill the DataTable. The code is pretty standard : using (var cmd = new SqlCeCommand(sql, conn, tran)) using (var dt = new DataTable()) { …
Code Maverick
  • 20,171
  • 12
  • 62
  • 114
0
votes
1 answer

Migrate SQL Server CE to Azure

I have finished my first complete Orchard CMS website, developed locally in SQL Server CE. I want to publish it to Azure, but I am having difficulty with the WebMatrix Migrate function. I have a SQL Server instance in Azure with an blank Orchard…
hsimah
  • 1,265
  • 2
  • 20
  • 37
0
votes
0 answers

SQL Server CE provider with invariant name 'System.Data.SqlServerCe.4.0' could not be loaded

Good evening everyone. I try to use SQL Server Compact Edition and Entity Framework in simplest console application. But I get the following exception. The Entity Framework provider type …
Qwerty Qwerty
  • 581
  • 1
  • 6
  • 19
0
votes
1 answer

The ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0' is either not registered

We're trying to deploy our MVC solution to a customer, but they're getting an error while trying to log in. I have searched for similar issues, but have not yet found a solution. It does have SQL CE 4.0 installed. I have checked app.config, but it…
Mick
  • 837
  • 8
  • 23
0
votes
1 answer

SQL Server Compact 4.0 not running on x86

C# project / Visual Studio 2015 Build PC Windows 7 Pro 64 bit Client PC Windows 7 32 bit (x86) SQL Server Compact 4.0 / .net Framework 4.5 Code: /// /// Connects this instance. /// /// public bool…
ConcordCA
  • 23
  • 1
  • 1
  • 6
0
votes
1 answer

How can I target a EF6 migration to only execute on SQL Server?

I would like to ensure specific features are turned on in SQL Server. I am currently using EF6 Migrations to generate my change scripts. I am using my migrations against both SQL Server 2012 and SQL Server CE 4 (for basic unit testing of my…
NotMyself
  • 29,209
  • 17
  • 56
  • 74
0
votes
1 answer

Sql Ce performance for high volume transactions

I have a simple web app in ASP.NET MVC which uses Sql CE for the backend database, using EF. Everything works fine, except that I'd like to keep a log of impressions for users hitting an api in the app- I get enough requests that it crashes the…
Brady Moritz
  • 8,624
  • 8
  • 66
  • 100
0
votes
2 answers

SQL Server CE : multiple connections (2+ apps) to the same db (C#, WPF)

My C# WPF application using a SQL Server CE 4 database, everything works fine. But when I want to run multiple instances of that app, I have problem: I can't open more than 1 connection at the same time. As I understood SQL Server CE does allow…
VeryNoob
  • 1
  • 3
0
votes
1 answer

Use a manipulated date in an INSERT statement, in SQL Server Compact

I'm using SQL Server Compact. To get a date without the time, I do this: CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME); To insert a new record, where the date is the smallest from another table, I do this: INSERT INTO [Product] ([OrderDate],…
h bob
  • 3,610
  • 3
  • 35
  • 51
0
votes
2 answers

UPDATE table1 FROM table2 (using Sql Server Compact)

I want to update rows in the [To] table, from rows in the [From] table, where the keys are equal. So this is what I'd do: UPDATE [To] SET [To].[Name] = [From].[Name], [To].[Size] = [From].[Size], [To].[Something] =…
h bob
  • 3,610
  • 3
  • 35
  • 51
0
votes
1 answer

Complex SQL Server CE 4.0 SELECT query

UPDATE: Rewrote the question to be more clear (hopefully) I am using SQL Server CE 4.0 as a database. I have 3 tables for this query: Artikels: holds the data concerning a certain Artikel(product). Bestellingen: Holds the general information of an…
Migaroez
  • 35
  • 6
0
votes
1 answer

Large object (ntext and image) cannot be used in ORDER BY clauses

I wanted to change my code-first project to SQL Server Compact 4.0. But I have a problem with following LINQ expression db.Test.OrderBy(t => t.Name).ToList() It throws the following error Large object (ntext and image) cannot be used in ORDER BY…
Palmi
  • 2,381
  • 5
  • 28
  • 65
1 2 3
…
16 17