BULKCOPY is not supported in SQL CE. Here is the fastest way if you have a huge number of rows in your table; insert is too slow! using (SqlCeConnection cn = new SqlCeConnection(yourConnectionString)) { if (cn.State == ConnectionState.Closed) cn.Open(); using (SqlCeCommand cmd = new SqlCeCommand()) { cmd.Connection = cn; cmd.CommandText = “YourTableName”; cmd.CommandType = CommandType.TableDirect; … 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
|DataDirectory| does not come from config settings; you’re mixing up three different things: ConfigurationManager.AppSettings[“DataDirectory”] This comes from config settings; a .config file you have to create and put into your project. This particular setting is the value of the element with key “DataDirectory” in the AppSettings element. This doesn’t exist unless you put one in … 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
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);
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