Microsoft's Embedded Database - SQL Server Compact - Team Blog

SQL Server Compact is a SKU of SQL Server family of products from Microsoft. This is a thin light-weight, embedded, in-proc database engine which supports synchronization to SQL Server, etc.

Browse by Tags

Tagged Content List
  • Blog Post: 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 : F or an index on string type columns, SQLCE uses LCMapString API to get the normalized sort key. LCMapString API behavior will be different...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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: http://msdn2.microsoft.com/en-us/library/t9f29wbk.aspx Well why am I writing about that article on this blog? SQL Server Compact Edition supports this...
Page 1 of 1 (6 items)