Tuesday, October 16, 2007
In preparation for a class and sessions at Mobile Connections next month I've been working with a few of the things that I doin;t normally get the time to play, er ah work, with. One of those things is VS 2008 (Orcas), Mobile 6 and SQL Server 2005 CE.
The biggest problem that I've hit so far is that when you use the 3.5 NETCf namespace, your applicaiton expects a SQL CE 3.5 database. But the current SQL tools (Management Studio) create an 'older' versio of the database. Now, upgrading it in code is a simple thing to do but once you do, you can no longer use Management Studio 2005 to work with the database because now, it's a newer file format.
Now, this makes sense when you stop to think about it, but you might not think about it until it is too late.
The biggest problem that I've hit so far is that when you use the 3.5 NETCf namespace, your applicaiton expects a SQL CE 3.5 database. But the current SQL tools (Management Studio) create an 'older' versio of the database. Now, upgrading it in code is a simple thing to do but once you do, you can no longer use Management Studio 2005 to work with the database because now, it's a newer file format.
Now, this makes sense when you stop to think about it, but you might not think about it until it is too late.