.SetString("fn", employeeId.ToString()) ??mmm that smell wrong
this smell better
.SetInt32("fn", employeeId)
2009/8/28 YJingLee <[email protected]>
>
> int64 count = (int64)session.CreateQuery("select count(*) from
> Employees where EmployeeID = :fn")
> .SetString("fn", employeeId.ToString())
> .UniqueResult();
>
>
>
> On Aug 28, 7:54 pm, İlgiz Seber <[email protected]> wrote:
> > Hi,
> >
> > I found a trick about casting Count() to int result on this link:
> http://nhforge.org/doc/nh/en/index.html#queryhql-tipstricks
> >
> > Then i wrote a HQL like this:
> >
> > public int HQL_GetCustomerCount(int employeeId)
> > {
> > int count = (int)session.CreateQuery("select count(*) from
> > Employees where EmployeeID = :fn")
> > .SetString("fn", employeeId.ToString())
> > .UniqueResult();
> >
> > return count;
> > }
> >
> > And also i wrote a test fot it too:
> >
> > [Test]
> > public void HQL_CanGetCustomerCount()
> > {
> > int count = dataProvider.HQL_GetCustomerCount(1);
> >
> > Assert.AreEqual(1, count);
> > }
> >
> > Then i run my test expecting to cast count() result to int according
> > to the trick, i got this exception:
> >
> > "NHibernateDataProviderTest.HQL_CanGetCustomerCount : Failed
> >
> > NHibernate: select count(*) as col_0_0_ from Employees employees0_
> > where employees0_.employee...@p0;@p0 = '1'
> >
> > System.InvalidCastException: Specified cast is not valid."
> >
> > Is it a bug or am i making a terrible mistake?
> >
> > NOTE: I am using NHibernate 2.1.0.4000 version. And working on
> > Northwind db.
> >
> > Thanks to everyone.
> >
>
--
Fabio Maulo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
