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.

How can I determine whether a column exists in a SQL Server CE table with C#?

The legacy code does it this way: public bool isValidField(string tableName, string fieldName) { bool retVal; string tblQuery = string.Format("…

c# sql compact-framework sql-server-ce windows-ce
%APPDATA% in connection string is not substituted for the actual folder?

When using WPF and entity-framework I have an APP.CONFIG that looks like the following: <?xml version="1.0" encoding="utf-8"?&…

c# wpf entity-framework sql-server-ce
Create sql server compact file in appdata folder

I am developing a simple piece of software which uses Entity Framework code first and sql server compact 4. At the …

c# entity-framework-4.1 sql-server-ce
Cascade Delete Rule in EF 4.1 Code First when using Shared Primary Key Association

I implemented a bidirectional 1:1 relationship based on this answer: Primary /Foreign Key in Entity Framework I define the bidirectional relation …

ef-code-first sql-server-ce entity-framework-4.1 cascade cascading-deletes
DataAdapter.Fill too slow

I know DataAdapters have performance issues, but are there any ways around it that might be faster? At the moment, …

c# performance datagridview sql-server-ce dataadapter
Reset AutoNumber(Identity Field) in Database

I Use a Sql Server Compact Edition Database File For Store the Data in My Windows Application Software. In this …

sql-server-ce identity
The column name is not valid. [ Node name (if any) = t0,Column name = version ]

I am facing issue while trying to query SQLCE database in my Windows Phone Mango application. I get exception when …

c# linq-to-sql sql-server-ce windows-phone-7.1
AppDomain.CurrentDomain.GetData("DataDirectory") always returns Null

In my program, I need to copy a template database from the default location, which I understand will be different …

c# sql-server-ce datadirectory
How do I rename a table in SQL Server Compact Edition?

I've designed my SQL CE tables using the built-in designer in VS2008. I chose the wrong names for a couple. …

sql sql-server tsql sql-server-ce
How to specify the path to a file on a Windows CE device?

I copied over some code from a test app: const string sdfPath = @"C:\WebAPIClient\WebAPIClient\bin\Debug\DBPlatypusCompactDB.sdf"; string …

c# sql-server-ce windows-ce filepath windows-embedded-compact