After moving the database from one platform to other, the first SqlCeConnection.Open() takes more time

    If you move a SQLCE database from one platform to other, it’s first SqlCeConnection.Open() takes more time and also increases the database file size.   The Reason: For an index on string type columns, SQLCE uses LCMapString API to get the normalized sort key. LCMapString API behavior will be different for different NLS sort versions….

Sync Services optimizations

    There are some optimizations that can be done for an “Sync Services” sync scenario. These are, (might not be an exhaustive list) Small sync chunks (using smaller SyncGroups which are only absolutely necessary) Index creation on tracking and filtering columns Transfer encryption of data payload on web Batching the changes                  Filtering the data at various…

My First Entity Application Against SQLCE

Now that SQL Server Compact 3.5 SP1 Beta is released it’s time to take the first step, making your first entity application using SQLCE as a backend. In his previous post, Ambrish gave steps on how to install SQL Server Compact SP1 Beta, along with Ado.Net Entity Framework Beta 3 and writing a small program…


Download available for SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3

The SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3 is available for download at Microsoft Download Center. To install SQL Server Compact 3.5 SP1 Beta Release for ADO.NET Entity Framework Beta 3 Install ADO.NET Entity Framework Beta 3 from Microsoft Download Center. You must ensure that the pre-requisites specified on the…


SqlCeDataReader.GetSchemaTable – Sample

I have written a cute sample to show how different fields change with different constraints and indexes on a table.  If you are wondering how each of these flags IsUnique, IsKey, IsRowVersion change, have a quick look at sample application which is attached to this blog post. Thanks,  Vamshi Krishna B

Provider Independent Programming

  Have you heard of Provider Agnostic Programming aka Base Class Provider Model aka Provider Independent Programming? If not, read it out here: Well why am I writing about that article on this blog?  SQL Server Compact Edition supports this (rather adheres to these guidelines).  The invariant names for different releases/versions of SQL Server…