Generic Queries with Entity Framework

Question

I have a Entity model that includes a large number of lookup entities. All have just ID and Name properties.

I do not want to build large number of DAL classes to simply have something like:

IList<Lookup1> lookup1List= ctx.Lookup1.ToList();

and another class (Or method) with

IList<Lookup2> lookup2List= ctx.Lookup2.ToList();

and another with

IList<Lookup3> lookup3List= ctx.Lookup3.ToList();

I want to have one generic way to query all them using an interface they all Implement. Something like

IList<ILookupEntity> list = "SomeMethod"(Type lookupType);

How can I do that?

Rubens Farias · Accepted Answer · 2010-09-04 13:20:54Z

5

What about this?

public class Repository<T> where T : EntityObject, new()
{
    public static IQueryable<T> List()
    {
        return EntityContext.Current.CreateObjectSet<T>();
    }
}

Usage:

var lookups = Repository<Lookup1>.List();

answered Sep 4, 2010 at 13:20

Rubens Farias

58k8 gold badges136 silver badges165 bronze badges

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

1 Comment

Emad Gabriel Over a year ago

Is there a way to make this work With Self tracking Entities (who do not inherit from EntityObject) ?

user438034 · Accepted Answer · 2010-09-04 14:16:25Z

1

So you want to query all objects that implement a specific interface? I don't think that's possible, currently.

answered Sep 4, 2010 at 14:16

user438034

Collectives™ on Stack Overflow

Generic Queries with Entity Framework

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related