DbSqlHelper 0.9.7
Install-Package DbSqlHelper -Version 0.9.7
dotnet add package DbSqlHelper --version 0.9.7
<PackageReference Include="DbSqlHelper" Version="0.9.7" />
paket add DbSqlHelper --version 0.9.7
#r "nuget: DbSqlHelper, 0.9.7"
// Install DbSqlHelper as a Cake Addin
#addin nuget:?package=DbSqlHelper&version=0.9.7
// Install DbSqlHelper as a Cake Tool
#tool nuget:?package=DbSqlHelper&version=0.9.7
More Details in Github Link : DbSqlHelper : Mini/Easy RDBMS SQL Helper.
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows |
.NET Core | netcoreapp2.0 netcoreapp2.1 netcoreapp2.2 netcoreapp3.0 netcoreapp3.1 |
.NET Standard | netstandard2.0 netstandard2.1 |
.NET Framework | net40 net403 net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48 |
MonoAndroid | monoandroid |
MonoMac | monomac |
MonoTouch | monotouch |
Tizen | tizen40 tizen60 |
Xamarin.iOS | xamarinios |
Xamarin.Mac | xamarinmac |
Xamarin.TVOS | xamarintvos |
Xamarin.WatchOS | xamarinwatchos |
-
.NETFramework 4.0
- ValueGetter (>= 1.0.4)
-
.NETStandard 2.0
- ValueGetter (>= 1.0.4)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on DbSqlHelper:
Package | Downloads |
---|---|
DBSearch
More Details in Github Link : [DBSearch : Mini/Fast Multiple DBMS Search](https://github.com/shps951023/DBSearch) |
GitHub repositories
This package is not used by any popular GitHub repositories.
#### Version 0.9.7
- [X] Add `ContainsKey` method to determines whether the connection cache contains the specified key.
- [X] Add `OpenCloseConnection` method
- [X] Add `Db.SqlQuery` , example with dapper:
```C#
var result = Db.SqlQuery(connection => connection.QueryFirst<string>("select 'Hello Github'"));
Assert.Equal("Hello Github", result);
```
- [X] Add `SimpleSqlFormat`
#### Version 0.9.6
- [X] Add SqlFormat , e.g:
```C#
var sql = Db.SqlFormat("select * from {1}orders{2} where id = {0}id");
//if db is sqlserver
Assert.Equal("select * from [orders] where id = @id", sql);
//if db is oracle
Assert.Equal("select * from \"orders\" where id = :id", sql);
```
#### Version 0.9.5
- [X] Add DbCache Model for ParameterPrefix,QuotePrefix,QuoteSuffix
- [X] Add Common Connection CreateParameter Without DbCommand
- [X] Add `public static DBConnectionType GetDbConnectionType(this Type connectionType)`
#### Version 0.9.4
- [X] Add ParameterExtension Dapper Style AddParams
- [X] Support AddConnection(Type connectionType,string connectionString)
- [X] Add Editable DefaultCommandTimeout
#### Version 0.9.3
- [X] Add String Extension For Easy Execute Sql
#### Version 0.9.2
- [X] Add Db.AddConnection and GetConnection