使用 C# 进行查询验证

问题描述

我正在寻找 C# 中的查询验证器，它允许我从文本框中解析 SQL 文本并在发送它执行(MS SQL 或 DB2 查询)之前验证它是否正确.

I am looking for a query validator in C#, which allows me to parse the SQL text from a textbox and verify whether it's correct or not before sending it for execution (MS SQL or DB2 queries).

推荐答案

如果你想在不使用数据库的情况下验证 SQL 语法，TSql100Parser 类将适用于这种情况.

If you want to validate SQL syntax without the use of a database, the TSql100Parser class will do well for this situation.

免责声明，此处借用此帖子的代码验证SQL脚本的代码

Disclaimer, code borrowed from this post here Code to validate SQL Scripts

虽然使用起来非常简单.如果返回null，则解析没有错误.

Pretty straightforward to use though. If it returns null, then there were no errors in parsing it.

using Microsoft.Data.Schema.ScriptDom;
using Microsoft.Data.Schema.ScriptDom.Sql;

public class SqlParser
{
        public List<string> Parse(string sql)
        {
            TSql100Parser parser = new TSql100Parser(false);
            IScriptFragment fragment;
            IList<ParseError> errors;
            fragment = parser.Parse(new StringReader(sql), out errors);
            if (errors != null && errors.Count > 0)
            {
                List<string> errorList = new List<string>();
                foreach (var error in errors)
                {
                    errorList.Add(error.Message);
                }
                return errorList;
            }
            return null;
        }
}

这篇关于使用 C# 进行查询验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！