1. Introduction: What Are System CLR Types? The Microsoft System CLR Types package is a critical back-end component that provides the fundamental data types used by SQL Server 2012. Specifically, it implements the geography , geometry , and hierarchyid data types natively within the .NET Framework environment.
These types are not just for SQL Server itself; they are essential for client applications (e.g., reporting tools, GIS software, custom .NET apps) that need to consume, manipulate, or display spatial data (maps, coordinates, polygons) or hierarchical data (organizational charts, tree structures) without directly connecting to a SQL Server instance. it implements the geography