DBS-ORM.PostgreSQL
1.0.3
dotnet add package DBS-ORM.PostgreSQL --version 1.0.3
NuGet\Install-Package DBS-ORM.PostgreSQL -Version 1.0.3
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="DBS-ORM.PostgreSQL" Version="1.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="DBS-ORM.PostgreSQL" Version="1.0.3" />
<PackageReference Include="DBS-ORM.PostgreSQL" />
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 DBS-ORM.PostgreSQL --version 1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DBS-ORM.PostgreSQL, 1.0.3"
#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 DBS-ORM.PostgreSQL@1.0.3
#: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=DBS-ORM.PostgreSQL&version=1.0.3
#tool nuget:?package=DBS-ORM.PostgreSQL&version=1.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
DBS-ORM.PostgreSQL
DLL Responsavel pelas conexoes Mult-Banco aplicando EntityFrameWork e ADO-SQL
Exemplo de comando para scaffoldo dos Bancos existentes:
Observa��o: Cuidados com os nomes das entidade e respeite letras maiusculas e minusculas.
Scaffold-DbContext Sample
Scaffold-DbContext "Coloque aqui sua connection string" Oracle.EntityFrameworkCore -OutputDir .\App\Entity\Readsoft
Oracle Sample
Scaffold-DbContext "User Id=usuario;Password=password;Data Source=host-Banco-dados-oracle:18095/servicename;" Oracle.EntityFrameworkCore -OutputDir .\App\Entity\Readsoft
SampleImplementation
// Exemplo de implementa��o de um DbContext e AdoContext
public class SampleImplementation
{
// Exemplo de classe de contexto
public static void Main()
{
// Exemplo de uso do DbContext
using (var context = new Context("ConnectionString"))
{
// Exemplo de uso do AdoContext
var sqlExecutor = new AdoContext(context);
// Exemplo de comando que n�o retorna dados
string updateSql = "UPDATE Tabela SET Coluna = {0} WHERE Condicao = {1}";
int linhasAfetadas = sqlExecutor.ExecuteNonQuery(updateSql, "NovoValor", 1);
Console.WriteLine($"Linhas afetadas: {linhasAfetadas}");
// Exemplo de consulta que retorna dados
string selectSql = "SELECT * FROM PROCESSO WHERE NRPROCESSO = {0}";
var resultado = sqlExecutor.ExecuteQuery<Processlog>(selectSql, "6365908865");
Console.WriteLine($"Resultados: {resultado.Count}");
// Exemplo de consulta que retorna um DataTable
string selectSqlDT = "SELECT * FROM PROCESSO WHERE NRPROCESSO = :p0 and NRCONHECIMENTO = :p1";
var dataTable = sqlExecutor.ExecuteQueryToDataTable(selectSqlDT, "6365908865", "876500323");
// Exibindo resultados
foreach (DataRow row in dataTable.Rows)
{
Console.WriteLine(row["NomeColuna"]); // Substitua "NomeColuna" pelo nome da coluna desejada
}
}
}
}
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net9.0
- Npgsql (>= 9.0.3)
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 9.0.4)
- Npgsql.EntityFrameworkCore.PostgreSQL.NetTopologySuite (>= 9.0.4)
- Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime (>= 9.0.4)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.