MapGuide and SQL Server 2008

update dbo.NAN_PARCELS set GEOM.STSrid = 0;

//First we connect to the MapGuide server
string username = "Anonymous";
string password = "";
string layout = "Library://MyFeat/Layout/Layout.WebLayout";
String configPath = @"C:\Program Files\OSGeo\MapGuide\Web\www\webconfig.ini";

MapGuideApi.MgInitializeWebTier(configPath);

Uri host = new Uri("http://localhost/mapguide/mapagent/mapagent.fcgi");
conn = new HttpServerConnection(host, username, password, "en", true);

MgUserInformation userInfo = new MgUserInformation(conn.SessionID);
MgSiteConnection siteConnection = new MgSiteConnection();
siteConnection.Open(userInfo);

//Now I get the origanal layout that I created in the Maestro Application
//Get the original layout
WebLayout weblayout = conn.GetWebLayout(layout);

//Get the mapDefinition
MapDefinition mapDef = conn.GetMapDefinition(weblayout.Map.ResourceId);

//get the feature source
FeatureSource feaSource = conn.GetFeatureSource("Library://MyFeat/Data/SQL.FeatureSource");

//Generate a temporary feature source
string tempFeaDef = new ResourceIdentifier("SQL1", ResourceTypes.FeatureSource, conn.SessionID);

//Save the modified FeatureSource at its new temporary location
conn.SaveResourceAs(feaSource, tempFeaDef);

LayerDefinition layerFeatDefinition = conn.GetLayerDefinition("Library://MyFeat/Layer/Feat.LayerDefinition");
VectorLayerDefinitionType vectorLayerFeatDefinition = layerFeatDefinition.Item as VectorLayerDefinitionType;
vectorLayerFeatDefinition.ResourceId = tempFeaDef;
//Now we filter on the user name
vectorLayerFeatDefinition.Filter = "User_ID = '" + User.Identity.Name + "'";
//Save a copy of the layer, temporary
string tempLayerFeatDef = new ResourceIdentifier("MyFeatLayer", ResourceTypes.LayerDefiniton, conn.SessionID);
conn.SaveResourceAs(layerFeatDefinition, tempLayerFeatDef);

//Create a new MapLayer object
MapLayerType Featlayer = new MapLayerType();

//Absolute minimum properties
Featlayer.Visible = true;
Featlayer.ResourceId = tempLayerFeatDef;

//Extra properties
Featlayer.Selectable = true;
Featlayer.ExpandInLegend = true;
Featlayer.ShowInLegend = true;
Featlayer.LegendLabel = "Feats";
Featlayer.Name = "Feat";
//Now we add these layers to the Map
List<MapLayerType> maplayers = new List<MapLayerType>();

maplayers.Insert(0, layerLande);
maplayers.Insert(1, Featlayer);

mapDef.Layers = new MapLayerTypeCollection();
foreach (MapLayerType mlt in maplayers)
{
    mapDef.Layers.Add(mlt);
}

MgFeatureService featureService = (MgFeatureService)siteConnection.CreateService(MgServiceType.FeatureService);
MgResourceIdentifier resId = new MgResourceIdentifier("Library://MyFeat/Data/SQL.FeatureSource");
String schema = featureService.DescribeSchemaAsXml(resId, "");

OSGeo.MapGuide.MaestroAPI.LayerDefinition ldef = conn.GetLayerDefinition(tempLayerFeatDef);
Topology.Geometries.IEnvelope env = null;
//To show the correct extend filter again (Very Important)
env = ldef.GetSpatialExtent("User_ID = '" + User.Identity.Name + "'");
mapDef.Extents.MinX = env.MinX;
mapDef.Extents.MinY = env.MinY;
mapDef.Extents.MaxX = env.MaxX;
mapDef.Extents.MaxY = env.MaxY;

//create a temp map
string tempMapDef = new ResourceIdentifier("MyMap", ResourceTypes.MapDefinition, conn.SessionID);

//Save the modified map at its new temporary location
conn.SaveResourceAs(mapDef, tempMapDef);

//Generate a temporary WebLayout id
tempWebLayout = new ResourceIdentifier("MyMap", ResourceTypes.WebLayout, conn.SessionID);

//Update the WebLayout to point at the modified MapDefinition
weblayout.Map.ResourceId = tempMapDef;

//Save the modified layout at its new temporary location
conn.SaveResourceAs(weblayout, tempWebLayout);