1

So I am using EF database first on an oracle db. I am getting the above error when I do this in my code:

contractType.CLIENT_TYPE != null && contractType.CLIENT_TYPE.ToUpper() == "POL"

That column is defined as VARCHAR2(10 BYTE) in Oracle and the .net type is string.

Did a lot of searching and no one really mentions this error in the context of .net. Hoping someone might have an idea.

g.t.w.d
  • 601
  • 1
  • 10
  • 30
  • Seems like you are filtering out a CLOB column without casting it as VARCHAR2. Can you describe your table. – Lalit Kumar B Apr 13 '15 at 15:58
  • It's a 10 column table. Nothing fancy honestly. I've been using EF database first against this database already with no issues. But for some reason when I try to check if Client_Type == "POL" it blows up. – g.t.w.d Apr 13 '15 at 17:56

1 Answers1

1

So I figured out a solution to this. I was using Odp.net version 11. Apparently this is a bug with certain linq statements using the where extension method. I upgraded to odp.net version 12 and it fixed the issue.

g.t.w.d
  • 601
  • 1
  • 10
  • 30