To alias the table you’d have to say: DELETE f FROM dbo.foods AS f WHERE f.name IN (…); …though I fail to see the point of aliasing for this specific statement, especially since (at least IIRC) this no longer conforms to strict ANSI, may cause unnecessary hurdles when writing for multiple platforms, and it introduces … Read more
You have to tell us exactly what connection string you are using, saying things like “I updated the connection to point to the database in the bin folder” is not helpful. Are you using a connection string like c:\Users\Me\Visual Studio 2010\Projects\MyProject\bin\debug\HKRMoviesDB.sdf? That is not right, that is hard-coded to your VS2010 debug test folder on … Read more
Relative path: ConnectionString = “Data Source=|DataDirectory|\Database.sdf”; Modifying DataDirectory as executable’s path: string executable = System.Reflection.Assembly.GetExecutingAssembly().Location; string path = (System.IO.Path.GetDirectoryName(executable)); AppDomain.CurrentDomain.SetData(“DataDirectory”, path);
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
Disclamer This is just some additional information that might help anyone. I want to make it abundantly clear that what I am describing here is possibly: A. not 100% correct and B. not safe in terms of network security. I am not a DBA, but every time I find myself setting up a SQL Server … 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
Yes, SQL Server Compact has been deprecated (see the comments on this Connect item). You should be using SQL Server Express or SQL LocalDB. Some posts: http://blogs.msdn.com/b/sqlexpress/archive/2011/07/12/introducing-localdb-a-better-sql-express.aspx http://blogs.msdn.com/b/jerrynixon/archive/2012/02/26/sql-express-v-localdb-v-sql-compact-edition.aspx http://erikej.blogspot.com/2011/01/comparison-of-sql-server-compact-4-and.html http://erikej.blogspot.com/2012/07/the-state-and-near-future-of-sql-server.html
It is a quite common problem. You use the |DataDirectory| substitution string. This means that, while debugging your app in the Visual Studio environment, the database used by your application is located in the subfolder BIN\DEBUG folder (or x86 variant) of your project. And this works well as you don’t have any kind of error … Read more