Entity Framework ORA-00932: inconsistent datatypes: “'expected CLOB got CHAR” Entity Framework ORA-00932: inconsistent datatypes: “'expected CLOB got CHAR” oracle oracle

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.