>It makes perfect sense, the exact same query would work as expected (i.e. >you'd get three DataTables inside your DataSet) on SQL Server.
>It would only provide (noticeable) benefit if you're running Firebird in >server mode, though. Executing your query like that, rather than three >separate command would save you the round-trip to the database (which can be >in the order of a few milliseconds) As far as i understand the matter, if you keep you connection opened, and run three select queries, that would do the same thing as if the Provider have made it for you in this "BatchSelect". No difference at all. You can write your own class, that implements such behavior. But i would say, such behavior for Provider is not obvious, and is not something really important to be implemented - imho certainly :-) -- View this message in context: http://www.nabble.com/Batch-Select-with-Firebird-provider-tf2553213.html#a7129102 Sent from the firebird-net-provider mailing list archive at Nabble.com. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
