基于开源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.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated 727 6/24/2017