Top "Sql-server-ce" questions

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

Create SQL Server CE database file programmatically

How can I create a new SQL Server Compact database file (.sdf) programmatically, without having an existing template file to …

c# .net sql-server database sql-server-ce
Entity Framework Code-First: How to manually update the database?

I've build a little WPF demo app which uses EF Code-First to save its data in a SQL CE 4.0 DB. …

.net c#-4.0 entity-framework-4.1 ef-code-first sql-server-ce
Using Entity Framework with an SQL Compact Private Installation

I am using Entity Framework 4 in a desktop application with SQL Compact. I want to use a private installation of …

entity-framework sql-server-ce entity-framework-4
How to convert DateTime of type DateTimeKind.Unspecified to DateTime.Kind.Utc in C# (.NET)

I've inherited C# code that has an awful lot of DateTimes where the Kind property is DateTimeKind.Unspecified. These are …

c# .net datetime sql-server-ce
Entity Framework 4 and SQL Compact 4: How to generate database?

I am developing an app with Entity Framework 4 and SQL Compact 4, using a Model First approach. I have created my …

entity-framework entity-framework-4 sql-server-ce
How can I upgrade my Sql Server CE 3.5 sdf database to Sql Server CE 4.0?

I need to update my SqlCE3.5 database to 4.0. I get the following error message when I'm trying to access my 3.5 …

visual-studio-2010 entity-framework-4 sql-server-ce sql-server-ce-4
Unable to load the native components of SQL Server Compact

I've installed SQL Server Compact Edition 4.0 on Win7 x64 and it runs both for Asp.Net and Desktop Applications. This …

asp.net sql-server-ce sql-server-ce-4
How to connect to SQL Server CE file using SSMS

I am using SSMS 2012 and trying to connect to the SDF created by Orchard. According to this answer, I should …

sql-server-ce ssms ssms-2012
How to use parameter with LIKE in Sql Server Compact Edition

I'm trying to parameterise a search query that uses the LIKE keyword with a wildcard. The original sql has dynamic …

c# .net sql-server sql-server-ce
Connection string for using SQL Server Compact with Entity Framework?

I'm done trying to Google for this. I have installed SQL Server CE 4.0, and have EF 4.1, but I can't get …

entity-framework-4 sql-server-ce