基于开源orm框架PetaPoco 实现Sql语句帮助器,不使用反射、lambda等,效率更高,使用更方便。通过表、列描述类,可以借用开发工具的提示完成Sql编写。详见http://www.cnblogs.com/guozhong111/p/7076556.html

helper.Build<ORG_USER.SqlAttr, ORG_DEPARTMENT.SqlAttr>((f, t, c) =>
            f.Select(t.ID, t.NAME, t.BIND_IP, t.DESCRIPTION, c.NAME.Alias("CNAME"), c.FAX, c.REMARK)
            .From(t.TableName).LeftJoin(c.TableName).On(c.ID == t.DEPT_ID)
            .Where((t.ID == "@0" | t.SORT_INDEX >= "5") & t.MOBILE % "@1", "200908281049324536039", "188%"));

Install-Package Rc.PetaPoco -Version
dotnet add package Rc.PetaPoco --version
<PackageReference Include="Rc.PetaPoco" Version="" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Rc.PetaPoco --version
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Version History

Version Downloads Last updated 476 6/24/2017