Generics in DBContext using Entity Framework

Question

I have an interface IMstTuver which is implemented by the MstTuver class. IMstTuver contains MaxVersion and Agenttype parameters.

public class GetTable<T> where T : IMstTuver
{
    public IMstTuver GetEntities(DbContext context, string agenttype) 
    {
        long maxVersion = context.Set<T>().Max(x => x.MaxVersion);
        IMstTuver mstTuver = context.Set<T>()
                                    .Where(x => x.MaxVersion == maxVersion && 
                                                x.AgentType == agenttype)
                                    .FirstOrDefault();
        return mstTuver;
    }
}

In my class:

table.GetEntities(MyDbContext, "MSMA") as MstTuver;

I am getting an error

The type 'T' must be a reference type in order to use it as parameter 'TEntity' in the generic type or method 'System.Data.Entity.DbSet'

Please help.

score 4 · Answer 1 · answered Apr 22 '16 at 10:20

Set<T> has a generic constraint that T must be a reference type, which means that your class needs to have one too. The fix is to apply the following modification to all generic classes and/or methods up the call chain:

public class GetTable<T> where T : class, IMstTuver

score 1 · Answer 2 · answered Apr 22 '16 at 10:19

1

You can declare T as a reference type by adding the class type-constraint to your method:

public class GetTable<T> where T : class, IMstTuver
{
    //...

answered Apr 22 '16 at 10:19

spender

117,338
33
229
351

Igor · Answer 3 · 2016-04-22T10:42:44.177

I have done something like this in the past and found it easier to put the generic and constraint on the methods than the type. This will allow the same repository type to serve multiple entity types (as long as they meet the constraints).

Example:

public class GetTable
{
    public T GetEntities<T>(DbContext context, string agenttype)where T : class, IMstTuver
    {
        long maxVersion = context.Set<T>().Max(x => x.MaxVersion);
        IMstTuver mstTuver = context.Set<T>().Where(x => x.MaxVersion == maxVersion && x.AgentType == agenttype).FirstOrDefault();
        return mstTuver;
    }
}

In the future when you are returning a generic as a generic from an existing library you can check the constraints on the method you are calling and implement those same constraints. In this case the Set<T> method is constrained to class. You can then add additional non conflicting constraints as you see fit.

DbContext.Set Method

public virtual DbSet<TEntity> Set<TEntity>() where TEntity : class

At first, this is not his problem, and second this will also result in his error ;D — Frerk Morrin, Apr 22 '16 at 10:23

Generics in DBContext using Entity Framework

3 Answers3