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.

Entity Framewok Code First "ADO.NET provider not found" with local SQL Server CE DLL's

I am writing a C# application which uses SQL Server CE 4.0 files, which are accessed through the Entity Framework 6.0 via …

c# .net entity-framework ef-code-first sql-server-ce
SQL Compact Edition 3.5 - Access to the database file is not allowed

I developed an application (100% local, no access to servers) using SQL Server Compact 3.5, and it works fine on my computer. …

c# .net sql sql-server-ce
How to import data in SQL Compact Edition?

I don't seem to find a tool for it, nor an odbc driver. Thanks UPDATE : I'm aware of the sql …

sql-server import sql-server-ce
Increase the size of sql compact 3.5 .sdf file

I'm using Sql Compact3.5 as my DB with C# .NET what is the maximum size of sdf that I can …

c# sql-server-ce filesize
SQL Compact select top 1

While porting an application from SQL 2005 to SQL Server Compact Edition, I found that I need to port this command: …

sql-server sql-server-ce
Create SQLCE database programmatically

[EDITED - with answer] Following is my code to create SQL CE database programmatically: /* get the Path */ var directoryName = System.…

c# sql-server-ce
Select newly added Row - DataGridView and BindingSource

I'm adding a new Row to a BindingSource that is Bound to a DataGridView source.AddNew(); After this, use BindingSource …

c# winforms datagridview sql-server-ce bindingsource
Using SQL Server CE 4 on a remote host with MVC 3

I just upgraded my host to MVC 3 but I'm trying to do a "hello world" using SQLCE 4.0 but I just …

asp.net-mvc-3 sql-server-ce sql-server-ce-4
SQL Server CE 4.0 performance comparison

SQL Server CE 4 (SQL Server Compact Edition 4.0) is not news already (If it is, you could read this article) But …

sql-server performance sqlite sql-server-ce
How to use Stored Procedure in SqlCE

I have just installed Sql Server Compact Edition. To my surprise, we can't use stored procedure in sql server CE. …

sql-server sql-server-2005 stored-procedures sql-server-ce