pauldeen79.QueryFramework.SqlServer
0.13.17
dotnet add package pauldeen79.QueryFramework.SqlServer --version 0.13.17
NuGet\Install-Package pauldeen79.QueryFramework.SqlServer -Version 0.13.17
<PackageReference Include="pauldeen79.QueryFramework.SqlServer" Version="0.13.17" />
<PackageVersion Include="pauldeen79.QueryFramework.SqlServer" Version="0.13.17" />
<PackageReference Include="pauldeen79.QueryFramework.SqlServer" />
paket add pauldeen79.QueryFramework.SqlServer --version 0.13.17
#r "nuget: pauldeen79.QueryFramework.SqlServer, 0.13.17"
#:package pauldeen79.QueryFramework.SqlServer@0.13.17
#addin nuget:?package=pauldeen79.QueryFramework.SqlServer&version=0.13.17
#tool nuget:?package=pauldeen79.QueryFramework.SqlServer&version=0.13.17
QueryFramework
Abstraction for executing SELECT queries on Sql Server, built on top of System.Data. (IDbConnection)
Fluent extensions to build queries.
Example using in-memory query provider:
var items = new[]
{
new MyClass { Property = "A" },
new MyClass { Property = "B" }
};
var sut = new QueryProvider<MyClass>(items);
var query = new SingleEntityQueryBuilder()
.Where(nameof(MyClass.Property)).IsEqualTo("B")
.Build();
var result = sut.Query(query);
// result only contains the second item because of the WHERE clause.
See unit tests for more examples.
Code generation
I am currently not storing generated files in the code repository. To generate, you have to trigger the code generation tool from either Visual Studio (hit F5) or a command prompt. This will replace all generated code.
Command to run code generation (example where you are in the root directory):
dotnet run --project ./src/QueryFramework.CodeGeneration\QueryFramework.CodeGeneration.csproj
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 9.0.3)
- pauldeen79.CrossCutting.Data.Core (>= 5.0.15)
- pauldeen79.CrossCutting.Data.Sql (>= 6.0.15)
- pauldeen79.QueryFramework.Abstractions (>= 0.13.17)
- pauldeen79.QueryFramework.Core (>= 0.13.17)
- System.Data.SqlClient (>= 4.9.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 0.13.17 | 207 | 3/16/2025 |
| 0.13.16 | 149 | 3/2/2025 |
| 0.13.15 | 180 | 2/18/2025 |
| 0.13.14 | 175 | 2/15/2025 |
| 0.13.13 | 166 | 12/28/2024 |
| 0.13.12 | 165 | 12/27/2024 |
| 0.13.11 | 171 | 12/18/2024 |
| 0.13.10 | 176 | 10/30/2024 |
| 0.13.9 | 212 | 10/18/2024 |
| 0.13.8 | 245 | 9/21/2024 |
| 0.13.7 | 180 | 9/13/2024 |
| 0.13.5 | 342 | 5/13/2024 |
| 0.13.4 | 195 | 5/5/2024 |
| 0.13.3 | 141 | 5/3/2024 |
| 0.13.2 | 153 | 5/3/2024 |
| 0.13.1 | 147 | 5/2/2024 |
| 0.13.0 | 191 | 4/24/2024 |
| 0.12.0 | 188 | 4/17/2024 |
| 0.11.0 | 208 | 3/24/2024 |
| 0.10.4 | 179 | 3/22/2024 |
| 0.10.3 | 190 | 3/20/2024 |
| 0.10.2 | 210 | 3/14/2024 |
| 0.10.1 | 214 | 3/9/2024 |
| 0.9.2 | 303 | 12/19/2023 |
| 0.9.1 | 218 | 11/24/2023 |
| 0.9.0 | 175 | 11/20/2023 |
| 0.8.0 | 203 | 9/13/2023 |
| 0.7.5 | 192 | 9/13/2023 |
| 0.7.4 | 254 | 5/28/2023 |
| 0.7.2 | 262 | 5/11/2023 |
| 0.7.1 | 252 | 5/10/2023 |
| 0.7.0 | 268 | 5/10/2023 |
| 0.6.21 | 526 | 8/24/2022 |
| 0.6.20 | 546 | 5/28/2022 |
| 0.6.19 | 567 | 5/26/2022 |
| 0.6.18 | 509 | 5/26/2022 |
| 0.6.17 | 570 | 4/20/2022 |
| 0.6.16 | 552 | 4/9/2022 |
| 0.6.15 | 540 | 4/1/2022 |
| 0.6.14 | 549 | 4/1/2022 |
| 0.6.13 | 570 | 3/13/2022 |
| 0.6.12 | 546 | 3/9/2022 |
| 0.6.11 | 547 | 3/9/2022 |
| 0.6.10 | 539 | 3/8/2022 |
| 0.6.9 | 561 | 3/6/2022 |
| 0.6.8 | 539 | 3/6/2022 |
| 0.6.7 | 536 | 3/6/2022 |
| 0.6.6 | 550 | 2/28/2022 |
| 0.6.5 | 535 | 2/28/2022 |
| 0.6.4 | 561 | 2/26/2022 |
| 0.6.3 | 545 | 2/23/2022 |
| 0.6.2 | 591 | 2/22/2022 |
| 0.6.1 | 550 | 2/8/2022 |
| 0.6.0 | 551 | 2/7/2022 |
| 0.5.20 | 570 | 2/5/2022 |
| 0.5.19 | 569 | 2/5/2022 |
| 0.5.18 | 593 | 2/4/2022 |
| 0.5.17 | 571 | 2/4/2022 |
| 0.5.16 | 420 | 1/2/2022 |
| 0.5.15 | 427 | 12/19/2021 |
| 0.5.14 | 428 | 12/18/2021 |
| 0.5.13 | 405 | 12/17/2021 |
| 0.5.12 | 413 | 12/16/2021 |
| 0.5.11 | 399 | 12/13/2021 |
| 0.5.10 | 423 | 12/10/2021 |
| 0.5.9 | 408 | 12/10/2021 |
| 0.5.8 | 387 | 12/10/2021 |
| 0.5.7 | 412 | 12/10/2021 |
| 0.5.6 | 610 | 12/9/2021 |
| 0.5.5 | 445 | 11/30/2021 |
| 0.5.4 | 397 | 11/28/2021 |
| 0.5.3 | 392 | 11/27/2021 |
| 0.5.2 | 1,645 | 11/26/2021 |
| 0.5.1 | 1,522 | 11/26/2021 |
| 0.5.0 | 1,532 | 11/26/2021 |
| 0.4.10 | 3,132 | 11/25/2021 |
| 0.4.9 | 3,275 | 11/24/2021 |
| 0.4.8 | 412 | 11/23/2021 |
| 0.4.7 | 394 | 11/23/2021 |
| 0.4.6 | 906 | 11/21/2021 |
| 0.4.5 | 1,159 | 11/20/2021 |
| 0.4.4 | 1,253 | 11/20/2021 |
| 0.4.3 | 901 | 11/19/2021 |
| 0.4.2 | 466 | 11/18/2021 |
| 0.4.1 | 407 | 11/18/2021 |
| 0.4.0 | 420 | 11/18/2021 |
| 0.3.0 | 397 | 11/14/2021 |
| 0.2.0 | 461 | 11/1/2021 |
| 0.1.2 | 468 | 10/23/2021 |
| 0.1.1 | 463 | 10/23/2021 |