protected void CheckSql(string sql, string refSql)
{
StringBuilder str1 = new StringBuilder();
StringBuilder str2 = new StringBuilder();
foreach (char c in sql)
if (!Char.IsWhiteSpace(c))
str1.Append(c);
foreach (char c in refSql)
if (!Char.IsWhiteSpace(c))
str2.Append(c);
Assert.AreEqual(0, String.Compare(str1.ToString(), str2.ToString(), true));
}