blocks|key|1617623|text|试试ANTLR+--上面有一堆SQL语法。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1617624|entityMap|0|LINK|mutability|MUTABLE|url|http://antlr.org/^0|2|5|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Try <a href="http://antlr.org" rel="noreferrer">ANTLR</a> - There are a bunch of SQL grammars on there.

blocks|key|1402965|text|试试GOLD+Parser，它是一个强大且易于学习的BNF引擎。你可以搜索你想要的语法(例如：SQL+ANSI+89+Grammar)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1402966|我开始使用它进行HQL解析(+NHibernate查询语言，非常类似于SQL语言)，它非常棒。|1402967|更新:现在NH开发团队已经使用ANTLR+(更难使用，但更强大的AFAIK)完成了HQL解析。|1402968|entityMap|0|LINK|mutability|MUTABLE|url|http://goldparser.org/|1|http://goldparser.org/grammars/files/sql-ansi-89.zip^0|2|B|0|1B|J|1|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]|$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

Try <a href="http://goldparser.org/" rel="nofollow noreferrer">GOLD Parser</a>, it's a powerful and easy to learn BNF engine. You can search the grammars already made for what you want (ie: <a href="http://goldparser.org/grammars/files/sql-ansi-89.zip" rel="nofollow noreferrer">SQL ANSI 89 Grammar</a>).

I started using this for HQL parsing (the NHibernate query language, very similar to SQL), and it's awesome. 

UPDATE: Now the NH dev team has done the HQL parsing using ANTLR (which is harder to use, but more powerful AFAIK).

blocks|key|1403036|text|VSTS+2008数据库版GDR包括处理SQL分析和脚本生成的程序集，您可以从项目中引用这些程序集。数据库版使用解析器解析脚本文件以表示数据库的内存模型，然后使用脚本生成器从模型生成SQL脚本。我认为你只需要在你的项目中拥有和引用两个程序集。如果您没有数据库版本，您可以安装试用版来获取程序集，或者有另一种方法可以在不安装数据库版本的情况下获得它们。请查看以下链接。Data+Dude:Getting+to+the+Crown+Jewels+。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1403037|entityMap|0|LINK|mutability|MUTABLE|url|http://blogs.msdn.com/gertd/archive/2008/08/21/getting-to-the-crown-jewels.aspx^0|53|12|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

VSTS 2008 Database Edition GDR includes assemblies that handle SQL parsing and script generation that you can reference from your project. Database Edition uses the parser to parse the script files to represent in-memory model of your database and then uses the script generator to generate SQL scripts from the model. I think there are just two assemblies you need to have and reference in your project. If you don't have the database edition, you may install the trial version to get the assemblies or there might be another way to have them without installing the database edition. Check out the following link.
<a href="http://blogs.msdn.com/gertd/archive/2008/08/21/getting-to-the-crown-jewels.aspx" rel="nofollow noreferrer">Data Dude:Getting to the Crown Jewels </a>.

blocks|key|1617800|text|您可能会看到一个商业组件：http://www.sqlparser.com的通用sql解析器，它支持Oracle、T-SQL、DB2和MySQL的SQL语法。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1617801|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlparser.com/^0|D|O|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You may take a look at a commerical component: general sql parser at <a href="http://www.sqlparser.com" rel="noreferrer">http://www.sqlparser.com</a>
It supports SQL syntax of Oracle, T-SQL, DB2 and MySQL.

blocks|key|1617873|text|Scott+Hanselman最近对Irony+project进行了featured，其中包括一个示例SQL解析器。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1617874|entityMap|0|LINK|mutability|MUTABLE|url|http://irony.codeplex.com/|1|http://www.hanselman.com/blog/TheWeeklySourceCode59AnOpenSourceTreasureIronyNETLanguageImplementationKit.aspx^0|I|D|0|Y|8|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Scott Hanselman recently <a href="http://www.hanselman.com/blog/TheWeeklySourceCode59AnOpenSourceTreasureIronyNETLanguageImplementationKit.aspx" rel="noreferrer">featured</a> the <a href="http://irony.codeplex.com/" rel="noreferrer">Irony project</a> which includes a sample SQL parser.

I want to parse SQL code using C#.

Specifically, is there any freely available parser which can parse SQL code and generate a tree or any other structure out of it? It should also generate the proper tree for nested structures.

It should also return which kind of statement the node of this tree represents.

For example, if the node contains a loop condition then it should return that this is a "loop type" of a node.

Or is there any way by which I can parse the code in C# and generate a tree of the type I want?

Parsing SQL code in C#

数据库

MySQL

我想使用C#解析SQL代码。具体地说，有没有免费的解析器可以解析SQL代码并从中生成树或任何其他结构？它还应该为嵌套结构生成适当的树。它还应该返回此树的节点所代表的语句类型。例如，如果节点包含一个循环条件，那么它应该返回这是一个节点的“循环类型”。或者有没有什么方法可以解析C#中的代码并生成我想要的类型的树？

问在C#中解析SQL代码
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在C#中解析SQL代码EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在C#中解析SQL代码
EN