LinqToSQL - Cast IQueryable object at runtime?

Question

Given this:

var query = context.GetTable<T>();

Where "T" is a generic entity passed into the method,

I'd like to do something like this:

if(typeof(TEntity) is IEntitySoftDeletable)
  query = query.Cast<IEntitySoftDeletable>.Where(ent => !ent.IsDeleted);
}

Is this possible?

Currently it's telling me that I can't cast this way.

I realize that I could force parameter "T" to be an IEntitySoftDeletable at the class or method level, but I'm trying to avoid that and provide more flexibility from the same method.

Answer 1

You can test for an interface using

obj.GetType().GetInterface("IEntitySoftDelete") == null

I think that should work for what you need... just make sure to add a using for System.Reflection.

Answer 2

Not sure I complete understand what you want but would this work?

query.OfType<IEntitySoftDeletable>().Where(ent => !ent.IsDeleted); //OfType will only give the ones that are IEntitySoftDelteable