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

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)