I've been using MS SQL for years. Starting now to develop GIS application and it is required to do queries and store vectors created in OpenLayers in DB.
Assuming I'm developing over .Net, will the most convenient way to use a DB in GIS app be MS SQL 2008 or PostGIS?

I'm using the express edition of 2008 and will be using open source WMS , probably MS4W (or GeoServer).