I'm adding spatial data columns to tables I use in a llblgen project.

Compiling the datalayer code (LLBLGen Pro Runtime Framework, in 4.1 may 16th 2014) I'm getting the following error for all geography data type columns:

The type or namespace name 'Types' does not exist in the namespace 'Microsoft.SqlServer' (are you missing an assembly reference?)

The error refer to the following code in the XxxEntity.cs file:

... /// <summary> The Shape property of the Entity Country<br/><br/></summary> /// <remarks>Mapped on table field: "Country"."Shape"<br/> /// Table field type characteristics (type, precision, scale, length): Udt, 0, 0, 0<br/> /// Table field behavior characteristics (is nullable, is PK, is identity): true, false, false</remarks> public virtual Microsoft.SqlServer.Types.SqlGeography Shape { get { return (Microsoft.SqlServer.Types.SqlGeography)GetValue((int)CountryFieldIndex.Shape, true); } set { SetValue((int)CountryFieldIndex.Shape, value, true); } } ...

What assembly do I need to reference in my project?

You need Microsoft.SqlServer.Types.dll (ref...).

daelmo wrote:

You need Microsoft.SqlServer.Types.dll (ref...).

thanks.

I found the Microsoft.SqlServer.Types.dll had been installed during the sql 2012 installation into the directory C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.Types

That's the one. You can also pull it from nuget nowadays. You need to reference it in the projects where the types are used.