Info
| Version: | 0.0.5 |
| Author(s): | Tomasz Margacz |
| Last Update: | Wednesday, January 31, 2018 |
| .NET Fiddle: | Create the first Fiddle |
| NuGet Url: | https://www.nuget.org/packages/DotNet.Database |
Install
Install-Package DotNet.Database
dotnet add package DotNet.Database
paket add DotNet.Database
DotNet.Database Download (Unzip the "nupkg" after downloading)
Dependencies
- Npgsql(>= 3.2.6)
- Newtonsoft.Json(>= 9.0.1)
Tags
This tool allows to easy execute command/procedure with using only one line of code.
Samples - https://github.com/tomaszmargacz/nuget-samples/tree/master/DotNet.Database.Sample
If you have any questions or need improvement feel free to contact me: [email protected]
Sample code:
var selectCommandWithParam = _dbClient.ExecuteCommand<TestModel>("Select * from dbo.Test where id = @id", new { id = selectCommand.FirstOrDefault().Id });
var selectProcedureWithParam = _dbClient.ExecuteStoredProcedure<TestModel>("dbo.GetTest", new { id = selectProcedure.FirstOrDefault().Id });
int insertCount = _dbClient.ExecuteCommand<int>("INSERT INTO dbo.Test (id, text, rate, created) VALUES (@id, @text, @rate, @created)", new { id = Guid.NewGuid().ToString(), text = "Test", rate = 1.2, created = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss") });.