title: Closing SqlConnection without Closing SQL reader - can it cause connection Leak
body: <p>I have been using SQLDataReader for fetchig some data from a db. Once I used Reader with the the connection I am closing the connection only and not the Reader. Do we have any possibility of connection leak </p>
  
  <p>Here is the code that I am using</p>
  
  <pre><code> Public Sub Get_SomeData(ByVal sCon As String,ByRef ObjectToReturn As SomeClass)
          Dim sqlCon As SqlConnection = New SqlConnection(sCon)
          Dim sqlR As SqlDataReader = Nothing
          Dim sqlCmd As SqlCommand = New SqlCommand
          sqlCmd.CommandType = CommandType.StoredProcedure
          sqlCmd.Connection = sqlCon
          sqlCmd.CommandText = "get_SomeData"
          sqlCon.Open()
          sqlR = sqlCmd.ExecuteReader(CommandBehavior.CloseConnection)
          If sqlR.HasRows And sqlR.Read Then
              ObjectToReturn.Property1 = sqlR("Column1").ToString
              ObjectToReturn.Property1 = sqlR("Column1").ToString
              ObjectToReturn.Property1 = sqlR("Column1").ToString
              ObjectToReturn.Property1 = sqlR("Column1").ToString
          End If
          sqlCon.Close()
      End Sub
  </code></pre>