SqlHierarchyId insert

[Mycroft Holmes]

What is the syntax for using a sQLParameter to insert a SqlHierarchyId. I'm stuck with the datatype to apply to the parameter object as I can't seem to get anything to support the SqlHierarchyId type. And my google mojo has completely let me down.

			List lParams = new List();
			SqlParameter oParam = new SqlParameter();
			oParam.ParameterName = "@NodeKey";
			oParam.Value = this.NodeKey;
			oParam.SqlValue = this.NodeKey;
			oParam.DbType = SqlHierarchyId;

[Mycroft Holmes]

By using a varchar datatype for the insert parameter. It seems there is an implicit conversion from varchar to hierarchyid in SQL Server 2008

			oParam = new SqlParameter();
			oParam.ParameterName = "@NodeKey";
			oParam.DbType.Equals(SqlDbType.VarChar);
			oParam.Value = this.NodeKey.ToString();
			oCmd.Parameters.Add(oParam);