路合并/标记化SQL命令 [英] Way to coalesce/tokenize a SQL Command

问题描述

我想打破一个SELECTSQL语句转换成它的逻辑组件。即我想创建一个像SelectSqlStatement其中有一个名为表的属性，去哪儿，排序依据，等等。我想这样做的原因是对象是我不想操纵一个字符串，但而操作对象，并将其返回一个字符串序列化。

I would like to break a "SELECT" SQL statement into its logical components. i.e. I would like to create an object like "SelectSqlStatement" which has a property called "Table", "Where", "OrderBy", etc. The reason I want to do it is that I don't want to manipulate a string but rather manipulate an object and serialize it back to a string.

在我写的一个用于.NET，我在想，如果有一个可用。我做了搜索，但没有看到任何东西。

Before I write one for .NET, I was wondering if there was one available. I did a search but didn't see anything.

推荐答案

• LINQ
• <一个href="http://blogs.msdn.com/b/vbteam/archive/2009/06/18/vb-entity-framework-samples-now-available-lisa-feigenbaum.aspx"相对=nofollow>实体框架
• NHibernate的
  • NHibernate的作为.NET 2.0的解决方案ORM
  • LINQ
  • Entity Framework
  • nHibernate
    • nHibernate as the solution for .NET 2.0 ORM

    仅举几例。你正在寻找的是一个 ORM

    Just to name a few. What you are looking for is an ORM

    *所有的链接都是我能很快找到了VB。

    *All links are what I could quickly find for VB.

    这篇关于路合并/标记化SQL命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！