Get list of entity objects by generic T which is type of EntityObject

Question

I'm using EF 4 and I want to create generic method, which will allow me to load data from tables with only two columns - which I am sure exists in every table and entity. My problem is that I don't know how to get list of entities only knowing type of entity.

    Dictionary<long, string> GetList<T>() where T : System.Data.Objects.DataClasses.EntityObject
    {
        Dictionary<long, string> list = new Dictionary<long, string>();

        //var entityList = this.context.GetEntitiesByType(T);
        //
        foreach (var entity in entityList)
        {
            list.Add(typeof(T).GetProperty("Id").GetValue(entity, null),
                     typeof(T).GetProperty("Name").GetValue(entity, null))
        }
        return list;
    }

Is it possible to obtain this list ? As a workaround I could get table name by using method

    dbContext.GetTableName<T>();

and try to execute sql query, but it seems like bad idea. Any thoughts ?

var entityList = this.context.Set<T>()

Grax32
– Grax32

2014-08-07 14:20:46 +00:00
Commented Aug 7, 2014 at 14:20 — Grax32
– Grax32, Commented Aug 7, 2014 at 14:20
this method is unavailable in EF 4

Tomasz Gawlik
– Tomasz Gawlik

2014-08-08 05:17:16 +00:00
Commented Aug 8, 2014 at 5:17 — Tomasz Gawlik
– Tomasz Gawlik, Commented Aug 8, 2014 at 5:17

afnpires · Accepted Answer · 2014-08-08 12:49:14Z

1

You should use CreateObjectSet< T >() which returns a ObjectSet< T >.

Usage:

context.CreateObjectSet<T>()

For more information http://msdn.microsoft.com/en-us/library/dd382944(v=vs.100).aspx

answered Aug 8, 2014 at 12:49

afnpires

6091 gold badge8 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get list of entity objects by generic T which is type of EntityObject

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related