Code: Select all
var filteredSites = sites.Where(o => o.Host.StartsWith("\")).ToList();
Code: Select all
SELECT
"Extent1"."Id" AS "Id",
"Extent1"."Name" AS "Name",
"Extent1"."Host" AS "Host",
FROM public."Sites" AS "Extent1"
WHERE "Extent1"."Host" LIKE '\%'
But this LINQ queries gives us exceptions:
Code: Select all
var filteredSites = sites.Where(o => o.Host.EndsWith("\")).ToList();
var filteredSites = sites.Where(o => o.Host == "\").ToList();
Can you solve this issue?unterminated quoted string at or near \"'%\\"
dotConnect for PostgreSQL version: 5.30.165.0