Bat.Dapper
8.0.1
dotnet add package Bat.Dapper --version 8.0.1
NuGet\Install-Package Bat.Dapper -Version 8.0.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="Bat.Dapper" Version="8.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Bat.Dapper --version 8.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Bat.Dapper, 8.0.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.
// Install Bat.Dapper as a Cake Addin
#addin nuget:?package=Bat.Dapper&version=8.0.1
// Install Bat.Dapper as a Cake Tool
#tool nuget:?package=Bat.Dapper&version=8.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
For use Bat.Dapper just do it :
1- Install Bat.Dapper on your project
2- Use it in bussiness logic for example :
public class PageRepo : IPageRepo
{
private SqlConnection _sqlConnection;
public PageRepo(IConfiguration configuration)
{
_sqlConnection = new SqlConnection(configuration.GetConnectionString("CrawlerDbContext"));
}
public async Task<bool> AddAsync(CrawledPageDto model)
{
await _sqlConnection.ExecuteSpCommandAsync<int>("[Instagram].[InsertPage]",
new { Page = model.ToTableValuedParameter("[dbo].[Tvp_Page]") });
return true;
}
public async Task<bool> UpdateAsync(CrawledPageDto model)
{
await _sqlConnection.ExecuteSpCommandAsync<int>("[Instagram].[UpdatePage]",
new { Page = model.ToTableValuedParameter("[dbo].[Tvp_Page]") });
return true;
}
public async Task<bool> DeleteAsync(string pageId)
{
var query = "DELETE [Instagram].[Page] " +
"WHERE [Username] = @Username";
return await _sqlConnection.ExecuteQueryCommandAsync(query, new { Username = pageId });
}
public async Task<Page> FindAsync(string pageId)
{
var query = "SELECT * " +
"FROM [Instagram].[Page] " +
"WHERE [Username] = @Username";
return await _sqlConnection.ExecuteQuerySingleAsync<Page>(query, new { Username = pageId });
}
public async Task<IEnumerable<Page>> GetAsync(DateTime lastCrawlDate, PagingParameter pagingParameter)
{
var query = "SELECT * " +
"FROM [Instagram].[Page] p " +
"WHERE p.ModifyDateMi <= @lastCrawlDate " +
"ORDER BY p.PageId ASC " +
"OFFSET @PageSize * (@PageNumber - 1) ROWS " +
"FETCH NEXT @PageSize ROWS ONLY;";
return await _sqlConnection.ExecuteQueryAsync<Page>(query,
new { lastCrawlDate = lastCrawlDate, pagingParameter.PageNumber, pagingParameter.PageSize });
}
}
And :
public sealed class CrawlerUnitOfWork
{
private readonly IServiceProvider _serviceProvider;
public CrawlerUnitOfWork(IServiceProvider serviceProvider)
{
_serviceProvider = serviceProvider;
}
public IPageRepo PageRepo => _serviceProvider.GetService<IPageRepo>();
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. 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 is compatible. 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 is compatible. 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. |
.NET Core | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.1 is compatible. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.1
- Bat.Core (>= 1.1.8)
- Dapper (>= 2.0.123)
- Microsoft.Data.SqlClient (>= 4.1.0)
- System.ComponentModel.Annotations (>= 5.0.0)
-
net6.0
- Bat.Core (>= 6.0.0)
- Dapper (>= 2.0.123)
- Microsoft.Data.SqlClient (>= 4.1.0)
- System.ComponentModel.Annotations (>= 5.0.0)
-
net7.0
- Bat.Core (>= 7.0.0)
- Dapper (>= 2.0.123)
- Microsoft.Data.SqlClient (>= 5.0.1)
- System.ComponentModel.Annotations (>= 5.0.0)
-
net8.0
- Azure.Identity (>= 1.10.4)
- Bat.Core (>= 8.0.1)
- Dapper (>= 2.1.28)
- Microsoft.Data.SqlClient (>= 5.1.4)
- System.ComponentModel.Annotations (>= 5.0.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
- Upgrade to net8.0 and C#12.0
- Upgrade to Dapper2.1.24
- Add new ExecuteQueryMultipleAsync method