DbSqlHelper 0.9.7

More Details in Github Link : [DbSqlHelper : Mini/Easy RDBMS SQL Helper. ](https://github.com/shps951023/DbSqlHelper)

Install-Package DbSqlHelper -Version 0.9.7
dotnet add package DbSqlHelper --version 0.9.7
<PackageReference Include="DbSqlHelper" Version="0.9.7" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DbSqlHelper --version 0.9.7
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

#### 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

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
0.9.7 224 5/26/2019
0.9.6 180 5/15/2019
0.9.5 182 5/15/2019
0.9.4 202 5/12/2019
0.9.3 181 5/11/2019
0.9.2 182 5/10/2019