Passing null values to guid column in nhibernate c#

Question

I am stuck in problem and not getting correct way or solution that how can I handle this. The problem is that I am creating a criteria query in which we pass property id as a parameter. The type of property id is guid. When property id have values then it is working fine but when it is null then it crash.

I have requirement that when property id have value then filter records come according to property id and when property id is null then it filter records comes whose property id is null.

I had tried this links Nullable GUID

but it will give another exception which is type mismatch exception.

Here my NHibernate code which I am using

 var invoiceList =
     Session.CreateCriteria<tARInvoice>("inv")
            .Add(Restrictions.Eq("inv.fPropertyID",
                                 propertyId == null ?  (object)DBNull.Value : propertyId.Value))   
            .List<tARInvoice>()

I am using c# and NHibernate version 3.1.

When using above one then it gives following exception "Object reference not set to an instance of an object." — Awadhendra, Mar 06 '13 at 14:56
DBNull.Value should not be used like that. NHibernate handles regular nulls. What is the type of tARInvoce.fPropertyID? — Oskar Berggren, Mar 06 '13 at 15:23

score 0 · Answer 1 · answered Mar 13 '13 at 13:49

0

it should be as simple as

var invoiceList = Session.CreateCriteria<tARInvoice>()
    .Add(Restrictions.Eq("fPropertyID", propertyId)
    .List<tARInvoice>();

assuming fPropertyID is of type Guid? and mapped as simple property

answered Mar 13 '13 at 13:49

Firo

30,626
4
55
94

Passing null values to guid column in nhibernate c#

1 Answers1