- Name: VARCHAR2(50)
Value: CLOB
Code: Select all
var results = context.CreateQuery("SELECT VALUE m FROM Metadatas WHERE m.Value = 'Value1'").ToList();
However, the following query works:
Code: Select all
var results = context.Metadatas.Where(x => x.Value == "Value1").ToList();
Code: Select all
results = context.CreateQuery("SELECT VALUE m FROM Metadatas AS m WHERE m.Value = @v", new ObjectParameter("v", "Value1")).ToList();
Code: Select all
SELECT
"Extent1".ID AS ID,
"Extent1".NAME AS NAME,
"Extent1".VALUE AS VALUE
FROM METADATA "Extent1"
WHERE "Extent1".VALUE = 'Value1'
Code: Select all
SELECT
"Extent1".ID AS ID,
"Extent1".NAME AS NAME,
"Extent1".VALUE AS VALUE
FROM METADATA "Extent1"
WHERE "Extent1".VALUE LIKE TO_CLOB('Value1')
Code: Select all
SELECT
"Extent1".ID AS ID,
"Extent1".NAME AS NAME,
"Extent1".VALUE AS VALUE
FROM METADATA "Extent1"
WHERE "Extent1".VALUE LIKE :v
I am using Devart dotConnect for Oracle Professional 6.0.86.0.