Can I rewrite this query to LINQ?
I have such query SELECT DISTINCT ON (c.””CmsId””) “”CmsId””, c.””Id””, c.””Title”” FROM “”Content”” AS c LEFT JOIN “”TagsContents”” AS tc ON c.””Id”” = tc.””ContentId”” LEFT JOIN “”Tags”” AS t ON tc.””TagId”” = t.””Id”” WHERE lower(c.””LanguageCode””) = @language AND (({GetTitleFilters(phraseWords)}) OR ({GetTagFilters(phraseWords)})) LIMIT @resultsPerPage OFFSET @offsetValue GetTitleFilters() and GetTagFilters() are returning where clauses as string based … Read more