Returning a SqlDataReader

by

The problem is that leaving the function (via the return statement) kicks you out of the using blocks, and so the SqlDataReader and SqlConnections you are using are disposed. To get around the problem, try changing the function signature like this:

public static IEnumerable<IDataRecord> GetGeneralInformation ( int RecID )

and then update the middle of the function like this:

using ( var reader = cmd.ExecuteReader() )
{
    while ( reader.Read() )
    {
        yield return reader;
    }
}

For the final “How do I read from it?” part, it might look like this:

int RecID = 12345;
string result = GetGeneralInformation(RecID).First()["Status"].ToString();

More Related Contents:

  1. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  2. Get the generated SQL statement from a SqlCommand object?
  3. Get connection string from App.config
  4. SQLite Database Locked exception
  5. Can you get the column names from a SqlDataReader?
  6. Is it necessary to manually close and dispose of SqlDataReader?
  7. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  8. How to create a DataTable in C# and how to add rows?
  9. Exception when AddWithValue parameter is NULL
  10. Handling ExecuteScalar() when no results are returned
  11. Use of SqlParameter in SQL LIKE clause not working
  12. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  13. ado.net Closing Connection when using “using” statement
  14. How can I retrieve a list of parameters from a stored procedure in SQL Server
  15. Thread safety for DataTable
  16. How to keep single SQL Server connection instance open for multiple request in C#?
  17. DataTable equivalent in Java [duplicate]
  18. What’s better: DataSet or DataReader?
  19. Using SqlDataAdapter to insert a row
  20. How do I re-write a SQL query as a parameterized query?
  21. How do I create a DataTable, then add rows to it?
  22. Add WHERE clauses to SQL dynamically / programmatically
  23. Check if a SQL table exists
  24. Unable to find the requested .Net Framework Data Provider – SQLite
  25. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  26. How do I extract data from a DataTable?
  27. Reading a date using DataReader
  28. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  29. How to know actual problem because of which SqlException is thrown?
  30. How to give ADO.NET Parameters

Leave a Comment