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" />
                    
Directory.Packages.props
<PackageReference Include="PyunSoft.AdoExtensions" />
                    
Project file
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
                    
#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
                    
Install as a Cake Addin
#tool nuget:?package=PyunSoft.AdoExtensions&version=1.1.0
                    
Install as a Cake Tool

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

MIT

Product 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.

Version Downloads Last Updated
1.1.0 647 3/27/2022
1.0.0 517 6/4/2021