Return rows from stored procedure

Posted by molgan on Stack Overflow See other posts from Stack Overflow or by molgan
Published on 2010-04-27T11:27:10Z Indexed on 2010/04/30 16:17 UTC
Read the original article Hit count: 208

Filed under:

Hello

I have this code:

public IEnumerable<SomeClass> GetAvalibleThingies(DateTime startDate, DateTime endDate, int categoryID)
    {


        if (_entities.Connection.State == System.Data.ConnectionState.Closed)
            _entities.Connection.Open();

        using (EntityCommand c = new EntityCommand("SomeEntities.GetAvalibleThingies", (EntityConnection)this._entities.Connection))
        {
            c.CommandType = System.Data.CommandType.StoredProcedure;

            EntityParameter paramstartDate = new EntityParameter("startDate", System.Data.DbType.DateTime);
            paramstartDate.Direction = System.Data.ParameterDirection.Input;
            paramstartDate.Value = startDate;
            c.Parameters.Add(paramstartDate);

    ........
            var x = c.ExecuteReader();

            return x as IEnumerable<SomeClass>;
        };

But I can't get it to return a list of SomeClass. What's needed to do here? I use the entity framework 3.5sp1 one

/M

© Stack Overflow or respective owner

Related posts about entity-framework