Blogspot - erikej.blogspot.com - Everything SQL Server Compact
General Information:
Latest News:
FAQ: Why is opening my SQL Server Compact database slow? 26 Aug 2013 | 08:41 pm
You may experience, that opening a connection to a SQL Server Compact database file using SqlCeConnection.Open() (or doing this via EntityFramework or LINQ to SQL) can be unexpectedly slow (up to 30 s...
SQL Server Compact Code Snippet of the Week #18 : handling SqlCeExceptions 19 Jul 2013 | 12:27 pm
Often I see developers complain that the error messages from SQL Server Compact does not provide any information about the error (in SqlCeEcxeption.Message). This is due to to way that the SqlCeExcept...
SQL Server Compact Toolbox 3.4–Visual Guide of new features 29 Jun 2013 | 02:28 pm
After nearly 190.000 downloads, version 3.4 of my SQL Server Compact Toolbox extension for Visual Studio 2013, 2012 and 2010 is now available for download. This blog post is a visual guide to the new ...
SQL Server Compact Code Snippet of the Week #17 : using wildcards with a parameterized query 23 Jun 2013 | 05:30 pm
This “week”’s code snippet simply demonstrates how to use a parameterized query with LIKE and a search string containing wildcards. The simple solution is basically to add the wildcard character (% or...
SQL Server Compact Code Snippet of the Week #16 : detect Entity Framework database type 19 Jun 2013 | 09:57 pm
This weeks code snippet is prompted by a StackOverflow question, regarding how to detect if the database that was backing an Entity Framework DbContext was SQL Server Compact. My proposed check simpl...
INSERTing many rows with Entity Framework 6 beta 1 and SQL Server Compact 4 Jun 2013 | 12:24 am
In this blog post I will demonstrate a couple of improvements for adding many entities to a Entity Framework based database. You can read more about the beta 1 release here, and Julie Lerman highlight...
INSERTing many rows with Entity Framework 6 beta 1 and SQL Server Compact 4 Jun 2013 | 12:24 am
In this blog post I will demonstrate a couple of improvements for adding many entities to a Entity Framework based database. You can read more about the beta 1 release here, and Julie Lerman highlight...
SQL Server Compact Code Snippet of the Week #15 : flush data to disk immediately 21 May 2013 | 10:09 pm
Under normal operation, SQL Server Compact keeps all pending disk writes in memory, and flushes them to disk at least every 10 seconds. The connection string property to control this is called “Flush ...
SQL Server Compact Code Snippet of the Week #15 : flush data to disk immediately 21 May 2013 | 10:09 pm
Under normal operation, SQL Server Compact keeps all pending disk writes in memory, and flushes them to disk at least every 10 seconds. The connection string property to control this is called “Flush ...
SQL Server Compact Code Snippet of the Week #14 : script all data in a table 9 May 2013 | 12:23 pm
Another entry in the scripting API samples, you will find an overview of getting started with the API here. This weeks entry demonstrates the general pattern for scripting smaller chunks of SQL based...
