[nhibernate-issues] [JIRA] Created: (NH-827) Add a way to issue several queries in one round-trip

[NHibernate J. <mik...@us...>]

Add a way to issue several queries in one round-trip
----------------------------------------------------

         Key: NH-827
         URL: http://jira.nhibernate.org/browse/NH-827
     Project: NHibernate
        Type: New Feature
  Components: Core  
    Versions: 1.2.0.Beta2    
    Reporter: Ayende Rahien
 Assigned to: Ayende Rahien 


This feature is aimed at being able to issue several (read) queries in a single round-trip.
In SQL it is;
Select * from Employess;
SELECT count(*) From Employess
etc...

NHibernate should have a method like;

IList results = session.ExecuteQueries(getAllEmployeesPaged, getCountOfEmployees);
employees = results[0];
int count = (int)results[1][0];

I think that this is something cross-database, but it has probably different semantics, so it will also need a way for the driver to say it is supported, and a way to merge the queries together.
Maybe also a way to check if this is valid (over 2100 params in SQL Server, for instnace) although the DB will do that.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira