microservice.toolkit.connection.extensions 3.0.0-alpha.1

This is a prerelease version of microservice.toolkit.connection.extensions.

dotnet add package microservice.toolkit.connection.extensions --version 3.0.0-alpha.1

NuGet\Install-Package microservice.toolkit.connection.extensions -Version 3.0.0-alpha.1

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="microservice.toolkit.connection.extensions" Version="3.0.0-alpha.1" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="microservice.toolkit.connection.extensions" Version="3.0.0-alpha.1" />
                    

                            Directory.Packages.props

<PackageReference Include="microservice.toolkit.connection.extensions" />
                    

                            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 microservice.toolkit.connection.extensions --version 3.0.0-alpha.1

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: microservice.toolkit.connection.extensions, 3.0.0-alpha.1"

#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 microservice.toolkit.connection.extensions@3.0.0-alpha.1

#: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=microservice.toolkit.connection.extensions&version=3.0.0-alpha.1&prerelease
                    

                            Install as a Cake Addin

#tool nuget:?package=microservice.toolkit.connection.extensions&version=3.0.0-alpha.1&prerelease
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Connection Manager

Nuget Nuget

Common interface to simplify the access to a SQL database.

How to install

Package Manager

Install-Package microservice.toolkit.connection.extensions -Version 2.1.0

.NET CLI

dotnet add package microservice.toolkit.connection.extensions --version 2.1.0

Package Reference

<PackageReference Include="microservice.toolkit.connection.extensions" Version="2.1.0" />

Available extensions methods

Execute<T>(Func<DbCommand, T>)

T Execute<T>(Func<DbCommand, T> lambda);

Execute<T>(string, Func<DbDataReader, T>, Dictionary<string, object>)

List<T> Execute<T>(string sql, Func<DbDataReader, T> lambda, Dictionary<string, object> parameters = null);

ExecuteFirst<T>(string, Func<DbDataReader, T>, Dictionary<string, object>)

T ExecuteFirst<T>(string sql, Func<DbDataReader, T> lambda, Dictionary<string, object> parameters = null);

ExecuteAsync<T>(Func<DbCommand, Task<T>>)

Task<T> ExecuteAsync<T>(Func<DbCommand, Task<T>> lambda);

ExecuteAsync<T>(string, Func<DbDataReader, T>, Dictionary<string, object>)

Task<List<T>> ExecuteAsync<T>(string sql, Func<DbDataReader, T> lambda, Dictionary<string, object> parameters = null);

ExecuteFirstAsync<T>(string, Func<DbDataReader, T>, Dictionary<string, object>);

Task<T> ExecuteFirstAsync<T>(string sql, Func<DbDataReader, T> lambda, Dictionary<string, object> parameters = null);

ExecuteNonQueryAsync(string, Dictionary<string, object>)

Task<int> ExecuteNonQueryAsync(string query, Dictionary<string, object> parameters);

Executes the query using parameters

GetCommand()

DbCommand GetCommand();

Creates a DbCommand for the current connection.

SafeOpen()

void SafeOpen();

Opens a connection to the database if it is not already opened.

SafeOpenAsync()

Task SafeOpenAsync();

Opens a connection to the database if it is not already opened.

SafeClose()

void SafeClose();

Closes a connection to the database if it is not already closed.

SafeCloseAsync()

Task SafeCloseAsync();