Vivan.Data.Core
1.0.8
dotnet add package Vivan.Data.Core --version 1.0.8
NuGet\Install-Package Vivan.Data.Core -Version 1.0.8
<PackageReference Include="Vivan.Data.Core" Version="1.0.8" />
paket add Vivan.Data.Core --version 1.0.8
#r "nuget: Vivan.Data.Core, 1.0.8"
// Install Vivan.Data.Core as a Cake Addin
#addin nuget:?package=Vivan.Data.Core&version=1.0.8
// Install Vivan.Data.Core as a Cake Tool
#tool nuget:?package=Vivan.Data.Core&version=1.0.8
Vivan.Data.Core
Biblioteca que possui um conjunto de classes utilizadas para auxiliar no desenvolvimento da camada "Infra.Data" e Repositórios que acessam algum banco de dados.
Instalação
Instalar o package 'Vivan.Data.Core' através do Nuget Package Manager.
Dependências
Recursos
- IDbConnectionFactory
- OracleConnectionFactory
- BaseRepository
Utilizando os recursos IDbConnectionFactory e OracleConnectionFactory
As classes IDbConnectionFactory e OracleConnectionFactory servem como recurso de conexão para a classe BaseRepository.
A interface IDbConnectionFactory deve ser adicionada no container do .net core na classe startup da seguinte forma:
services.AddScoped<IDbConnectionFactory>(factory => new OracleConnectionFactory(_configuration["ConnectionStrings:Oracle"]));
Note que no momento em que a classe IDbConnectionFactory é adicionada, passamos como parâmetro uma instância da classe OracleConnectionFactory que recebe em seu construtor a connection string da base Oracle.
Utilizando a classe BaseRepository
É a classe base para construção de repositórios de banco de dados.
Para Instânciá-la, basta herdá-la e informar uma interface IDbConnectionFactory como parâmetro em seu construtor:
public class CatalogoRepository : BaseRepository, ICatalogRepository
{
public CatalogoRepository(IDbConnectionFactory dbConnectionFactory) : base(dbConnectionFactory)
{ }
}
Para executar algum comando SQL em um repositório que herda a classe BaseRepository, basta abrir uma conexão com o banco de dados:
public async Task<Catalogo> ObterPorIAsync(int id)
{
using (var connection = DbConnectionFactory.Create())
{
var catalog = await connection.QuerySingleAsync<Catalogo>(
"SELECT * FROM Catalogo WHERE Id = :Id",
new { Id = id });
return catalog;
}
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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. |
.NET Core | netcoreapp2.2 is compatible. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
-
.NETCoreApp 2.2
- MySqlConnector (>= 0.56.0)
- Oracle.ManagedDataAccess.Core (>= 2.19.31)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.