C# (CSharp) SqlStrings.RemoveSqlPunctuation示例

示例#1

        public void TestRemoveSqlPunctuation1()
        {
            const string input    = "select * from [database].[schema].[table];";
            const string expected = "select * from  database   schema   table  ";

            Assert.AreEqual(expected, SqlStrings.RemoveSqlPunctuation(input));
        }

示例#2

文件： SqloogleTransform.cs 项目： Thomas89/SQLoogle

        private static string SqlTransform(object sql)
        {
            const string space = " ";
            var          clean = Strings.SplitTitleCase(SqlStrings.RemoveSqlPunctuation(sql), space).ToLower();

            return(sql.ToString().ToLower() + " " + string.Join(space, clean.Split(space.ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Distinct()));
        }