Marc Schweigert shows you how to draw a polygon on a Virtual Earth map and save it using ASP.NET AJAX, Windows Communication Foundation (WCF), LINQ to SQL, and the new geography data type in SQL Server 2008. To download the source code visit: http://blogs.msdn.com/devkeydet/archive/2008/07/18/screencast-saving-virtual-earth-polygons-to-sql-server-2008.aspx

Marc Schweigert builds off of the concepts shown in his previous screencast and shows you how to render a polygon on a Virtual Earth map using REST, Windows Communication Foundation (WCF), LINQ to SQL, and the new geography data type in SQL Server 2008. To learn more about the GeoRSS utility library, visit: http://blogs.msdn.com/eugeniop/archive/2008/07/01/simple-georss-utility-library-released.aspx A big thanks to Eugenio Pace for letting me use it as part of my sample! To download the source code

In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target object based on the results of that join.

In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. The MERGE statement allows you to join a data source with a target table or view, and then perform multiple actions against the target object based on the results of that join.