The new Microsoft SQL Server Compact Edition 3.5 in Visual Studio 2010 RC without Geometry Types.



With the goodies coming with Visual Studio 2010 a new type of SQL Database comes out to make it easier to deploy application and simplify the way to consume your data.

This is a huge improvement from Microsoft to improve hosting and deployment of your web applications that requires a database.

For years a database like that has been very needed, some file based that can be run with low trust on a web hosting environment, something better than SQL Express. Some other databases came out, like VistaDB. Something that can be deployed just by using an FTP client.

You only need to right click –> Add New Item and select SQL Server Compact Edition Database, a wizard will let you create a model as well for the database.

image

Issue: These version of SEL Server Compact Edition does not support Geometry types like SQL 2008 versions. After creating the database, I tried to add a geometry type and I could not find it on the dropdown.

image

I better note that I don’t know if in the geometry and geography types will be supported in release version of the SQL Server Compact Edition, seems difficult if the release candidate does not.

This is a huge problem for people that uses those kinds of types in their database to migrate. In my modest opinion new releases of SQL Server should always be backwards compatible.

Is LINQ to SQL Geometry fixed in Visual Studio 2010?

Seems like Microsoft if moving away from the Geometry and Geography types, I thought that .NET 4 will be supporting LINQ to SQL with Geometry and Geography types. However adding a SQL 2008 Database and creating a LINQ to SQL Class won’t be able to read the geometry type field on the database.

Cheers

Al

Published Tuesday, March 2, 2010 7:13 PM by albertpascual

Comments

# re: The new Microsoft SQL Server Compact Edition 3.5 in Visual Studio 2010 RC without Geometry Types.

Wednesday, March 3, 2010 11:11 AM by Mike

Your post confuses me somewhat. SQLCE 3.5 has been available for some time, so it's not exactly 'new'. Plus being an extremely cut down version of SQL Server, it was always going to have a vasty reduced set of features, so having Geometry types excluded shouldn't really be much of a surprise. Also remember that SQLCE databases are usable on Windows Mobile clients too, where keeping size down is very importany. Adding Geometry to SQLCE is IMO an unecessary requirement. If you so badly need Geometry, then use SQL Express.

# re: The new Microsoft SQL Server Compact Edition 3.5 in Visual Studio 2010 RC without Geometry Types.

Saturday, May 14, 2011 7:02 AM by weblogs.asp.net

The new microsoft sql server compact edition 3 5 in visual studio 2010 rc without geometry types.. He-he-he :)

# re: The new Microsoft SQL Server Compact Edition 3.5 in Visual Studio 2010 RC without Geometry Types.

Tuesday, June 28, 2011 2:49 PM by weblogs.asp.net

The new microsoft sql server compact edition 3 5 in visual studio 2010 rc without geometry types.. Outstanding :)

# re: The new Microsoft SQL Server Compact Edition 3.5 in Visual Studio 2010 RC without Geometry Types.

Wednesday, December 14, 2011 4:03 AM by Hessy

Me dull. You smart. That's just what I neeedd.

# re: The new Microsoft SQL Server Compact Edition 3.5 in Visual Studio 2010 RC without Geometry Types.

Thursday, December 15, 2011 10:56 PM by Kayli

HHIS I should have tohguht of that!