HQL Return DOUBLE Value in select NHIBERNATE

Question

I have this query, and it should return double (that is in database as Decimal(10,2)):

public products SearchPrice(string nmproduct)
        {
            string hql = "select x.custo from products x where x.nmproduct = ?";
            IQuery query = session.CreateQuery(hql);
            query.SetParameter(0, nmproduct);
            return query.UniqueResult<products>();
        }

I want to get the price in database.

The exception is:

Unable to cast object of type 'System.Decimal' to type 'Administrative.Models.products'.

score 0 · Accepted Answer · edited May 23 '17 at 10:27

0

You are casting a decimal value to your entity, you need to use:

query.UniqueResult<decimal>()

When you represent money, you need to use decimal instead double for not to lose accuracy, read here.

edited May 23 '17 at 10:27

Community

1
1

answered Jan 31 '16 at 18:57

Najera

2,869
3
28
52

Thank you, it solved the problem. Just needed to change to decimal. `public decimal SearchPrice(string nmproduct) { string hql = "select x.custo from products x where x.nmproduct = ?"; IQuery query = session.CreateQuery(hql); query.SetParameter(0, nmproduct); return query.UniqueResult(); }` – H. Eberhardt Jan 31 '16 at 20:33

HQL Return DOUBLE Value in select NHIBERNATE

1 Answers1