pauldeen79.QueryFramework.SqlServer
0.13.5
dotnet add package pauldeen79.QueryFramework.SqlServer --version 0.13.5
NuGet\Install-Package pauldeen79.QueryFramework.SqlServer -Version 0.13.5
<PackageReference Include="pauldeen79.QueryFramework.SqlServer" Version="0.13.5" />
paket add pauldeen79.QueryFramework.SqlServer --version 0.13.5
#r "nuget: pauldeen79.QueryFramework.SqlServer, 0.13.5"
// Install pauldeen79.QueryFramework.SqlServer as a Cake Addin
#addin nuget:?package=pauldeen79.QueryFramework.SqlServer&version=0.13.5
// Install pauldeen79.QueryFramework.SqlServer as a Cake Tool
#tool nuget:?package=pauldeen79.QueryFramework.SqlServer&version=0.13.5
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. |
.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 (>= 8.0.1)
- pauldeen79.CrossCutting.Data.Core (>= 5.0.1)
- pauldeen79.CrossCutting.Data.Sql (>= 6.0.1)
- pauldeen79.QueryFramework.Abstractions (>= 0.13.5)
- pauldeen79.QueryFramework.Core (>= 0.13.5)
- System.Data.SqlClient (>= 4.8.6)
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.5 | 132 | 5/13/2024 |
0.13.4 | 88 | 5/5/2024 |
0.13.3 | 46 | 5/3/2024 |
0.13.2 | 48 | 5/3/2024 |
0.13.1 | 37 | 5/2/2024 |
0.13.0 | 90 | 4/24/2024 |
0.12.0 | 83 | 4/17/2024 |
0.11.0 | 98 | 3/24/2024 |
0.10.4 | 84 | 3/22/2024 |
0.10.3 | 89 | 3/20/2024 |
0.10.2 | 101 | 3/14/2024 |
0.10.1 | 106 | 3/9/2024 |
0.9.2 | 200 | 12/19/2023 |
0.9.1 | 152 | 11/24/2023 |
0.9.0 | 109 | 11/20/2023 |
0.8.0 | 128 | 9/13/2023 |
0.7.5 | 115 | 9/13/2023 |
0.7.4 | 150 | 5/28/2023 |
0.7.2 | 150 | 5/11/2023 |
0.7.1 | 133 | 5/10/2023 |
0.7.0 | 145 | 5/10/2023 |
0.6.21 | 407 | 8/24/2022 |
0.6.20 | 408 | 5/28/2022 |
0.6.19 | 412 | 5/26/2022 |
0.6.18 | 370 | 5/26/2022 |
0.6.17 | 428 | 4/20/2022 |
0.6.16 | 419 | 4/9/2022 |
0.6.15 | 412 | 4/1/2022 |
0.6.14 | 417 | 4/1/2022 |
0.6.13 | 429 | 3/13/2022 |
0.6.12 | 403 | 3/9/2022 |
0.6.11 | 399 | 3/9/2022 |
0.6.10 | 397 | 3/8/2022 |
0.6.9 | 418 | 3/6/2022 |
0.6.8 | 393 | 3/6/2022 |
0.6.7 | 409 | 3/6/2022 |
0.6.6 | 414 | 2/28/2022 |
0.6.5 | 408 | 2/28/2022 |
0.6.4 | 421 | 2/26/2022 |
0.6.3 | 408 | 2/23/2022 |
0.6.2 | 421 | 2/22/2022 |
0.6.1 | 402 | 2/8/2022 |
0.6.0 | 410 | 2/7/2022 |
0.5.20 | 428 | 2/5/2022 |
0.5.19 | 426 | 2/5/2022 |
0.5.18 | 451 | 2/4/2022 |
0.5.17 | 426 | 2/4/2022 |
0.5.16 | 290 | 1/2/2022 |
0.5.15 | 288 | 12/19/2021 |
0.5.14 | 259 | 12/18/2021 |
0.5.13 | 263 | 12/17/2021 |
0.5.12 | 268 | 12/16/2021 |
0.5.11 | 261 | 12/13/2021 |
0.5.10 | 284 | 12/10/2021 |
0.5.9 | 280 | 12/10/2021 |
0.5.8 | 246 | 12/10/2021 |
0.5.7 | 270 | 12/10/2021 |
0.5.6 | 467 | 12/9/2021 |
0.5.5 | 299 | 11/30/2021 |
0.5.4 | 255 | 11/28/2021 |
0.5.3 | 251 | 11/27/2021 |
0.5.2 | 1,501 | 11/26/2021 |
0.5.1 | 1,382 | 11/26/2021 |
0.5.0 | 1,398 | 11/26/2021 |
0.4.10 | 2,995 | 11/25/2021 |
0.4.9 | 3,135 | 11/24/2021 |
0.4.8 | 271 | 11/23/2021 |
0.4.7 | 253 | 11/23/2021 |
0.4.6 | 768 | 11/21/2021 |
0.4.5 | 1,019 | 11/20/2021 |
0.4.4 | 1,112 | 11/20/2021 |
0.4.3 | 759 | 11/19/2021 |
0.4.2 | 322 | 11/18/2021 |
0.4.1 | 259 | 11/18/2021 |
0.4.0 | 279 | 11/18/2021 |
0.3.0 | 254 | 11/14/2021 |
0.2.0 | 319 | 11/1/2021 |
0.1.2 | 325 | 10/23/2021 |
0.1.1 | 322 | 10/23/2021 |