DataAbstractions.Dapper
2.0.1
See the version list below for details.
Install-Package DataAbstractions.Dapper -Version 2.0.1
dotnet add package DataAbstractions.Dapper --version 2.0.1
<PackageReference Include="DataAbstractions.Dapper" Version="2.0.1" />
paket add DataAbstractions.Dapper --version 2.0.1
#r "nuget: DataAbstractions.Dapper, 2.0.1"
// Install DataAbstractions.Dapper as a Cake Addin
#addin nuget:?package=DataAbstractions.Dapper&version=2.0.1
// Install DataAbstractions.Dapper as a Cake Tool
#tool nuget:?package=DataAbstractions.Dapper&version=2.0.1
DataAbstractions.Dapper
A light abstraction around Dapper and Dapper.Contrib that also maintains the behavior IDbConnection. This library facilitates a loosely coupled design and unit testing.
IDataAccessor Interface
The IDataAccessor interface encapsulates Dapper extension methods. Just provide the connection to the DataAccessor.
IDataAccessor dataAccessor = new DataAccessor(new SqlConnection(connectionString));
Execute Dapper queries and commands as you would normally.
var person = await dataAccessor.QueryAsync<Person>(sql, new {Id});
Note: The dataAccessor should be disposed appropriately.
Dapper.Contrib
IDataAccessor includes the Dapper.Contrib extension methods
dataAccessor.Insert(new Person { Name = "John Doe" });
Keeps IDbConnection behavior
IDataAccessor implements IDbConnection, so you can access things like the ConnectionTimeout, ConnectionString, and ConnectionState etc.
If you need access to the actual connection object, use GetUnderlyingConnection():
IDbConnection connection = dataAccessor.GetUnderlyingConnection();
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows |
.NET Core | netcoreapp1.0 netcoreapp1.1 netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard1.3 netstandard1.4 netstandard1.5 netstandard1.6 netstandard2.0 netstandard2.1 |
.NET Framework | net451 net452 net46 net461 net462 net463 net47 net471 net472 net48 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen30 tizen40 tizen60 |
Universal Windows Platform | uap uap10.0 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
-
.NETFramework 4.5.1
- Dapper (>= 1.50.5)
- Dapper.Contrib (>= 1.50.5)
-
.NETStandard 1.3
- Dapper (>= 1.50.5)
- Dapper.Contrib (>= 1.50.5)
- NETStandard.Library (>= 1.6.1)
-
.NETStandard 2.0
- Dapper (>= 1.50.5)
- Dapper.Contrib (>= 1.50.5)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Added abstraction around GridReader to allow mocking. This is a breaking change for methods returning GridReader as it now returns IGridAccessor instead.