Did you know? DZone has great portals for Python, Cloud, NoSQL, and HTML5!
.NET Zone is brought to you in partnership with:

Erik Ejlskov Jensen is a .NET Data Developer, and SQL Server Compact MVP. He is also the author of a number of tools for SQL Server Compact. He has been working in IT for too many years, and enjoy blogging (http://erikej.blogspot.com) and tweeting (@ErikEJ) Data Development related news and tips. Erik Ejlskov is a DZone MVB and is not an employee of DZone and has posted 11 posts at DZone. You can read more from them at their website. View Full User Profile

SQL Server Compact 4.0 SP1 CTP1 now available

03.02.2012
Email
Views: 1364
  • submit to reddit
The .NET Zone is presented by JNBridge and VaraLogix to keep you updated on all the latest news, tips, and tools in the .NET community.  Check out today's top .NET content and read about JNBridge's innovative tools for .NET and Java interoperability and VaraLogix's deployment automation and CM utilities plus their best practices.

(Nice shot name!) SQL Server Compact 4.0 SP1 CTP1 is now available for download: http://www.microsoft.com/download/en/details.aspx?id=29037 – is is also installed with Visual Studio 11 Ultimate beta. Installing this .MSI will replace your current SQL Server Compact 4.0 binaries in Program Files, and change the version to 4.0.8854.1.

No blog post or KB article yet, I will update this post when they become available. In the meantime, I have skimmed though the code in the ADO.NET provider, which reveals the following changes (all is just guesses, and it is beta software, of course):

  • New connection string keyword: “File Access Retry Timeout” – will reattempt connection open from 0 – 30 seconds, with a default value of 0.
  • Improved local C++ runtime verification.
  • SqlCeConnection.GetSchema bug fixes
  • SqlCeParameter.Add(String parameterName, Object value) has been deprecated.  Use AddWithValue(String parameterName, Object value) instead.
References
Published at DZone with permission of Erik Ejlskov Jensen, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

This content was brought to you in partnership with JNBridge and VaraLogix JNBridge specializes in .NET and Java interoperability while VaraLogix empowers developers and IT operations with an all-in-one deployment and CM product.  Be sure to view JNBridge's brief video series on accessing Java from .NET and see VaraLogix's tips for taking the risk out of .NET deployment.

Comments

Ajya Chang replied on Sat, 2012/03/03 - 2:04am

Hello,

Thanks for information. This is a great news for mobile developers. Specially the new improvements looks quite promising. You can download it from http://www.microsoft.com/download/en/details.aspx?id=29037 .

Thanks once again for the inoformation. I will be waiting for more information on this from you.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.