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.

The limit of SQL CE 4.0

I'm planning to use SQL CE 4.0 in a small but production web site and I'd like to know how much …

sql-server-ce
Database functionality with WPF app: SQLite, SQL CE, other?

I want to extend a WPF application with database functionality. Which database engine would you suggest and why? SQLite, SQL …

wpf sqlite sql-server-ce
SQL Compact 4.0 can't open/read sdf file

I've installed SQL Compact 4.0 CTP 2 via WPI and used NUPack to add SQLCE.EntityFramework in my project. It compiles and …

visual-studio-2010 sql-server-ce
Create .mdf/.sdf database dynamically

How can I with "code" create a new .mdf/.sdf database? I've tried this: http://support.microsoft.com/kb/307283 All …

c# sql-server database sql-server-ce dynamically-generated
SDF file auto-created in Visual Studio projects?

I've recently been trying to save space on my machine and started using TreeSize to analyse folder structures / sizes This …

visual-studio visual-studio-2013 sql-server-ce
How can I programmatically determine if a table exists within a SQL Server CE database?

Back when I only had one table in my .sdf file, this code worked fine: const string sdfPath = @"\Program Files\…

c# sql-server-ce compact-framework windows-ce windows-embedded-compact
Why saving changes to a database fails?

I have following C# code in a console application. Whenever I debug the application and run the query1 (which inserts …

c# .net sql-server-ce
Determine if table exists in SQL Server CE?

I know this is similar to this question, but I'm using SQL Server CE 3.5 with a WinForms project in C#. …

c# sql sql-server sql-server-ce
How can I add a column to an existing table?

How can I alter a table in SQL Server Compact Edition (SQL CE)? I have an existing table, and I …

sql-server-ce
Store an image in a SQL Server CE database

Does any one know of an example on how to store an image in a SQL Server CE database? What …

c# windows-mobile compact-framework sql-server-ce linq-to-dataset