pauldeen79.CrossCutting.Data.Sql
6.0.5
See the version list below for details.
dotnet add package pauldeen79.CrossCutting.Data.Sql --version 6.0.5
NuGet\Install-Package pauldeen79.CrossCutting.Data.Sql -Version 6.0.5
<PackageReference Include="pauldeen79.CrossCutting.Data.Sql" Version="6.0.5" />
paket add pauldeen79.CrossCutting.Data.Sql --version 6.0.5
#r "nuget: pauldeen79.CrossCutting.Data.Sql, 6.0.5"
// Install pauldeen79.CrossCutting.Data.Sql as a Cake Addin #addin nuget:?package=pauldeen79.CrossCutting.Data.Sql&version=6.0.5 // Install pauldeen79.CrossCutting.Data.Sql as a Cake Tool #tool nuget:?package=pauldeen79.CrossCutting.Data.Sql&version=6.0.5
CrossCutting
Generic utilities and other stuff, usable in any layer of any solution. We're targeting .NET Standard 2.0, so you can even use .NET Framework 4.x if you want to.
This repository consists of the following packages:
Package name | Description |
---|---|
CrossCutting.Common | Provider for system date and user name, some useful extension methods on System.Object and System.String, and the Result class |
CrossCutting.Common.Testing | Helps you test constructors on null checks |
CrossCutting.Data.Abstractions | Abstraction for executing database commands using System.Data namespace (IDbConnection and IDbCommand) |
CrossCutting.Data.Core | Default implementation of database commands |
CrossCutting.Data.Sql | Extension methods for working with database commands in System.Data namespace (IDbConnection) |
CrossCutting.DataTableDumper | Produces flat-text data tables from objects |
CrossCutting.Utilities.ObjectDumper | Produces readable flat-text representation from objects, for use in logging |
CrossCutting.Utilities.Parsers | Parser for pipe-delmited data table strings, TSQL INSERT INTO statements, function strings, math expressions and formattable strings (dynamic interpolated strings) |
System.Data.Stub | Stubs for System.Data interfaces like IDbConnection, IDbCommand and IDataReader |
Using NSubstitute or Moq as mock factory for CrossCutting.Common.Testing
To use NSubstitute as a mock factory for the code in CrossCutting.Common.Testing, create a test helper project within your solution, and add the following code:
public static void ShouldThrowArgumentNullExceptionsInConstructorsOnNullArguments(
this Type type,
Func<ParameterInfo, bool>? parameterPredicate = null,
Func<ParameterInfo, object?>? parameterReplaceDelegate = null,
Func<ConstructorInfo, bool>? constructorPredicate = null)
=> ShouldThrowArgumentNullExceptionsInConstructorsOnNullArguments(
type,
t => t.CreateInstance(parameterType => Substitute.For(new[] { parameterType }, Array.Empty<object>()), parameterReplaceDelegate, constructorPredicate),
parameterPredicate,
parameterReplaceDelegate,
constructorPredicate);
You can easily replace NSubstitute with Moq, if you want, by changing the factory delegate argument to this:
t => t.CreateInstance(parameterType => ((Mock)Activator.CreateInstance(typeof(Mock<>).MakeGenericType(parameterType))).Object, parameterReplaceDelegate, constructorPredicate),
Upgrade from 2.x to 3.0
There has been a breaking change in the Result class, which lead to a new major version. To port the old code, you can fix most errors by replace this:
Result<([^>]+)>\.([^(]+)\(
With this:
Result.$2<$1>(
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.2)
- pauldeen79.CrossCutting.Common (>= 3.13.0)
- pauldeen79.CrossCutting.Data.Abstractions (>= 4.0.1)
- pauldeen79.CrossCutting.Data.Core (>= 5.0.5)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on pauldeen79.CrossCutting.Data.Sql:
Package | Downloads |
---|---|
pauldeen79.QueryFramework.SqlServer
Package Description |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
6.0.6 | 122 | 11/17/2024 |
6.0.5 | 144 | 10/29/2024 |
6.0.4 | 152 | 10/18/2024 |
6.0.3 | 194 | 9/21/2024 |
6.0.2 | 182 | 9/11/2024 |
6.0.1 | 367 | 5/9/2024 |
6.0.0 | 193 | 5/5/2024 |
5.1.1 | 162 | 5/3/2024 |
5.1.0 | 168 | 4/27/2024 |
5.0.0 | 195 | 4/24/2024 |
4.0.0 | 204 | 4/5/2024 |
3.7.0 | 251 | 3/22/2024 |
3.6.0 | 118 | 3/21/2024 |
3.5.0 | 196 | 3/15/2024 |
3.4.0 | 180 | 3/14/2024 |
3.3.0 | 475 | 11/24/2023 |
3.2.0 | 201 | 11/19/2023 |
3.0.0 | 155 | 10/21/2023 |
2.10.0 | 279 | 9/13/2023 |
2.9.0 | 171 | 9/9/2023 |
2.8.0 | 154 | 9/9/2023 |
2.7.59 | 152 | 9/8/2023 |
2.7.58 | 159 | 9/6/2023 |
2.7.57 | 165 | 8/31/2023 |
2.7.56 | 152 | 8/30/2023 |
2.7.55 | 338 | 5/15/2023 |
2.7.54 | 166 | 5/15/2023 |
2.7.53 | 415 | 5/8/2023 |
2.7.52 | 179 | 5/6/2023 |
2.7.51 | 168 | 5/5/2023 |
2.7.50 | 181 | 5/2/2023 |
2.7.49 | 170 | 5/2/2023 |
2.7.48 | 174 | 5/2/2023 |
2.7.47 | 167 | 5/2/2023 |
2.7.46 | 160 | 5/2/2023 |
2.7.45 | 159 | 5/2/2023 |
2.7.44 | 169 | 5/2/2023 |
2.7.43 | 178 | 5/2/2023 |
2.7.42 | 188 | 5/1/2023 |
2.7.41 | 188 | 5/1/2023 |
2.7.40 | 199 | 4/28/2023 |
2.7.39 | 188 | 4/27/2023 |
2.7.38 | 195 | 4/27/2023 |
2.7.37 | 213 | 4/26/2023 |
2.7.36 | 206 | 4/24/2023 |
2.7.35 | 260 | 4/22/2023 |
2.7.34 | 212 | 4/20/2023 |
2.7.33 | 228 | 4/17/2023 |
2.7.32 | 232 | 4/17/2023 |
2.7.31 | 212 | 4/16/2023 |
2.7.30 | 308 | 4/10/2023 |
2.7.29 | 221 | 4/10/2023 |
2.7.28 | 211 | 4/9/2023 |
2.7.27 | 214 | 4/9/2023 |
2.7.26 | 197 | 4/7/2023 |
2.7.25 | 397 | 10/14/2022 |
2.7.24 | 421 | 10/14/2022 |
2.7.23 | 406 | 9/20/2022 |
2.7.22 | 420 | 8/28/2022 |
2.7.21 | 427 | 8/26/2022 |
2.7.20 | 413 | 8/26/2022 |
2.7.19 | 435 | 8/24/2022 |
2.7.18 | 720 | 8/15/2022 |
2.7.17 | 455 | 7/1/2022 |
2.7.16 | 448 | 6/30/2022 |
2.7.15 | 431 | 6/29/2022 |
2.7.14 | 464 | 6/29/2022 |
2.7.13 | 477 | 6/26/2022 |
2.7.12 | 474 | 6/24/2022 |
2.7.11 | 442 | 6/24/2022 |
2.7.10 | 441 | 6/17/2022 |
2.7.9 | 455 | 6/16/2022 |
2.7.8 | 460 | 6/8/2022 |
2.7.7 | 723 | 5/27/2022 |
2.7.6 | 4,184 | 2/27/2022 |
2.7.5 | 729 | 2/24/2022 |
2.7.4 | 2,693 | 1/31/2022 |
2.7.3 | 481 | 12/22/2021 |
2.7.2 | 579 | 12/18/2021 |
2.7.1 | 433 | 12/17/2021 |
2.7.0 | 452 | 12/16/2021 |
2.6.2 | 1,131 | 12/9/2021 |
2.6.1 | 481 | 11/30/2021 |
2.6.0 | 441 | 11/28/2021 |
2.5.3 | 434 | 11/27/2021 |
2.5.2 | 2,306 | 11/26/2021 |
2.5.0 | 2,511 | 11/26/2021 |
2.4.2 | 3,260 | 11/25/2021 |
2.4.1 | 2,734 | 11/25/2021 |
2.4.0 | 658 | 11/23/2021 |
2.3.0 | 323 | 11/22/2021 |
2.2.5 | 1,513 | 11/20/2021 |
2.2.4 | 952 | 11/19/2021 |
2.2.3 | 503 | 11/18/2021 |
2.2.2 | 547 | 11/18/2021 |
2.2.1 | 375 | 11/17/2021 |
2.2.0 | 421 | 11/14/2021 |
2.1.1 | 414 | 11/7/2021 |
2.1.0 | 500 | 11/1/2021 |
2.0.3 | 381 | 10/31/2021 |
2.0.2 | 420 | 10/31/2021 |
2.0.1 | 417 | 10/31/2021 |
2.0.0 | 396 | 10/31/2021 |
1.2.1 | 458 | 10/30/2021 |
1.2.0 | 385 | 10/27/2021 |
1.1.0 | 664 | 9/17/2021 |
1.0.12 | 379 | 9/16/2021 |