On 3.8.2010 1:24, Vernon Cole wrote:
What are the consequences of using ExecuteReader() when there is nothing to read? If none, i.e. you get an empty set of results, then I would say to use that all the time, and don't bother to examine your SQL at all.
I think ExecuteReader should work for everything. I use only ExecuteReader in my private tool (but I do not use stored procedures).
You will have a bigger problem with ADO.NET than this. According to the Python dbapi specification, you can have as many cursors per connection as you want. You can have many cursors in ADO.NET too, but you can have only one SqlDataReader per connections which makes several cursors per connection useless.
-- -- Lukas
_______________________________________________ Users mailing list Users@lists.ironpython.com http://lists.ironpython.com/listinfo.cgi/users-ironpython.com