c# - 在 asp.net 中定义查询字符串

Question

此查询直接在 PostgreSQL 面板中运行，但是当我在代码中定义相同的查询时，查询字符串出现错误，如何在 asp.net 中以正确的方式定义

我的代码是:-

  string sQuery = "SELECT 'Inspection Completed' as "MCD Status" ,COUNT(*) as "Number of Count" FROM ud_document WHERE status = 'Inspection Completed' AND name_owning_agency like '%MZONE%' union 
  SELECT 'Pending' , COUNT(*) FROM ud_document WHERE status = 'Pending' AND name_owning_agency like '%MZONE%'
  union
  SELECT 'Approved' , COUNT(*) FROM ud_document WHERE status = 'Approved' AND name_owning_agency like '%MZONE%'
  union
  SELECT 'Rejected' , COUNT(*) FROM ud_document WHERE status = 'Rejected' AND name_owning_agency like '%MZONE%'";

Answer 1

我认为您对特殊字符转义有疑问。

string sQuery = "SELECT 'Inspection Completed' as \"MCD Status\" ,COUNT(*) as \"Number of Count\" FROM ud_document WHERE status = 'Inspection Completed' AND name_owning_agency like '%MZONE%' union 
  SELECT 'Pending' , COUNT(*) FROM ud_document WHERE status = 'Pending' AND name_owning_agency like '%MZONE%'
  union
  SELECT 'Approved' , COUNT(*) FROM ud_document WHERE status = 'Approved' AND name_owning_agency like '%MZONE%'
  union
  SELECT 'Rejected' , COUNT(*) FROM ud_document WHERE status = 'Rejected' AND name_owning_agency like '%MZONE%'";