Entity Framework ORA-00932: inconsistent datatypes: “'expected CLOB got CHAR”
If you want to execute the select on the client (i.e. loading ALL MyEntity's and filtering them on the client), you can do:
var result = db.MyEntity.ToList().AsQueryable().Select(getSelector()).ToList();
The first ToList() loads all entities from the DB. The AsQueryable() allows you to use the Expression function.
I hope this helps.
Cheers,Nicola
Instead of returning an object in the getselector() return an interface (after casting) or a concrete type. This should help entity framework in identifying the appropriate datatype.