PyunSoft.AdoExtensions
1.1.0
dotnet add package PyunSoft.AdoExtensions --version 1.1.0
NuGet\Install-Package PyunSoft.AdoExtensions -Version 1.1.0
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="PyunSoft.AdoExtensions" Version="1.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="PyunSoft.AdoExtensions" Version="1.1.0" />
<PackageReference Include="PyunSoft.AdoExtensions" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add PyunSoft.AdoExtensions --version 1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: PyunSoft.AdoExtensions, 1.1.0"
#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.
#:package PyunSoft.AdoExtensions@1.1.0
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=PyunSoft.AdoExtensions&version=1.1.0
#tool nuget:?package=PyunSoft.AdoExtensions&version=1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
PyunSoft.AdoExtensions
PyunSoft.AdoExtensions is a Nuget package library that adds a small set of data-retrieval extension methods to System.Data.Common.DbCommand.
Installation
Use the Nuget package manager (or your preferred package management tool) to install PyunSoft.AdoExtensions.
PM> Install-Package PyunSoft.AdoExtensions
Usage
using PyunSoft.AdoExtensions;
using var command = connection.CreateCommand();
command.CommandText = "SELECT Id, Name, Amount FROM dbo.Foo";
await connection.OpenAsync();
// DataTable example
using var dataTable = await command.ExecuteDataTableAsync();
// Dictionary example
var dictionary = await command.ExecuteDictionaryAsync<int, string>("Id", "Name");
// List example
var list = await command.ExecuteListAsync<int>("Id");
// ExecuteScalar example
command.CommandText = "SELECT Amount FROM dbo.Foo WHERE Id = @Id";
command.AddParameterWithValue("@Id", 1);
var amount = await command.ExecuteScalarAsync<decimal>();
// ExecuteScalarNullable example
command.CommandText = "SELECT SomeNullableIntColumn FROM dbo.Foo WHERE Id = @Id";
command.AddParameterWithValue("@Id", 1);
var value = await command.ExecuteScalarNullableAsync<int>();
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
License
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net6.0 is compatible. 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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- No dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.