Your second attempt doesn’t work because, based on the Books On-Line entry for UPDATE, SQL CE does’t allow a FROM clause in an update statement. I don’t have SQL Compact Edition to test it on, but this might work: UPDATE JOBMAKE SET WIP_STATUS = ’10sched1′ WHERE EXISTS (SELECT 1 FROM JOBVISIT AS JV WHERE JV.JBT_TYPE … Read more
It appears that SQL CE does not support any procedural extensions at all; only DDL and DML like from the 1970s. You will either have to put procedural logic in your application (C# or whatever) or go to an embeddable database with procedural extensions, like SQLite.
You can create .sdf files with SQL Server 2008 Management Studio. In the File > Connect Object Explorer dialog, change the Server Type dropdown to SQL Server Compact Edition. Then in the Database File dropdown choose New Database…. and you’re ready to go.
I’m not sure about encryption, but you’ll probably find this link helpful: http://msdn.microsoft.com/en-us/library/ms171955.aspx As for the rest of it: “Text” and “auto_increment” remind me of Access. SQL Server Compact is supposed to be upgrade compatible to the server editions of SQL Server, in that queries and tables used in your compact database should transfer to … Read more
Download and install LINQPad, it works for SQL Server, MySQL, SQLite and also SDF (SQL CE 4.0). Steps for open SDF Files: Click Add Connection Select Build data context automatically and Default (LINQ to SQL), then Next. Under Provider choose SQL CE 4.0. Under Database with Attach database file selected, choose Browse to select your … Read more
This can be solved confirming following 2 points: Check whether you already have System.Data.SqlServerCe namespace added to the References folder of your application. If its not there you may right click the References folder and select Add references option. From the popup window go to .Net tab and select System.Data.SqlServerCe from the list and click … Read more
I appreciate the effort that went into the existing answer, but I haven’t found it actually answering the question… so I tested this, and found out that [Column(TypeName = “ntext”)] public string Body { get; set; } (the one from System.ComponentModel.DataAnnotations) will work to create an ntext type column. (My problem with the accepted answer … Read more
I figured out how to do it, thanks to a blog post by Steve Lasker. Basically, here is what you have to do: (1) Set a reference to System.Data.SqlServerCe.dll in your project. Set the CopyLocal property to True. (2) In the App.config for your project, add the following XML markup. It tells EntityFramework to look … Read more
i’ve created the solution. SQL Server Compact Edition is comprised of 7 dlls: sqlceme40.dll The undocumented, native, flat API library (The .net System.Data.SqlServerCe.dll assembly is a wrapper around this dll) sqlceca40.dll A COM dll that implements Engine, Replication, Error and a few other COM objects sqlceoledb40.dll A COM dll that implements an OLEdb provider for … Read more
SQL CE 3.5 does not work with ASP.NET, you must use 4.0 CTP. Download from here. Install the runtime. Copy the following directory contents (including the x86 and amd64 folders) to the bin folder of your ASP.NET app: C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private UPDATE: Use System.Data.SqlServerCe.dll from the Desktop folder to avoid Medium Trust … Read more