Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » ADO.NET   (RSS)
Wednesday, April 01, 2009 1:16 PM

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
Posted by SQLCEBLOG | 0 Comments
Monday, October 06, 2008 1:40 PM

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
Posted by SQLCEBLOG | 0 Comments
Friday, March 07, 2008 4:36 PM

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
Posted by SQLCEBLOG | 8 Comments
Filed under:
Thursday, February 21, 2008 6:30 AM

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
Posted by SQLCEBLOG | 8 Comments
Filed under: ,
Wednesday, February 07, 2007 4:58 AM

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
Posted by SQLCEBLOG | 0 Comments
Filed under:

Attachment(s): SchemaSample.zip
Tuesday, January 23, 2007 6:23 PM

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?
Posted by SQLCEBLOG | 2 Comments
Filed under:
 
Page view tracker