Smart.Data.Oracle
3.0.1
dotnet add package Smart.Data.Oracle --version 3.0.1
NuGet\Install-Package Smart.Data.Oracle -Version 3.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="Smart.Data.Oracle" Version="3.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Smart.Data.Oracle --version 3.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Smart.Data.Oracle, 3.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 Smart.Data.Oracle as a Cake Addin #addin nuget:?package=Smart.Data.Oracle&version=3.0.1 // Install Smart.Data.Oracle as a Cake Tool #tool nuget:?package=Smart.Data.Oracle&version=3.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Smart.Data.Oracle
基于 Oracle.ManagedDataAccess.Core 封装的轻量级 Oracle 数据库操作库，支持 .NET 6/8/9。
功能特性
- 异步数据库操作（增删改查）
- 自动连接池管理
- 事务批处理支持
- Oracle 数据类型自动映射
- 参数化查询防护
安装
bash
dotnet add package Smart.Data.Oracle
快速使用
csharp
var db = new SmartOracleService("User Id=scott;Password=tiger;Data Source=orcl;");
// 插入数据
await db.ExecuteNonQueryAsync("INSERT INTO users (Name) VALUES (:name)",[new OracleParameter("name", "Alice")]);
// 批量事务操作
var sqls = new List<string>
{
"UPDATE accounts SET balance = balance - 100 WHERE id = 1",
"UPDATE accounts SET balance = balance + 100 WHERE id = 2"
};
await db.ExecuteNonQuerysAsync(sqls);
// 查询数据
var dt = await db.GetDataTableAsync("SELECT * FROM users WHERE Age > :age",[new OracleParameter("age", 18)]);
依赖注入
csharp
// Startup.cs
services.AddSmartOracle("your_connection_string");
注意事项
- Oracle 参数使用冒号前缀（:param）代替@符号
- 列名若为保留字需使用双引号包裹：
"NUMBER" - 不支持存储过程调用（需直接使用ADO.NET）
- 长文本建议使用 OracleLob 类型处理
- 事务操作注意 ORA-错误码处理（如 ORA-00060）
Developed by zenglei
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | 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 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 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. 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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- Microsoft.Extensions.DependencyInjection (>= 9.0.2)
- Oracle.ManagedDataAccess.Core (>= 23.7.0)
-
net8.0
- Microsoft.Extensions.DependencyInjection (>= 9.0.2)
- Oracle.ManagedDataAccess.Core (>= 23.7.0)
-
net9.0
- Microsoft.Extensions.DependencyInjection (>= 9.0.2)
- Oracle.ManagedDataAccess.Core (>= 23.7.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.