mysql - .NET MySql "Using"关闭数据读取器？

Question

我曾经使用 try/catch/finally block 关闭打开的数据读取器:

 Dim dr As MySqlDataReader = Nothing
 Try
   dr = DBConnection.callReadingStoredProcedure("my_sp")

 Catch ex As Exception
   ' the caller will handle this
   Throw ex
 Finally
   If dr IsNot Nothing Then dr.Close()
 End Try

但我认为使用“Using”VB 关键字应该更简洁(也更快):

Using dr As MySqlDataReader = DBConnection.callReadingStoredProcedure("my_sp")

End Using
'   dr is surely disposed, but is it closed? 

IDispose 接口(interface)(Using 需要)是否对 DataReader 执行关闭操作？

Answer 1

对象将被释放。是的，这将关闭 DataReader。