Enabling CLR Integration

Hi All,

I'm new to SQL Server Express. But I need to find out how easy it is to create custom types with SQL Server Express because we have to represent house numbers as a custom type in the database. After enabling the CLR integration with the SQL Server Surface Area Configuration tool, I created an SQL Server Project with VS 2005 Pro., created a custom type called HouseNo, deployed it to a database and finally created a table with a column of that custom type. But when I tried to use the option 'Show Table Data' for that table, the following errors always appeared

SQL Execution Error

Executed SQL statement SELECT NP.ToString() AS NP From Table1
Error Source : .NET SqlClient Data Provider
Error Message : Execution of user code in the .NET Framework is disabled. Enable "CLR Enabled" configuration Option. -- I think I've already enabled it.

Does anyone know how to solve the problem? Just one more question, for a custom type implementing the IComparable interface, would SQL Server Express uses the CompareTo method to perform sorting?

Thanks!

Regards,
Nathan
----------------------------------------------------------------------------------------------
The SQL Server Epxress is newest and the following is code for the custom type.

---------------------------------------------------------------------------------------------
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

[Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedType(Format.UserDefined, IsByteOrdered = true, MaxByteSize = 8000)]
public class HouseNo : INullable, IComparable, IBinarySerialize
{
// Private member

private String number;
private String letter;
private bool m_Null;

public HouseNo()
{
Number = "0";
Letter = "0";
}

public HouseNo(String number, String letter)
{
Number = number;
Letter = letter;
}

public string Number
{
get { return number; }
set { number = value; }
}

public string Letter
{
get { return letter; }
set { letter = value; }
}

public int CompareTo(Object obj)
{
if (obj is HouseNo)
{
HouseNo hno = (HouseNo) obj;
int numCompare = Number.CompareTo(hno.Number);

return (numCompare == 0 ? Letter.CompareTo(hno.Letter) : numCompare);
}
else throw new Exception("Obj is not a HouseNo");

}

public override string ToString()
{
// Replace the following code with your code
return Number+Letter;
}

public bool IsNull
{
get
{
// Put your code here
return m_Null;
}
}

public static HouseNo Null
{
get
{
HouseNo h = new HouseNo();
h.m_Null = true;
return h;
}
}

public static HouseNo Parse(SqlString s)
{
if (s.IsNull)
return Null;
HouseNo u = new HouseNo();
// Put your code here
return u;
}


#region IBinarySerialize Members

public void Read(System.IO.BinaryReader r)
{
Number = r.ReadString();
Letter = r.ReadString();
}

public void Write(System.IO.BinaryWriter w)
{
w.Write(Number);
w.Write(Letter);
}

#endregion

}