Dapper.Aggregator
1.0.1
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package Dapper.Aggregator --version 1.0.1
NuGet\Install-Package Dapper.Aggregator -Version 1.0.1
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Dapper.Aggregator" Version="1.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Dapper.Aggregator --version 1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Dapper.Aggregator, 1.0.1"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Dapper.Aggregator as a Cake Addin #addin nuget:?package=Dapper.Aggregator&version=1.0.1 // Install Dapper.Aggregator as a Cake Tool #tool nuget:?package=Dapper.Aggregator&version=1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Criteria Pattern
var query = new Query<EventTable>();
query.Join<EventTable, EventDetailsTable>("EventTableID", "EventTableID");
query.Join<EventDetailsTable, CodeTable>(parent => parent.CodeTableID, child => child.CodeTableCD);
//build criteria
query.Filter = query.Eq(x => x.EventTableID, 0) |
query.NotEq(x => x.EventTableID, 1) &
query.Between(x => x.EventTime, DateTime.Now.AddYears(-10), DateTime.Now.AddYears(10)) &
query.In(x => x.EventTableID, 0, 10000) &
!query.Like(x => x.EventTitle, "AAAAA", LikeCriteria.Match.Start) |
query.LessThan(x => x.EventTableID, 100) &
query.IsNotNull(x => x.EventTableID) &
query.Expression(" EXISTS(SELECT 1 FROM EventDetailsTable WHERE EventTable.EventTableID = EventDetailsTable.EventTableID)");
query.GroupBy(x => x.EventTableID)
.GroupBy(x => x.EventTime)
.GroupBy(x => x.EventTitle)
.GroupBy(x => x.Lockversion);
query.Having = query.Eq(x => x.EventTableID, 3);
query.OrderBy(x => x.EventTableID)
.OrderByDesc(x => x.EventTitle);
var rows = sqlMapper.QueryWith(query);
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET Framework | net is compatible. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
- Dapper (>= 1.50.5)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.