你可以帮助我,如何在app.config文件中存储多行SQL查询?
下面是示例:-我想将此查询存储在App.config文件中。
select * from users u LEFT join Employee E on u.id = E.id
Inner Join Department D on d.id=E.id
Left Join Orders O On O.Id = E.id
Inner Join Values V v.id = E.id
WHERE
u.createTime>=Getdate()-1 AND u.deletstatus=1
AND D.Id<>0
发布于 2019-04-17 03:33:52
正如其他人所指出的,在XML中可以有一个多行字符串。也许您没有避开XML的特殊字符:
Ampersand & &
Less-than < <
Greater-than > >
Quotes " "
Apostrophe ' '
这是您的App.config的XML
<appSettings>
<add key="SqlQuery"
value="select * from users u LEFT join Employee E on u.id = E.id
Inner Join Department D on d.id=E.id
Left Join Orders O On O.Id = E.id
Inner Join Values V v.id = E.id
WHERE
u.createTime>=Getdate()-1 AND u.deletstatus=1
AND D.Id<>0" />
</appSettings>
https://stackoverflow.com/questions/38216794
复制相似问题