SQLce 4.0 support (in order to build a native 64 bit application)

• Question

• 

  

  1

  Sign in to vote

  Hi All,

  I am currently developing a WPF (dot net 4) desktop application using SQLce as the local data store and MSFx (v2.1) which allow the data updating between the local SQLce (SQLce 3.5 sp2) and the Centralized SQL server. Currently, we are trying to build the application as pure-64-bit due to the size of the memory (hence the occasional OOM exception)

  
  

  After reading couple of blog, i decided to upgrade to SQLce 4.0 since all prior versions which supports 64 bit, they are always on WOW.

  • http://social.technet.microsoft.com/wiki/contents/articles/clarifying-sync-framework-and-sql-server-compact-compatibility.aspx
  • http://msmvps.com/blogs/theproblemsolver/archive/2008/07/28/sql-compact-3-5-on-a-64-bit-windows.aspx
  • http://mtaulty.com/CommunityServer/blogs/mike_taultys_blog/archive/2007/05/21/9343.aspx

  
  

  however, from the following posts, 

  • http://social.technet.microsoft.com/wiki/contents/articles/clarifying-sync-framework-and-sql-server-compact-compatibility.aspx
  • http://social.microsoft.com/Forums/en-US/syncdevdiscussions/thread/7f2f9a3e-3568-4788-8f2c-d4eb28aab5fd

  
  

  MSfx has not yet supported SQLce 4.0, so my comments/questions

  1. When MSFx will provide SQLce 4.0 support? It worries me is in the second link, there had not yet any update since the original posting about 1 year ago)
  2. Before that, because of this chain of dependencies, is there any  other way allows my application to be built as pure 64 bit?

  Thanks,

  Tuesday, August 2, 2011 3:36 PM