Returning results from stored procedure as IEnumerable

Question

i am not sure how to properly complete this - i have a stored proc and i want to return the results as an IEnumberable

  public IEnumerable GetGuids(int id)
    {
        SqlCommand _command = new SqlCommand("storedProc");
        _command.CommandType = CommandType.StoredProcedure;
        _command.Parameters.AddWithValue("@ItemID", id);

        return _command.ExecuteReader();
    }

when i run this i get: ExecuteReader: Connection property has not been initialized.

Answer 1

Your SqlCommand does not have a corresponding connection. Either use:

_command.Connection = conn;

or create the SqlCommand by using conn.CreateCommand(...)

Answer 2

Initialize the SqlCommand with the SqlConnection and be sure that the SqlConnection is open. After that ExecuteReader gives an SqlDataReader and you must read through the reader and read the values

SqlDataReader reader = _command.ExecuteReader();

while(reader.Read()
{
   // readvalue of reader["columname"] and insert into a list or yield return it.
}