I am using CreateSQLQuery to retrieve some entities with complex
criteria created dynamic in my code and everything works fine with
entity retrieval. But I want at the same query to use a Batch of SQL
statements for counting the total records. Something similar to this
HQL Query :
IList results = s.CreateMultiQuery()
.Add("from Item i where i.Id > :id")
.Add("select count(*) from Item i where i.Id > :id")
.SetInt32("id", 50)
.List();
Isn't there a way to create something like CreateMultiSQLQuery or use
SQL queries in MultiQuery ? I am using NH 2.1 and SQL 2005.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
