DataAbstractions.Dapper
3.0.0
See the version list below for details.
Install-Package DataAbstractions.Dapper -Version 3.0.0
dotnet add package DataAbstractions.Dapper --version 3.0.0
<PackageReference Include="DataAbstractions.Dapper" Version="3.0.0" />
paket add DataAbstractions.Dapper --version 3.0.0
#r "nuget: DataAbstractions.Dapper, 3.0.0"
// Install DataAbstractions.Dapper as a Cake Addin
#addin nuget:?package=DataAbstractions.Dapper&version=3.0.0
// Install DataAbstractions.Dapper as a Cake Tool
#tool nuget:?package=DataAbstractions.Dapper&version=3.0.0
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 | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net461 net462 net463 net47 net471 net472 net48 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
-
.NETFramework 4.6.1
- Dapper (>= 2.0.35)
- Dapper.Contrib (>= 2.0.35)
-
.NETStandard 2.0
- Dapper (>= 2.0.35)
- Dapper.Contrib (>= 2.0.35)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Upgraded Dapper to v2.0.35 and Dapper.Contrib to v2.0.35. Bumping up major version because Dapper introduced a slight breaking change in version 2.0.4.