How C # handles commonly used symbols, such as the greater than and less than numbers of XML files (program errors caused by XML symbols)

Source: Internet
Author: User

SQL statements that are configured in the program by XML to be converted to C # supported SQL statements

<settings>

<select> a.*</select>

<from>

(select top 1 (select COUNT (*) from Omsorder as a, left join Sysstate as B on (a.[state] = B.value and b.statetype= ' Statede Fault ') where a.[state] = 0 and DateDiff (day, ' 2016-03-25 ', A.[update]) &lt;= 0) as Added, (select COUNT (*) from Omsord Er as a left joins Sysstate as B on (a.[state] = B.value and b.statetype= ' Statedefault ') where a.[state] = 9 and DateDiff ( Day, ' 2016-03-25 ', A.[update]) &lt;= 0) as Passed, (select COUNT (*) from Omsorder as a left join Sysstate as B on (a.[st ATE] = B.value and b.statetype= ' Statedefault ') where a.[state] = 1 and DateDiff (day, ' 2016-03-25 ', A.[update]) &lt;= 0 ) as droped, a.* from Omsorder as a) a

</from>

<where></where>

<orderby> A.name desc</orderby>

</settings>

Originally here was written in greater than and less than sign

Error occurred while converting the program

When we need to pass xml format processing sql statement, often use < <=>,>= xml format error, which causes the background to xmlxml

Such problems often need us to deal with in IBatiS or in a custom XML-processing SQL program. In fact, it is very simple, we just need to replace the following to avoid the above error:

Explained in detail in the following path:

http://blog.csdn.net/hu_shengyang/article/details/8513655

How C # handles commonly used symbols, such as the greater than and less than numbers of XML files (program errors caused by XML symbols)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.