Entity Framework 5 ntext equals error

Question

i have the following error when trying to find a record in database by ntext field using Entity Framework

enter code hereThe data types ntext and nvarchar are incompatible 
in the equal to operator.

I found a few articles here related to that issue but i can't modify database and change column type.

@CodeNotFound elementary `dbContext.Collection.FirstOrDefault(x=>x.Field = "value")` — Vladyslav Furdak, Apr 27 '16 at 11:27

score 0 · Accepted Answer · answered Apr 28 '16 at 10:19

0

I solve that problem using dbcontext.database.sqlquery with like operator to compare ntext rows with my value.

answered Apr 28 '16 at 10:19

Vladyslav Furdak

1 Answers1