Hands On Lab:  Using Spatial Data in Managed Code

• Posted: Jun 29, 2010 at 6:43 AM
• By: Roger Doherty
•  

Spatial data types are implemented using the CLR functionality in SQL Server. This approach hides the complexity of the spatial calculations by providing a couple of types on which there are methods that perform the calculations. This hands-on Lab shows how to use SQL Server Spatial types from managed code. More precisely, how to convert shapes drawn in a WPF Ink Pad to a SQLGeometry object and how to establish relations between these shapes by using spatial types methods such as STIntersect, STWithin, and  more.

Lesson Contents

1. Overview
2. Exercise 1: Drawing Spatial Data
3. Exercise 2: Finding ?Relationshi?ps Between Shapes
4. Exercise 3: Storing Spatial Data in the Database
5. Exercise 4: Querying Spatial Data
6. Summary
7. Appendix A: ?Understandi?ng the Well Known Binary (WKB) Format
8. Appendix B: ?Understandi?ng the Well Known Text (WKT) Format