How to map XML column to string property in NHibernate in c#?
The property is defined as :
public virtual string Request { get; protected set; }
In mapping class I have:
Map(o => o.Request).Column("Request").Nullable();
I am getting following exception while selecting data from db:
the data types xml and nvarchar are incompatible in the equal to operator. nhibernate
I hope it has something to do with CustomType<> but dont know how. Please help.
One way to go is to use XDocument as a property type, and the convention, which will map any property to "NHibernate.Type.XDocType"
Complete solution is described here:
Where we add convention Conventions.Add<XmlTypeConvention>(); and define it as:
public class XmlTypeConvention : IUserTypeConvention
{
public void Accept(IAcceptanceCriteria<IPropertyInspector> criteria)
{
criteria.Expect(x => x.Type == typeof(XDocument));
}
public void Apply(IPropertyInstance instance)
{
instance.CustomType<NHibernate.Type.XDocType>();
}
}
This way we will work with NHibernate dedicated type for xml columns...
type="StringClob" does the job...