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.

SQL Server queries case sensitivity

I have this database: abcDEF ABCdef abcdef if I write: select * from MyTbl where A='ABCdef' how to get: ABCdef …

sql sql-server sql-server-ce case-sensitive
Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider

In my project, I use SQL CE 3.5 database with entity framework and followed this article but i have this exception : …

c# entity-framework sql-server-ce
How to get current identity number of specific table in sql server compact

I want to get current identity value of a specific table Like IDENT_CURRENT('table') in sql server

sql sql-server-ce
Is Microsoft dropping support for SDF database files in Visual Studio?

In Visual Studio 2013 there is no longer an option to create .sdf SQL Server Compact databases in WebPages (WebMatrix) websites. …

database visual-studio sql-server-ce
SQL Server Compact 4.0 vs. SQLite

I'm interested in choosing an embedded DB engine for my WPF app. I would like information on how SQLite and …

sqlite sql-server-ce
How to deploy SQL Server Compact Edition 4.0?

How do i deploy Microsoft SQL Server Compact 4.0? SQL Server Compact Edition (currently at version 4.0) is: a free, embedded database …

sql-server-2008 deployment sql-server-ce ado xcopy
How can I manage SQL CE databases in SQL Server Management Studio?

I created a SDF (SQL CE) database with Visual Studio 2008 (Add / New Item / Local Database). Is it possible to edit …

sql-server-ce ssms
Correct way to close database connection in event of exception

Does the following code leave the connection open if there is an exception? I am using a Microsoft SQL compact …

c# .net sql-server-ce database-connection
Can't get sql server compact 3.5 / 4 to work with ASP .NET MVC 2

I'm using Visual Studio 2008 Pro. I'm probably missing something very obvious here, but I've been trying to get the CTP …

c# asp.net sql-server-2005 asp.net-mvc-2 sql-server-ce
How do I read the current path of |DataDirectory| from config settings

I'm writing a program that requires the user to select the active database at application startup. I have a Windows …

c# sql-server-ce datadirectory