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.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
