Yinyang.Utilities.Oracle
1.0.0-beta2
This is a prerelease version of Yinyang.Utilities.Oracle.
dotnet add package Yinyang.Utilities.Oracle --version 1.0.0-beta2
NuGet\Install-Package Yinyang.Utilities.Oracle -Version 1.0.0-beta2
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="Yinyang.Utilities.Oracle" Version="1.0.0-beta2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Yinyang.Utilities.Oracle --version 1.0.0-beta2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Yinyang.Utilities.Oracle, 1.0.0-beta2"
#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 Yinyang.Utilities.Oracle as a Cake Addin
#addin nuget:?package=Yinyang.Utilities.Oracle&version=1.0.0-beta2&prerelease
// Install Yinyang.Utilities.Oracle as a Cake Tool
#tool nuget:?package=Yinyang.Utilities.Oracle&version=1.0.0-beta2&prerelease
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Yinyang Utilities Oracle
Oracle Connection Utility for C# .NET.
C#用Oracle接続ユーティリティです。
Getting started
Install Yinyang Utilities Oracle nuget package.
NuGet パッケージ マネージャーからインストールしてください。
Install-Package Yinyang.Utilities.Oracle
Install-Package Yinyang.Utilities.Oracle.Core
Basic Usage
// Init
using var db = new OracleDatabase(ConnectionString);
// Database Open
db.Open();
// Transaction Start
db.BeginTransaction();
// SQL
db.CommandText = "INSERT INTO test2 VALUES(:id, :value)";
// Add Parameter
db.AddParameter(":id", 1);
db.AddParameter(":value", "abcdefg");
// Execute
if (1 != db.ExecuteNonQuery())
{
// Transaction Rollback
db.Rollback();
return;
}
// Command and Parameter Reset
db.Refresh();
// SQL
db.CommandText = "select * from test2 where id = :id";
// Add Parameter
db.AddParameter(":id", 1);
// Execute
var result = db.ExecuteReaderFirst<Entity>();
if (null == result)
{
db.Rollback();
return;
}
// Transaction Commit
db.Commit();
// Database Close
db.Close();
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net472 is compatible. net48 is compatible. net481 is compatible. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETFramework 4.7.2
- Oracle.ManagedDataAccess (>= 21.11.0)
-
.NETFramework 4.8
- Oracle.ManagedDataAccess (>= 21.11.0)
-
.NETFramework 4.8.1
- Oracle.ManagedDataAccess (>= 21.11.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.0.0-beta2 | 77 | 9/10/2023 |