DotNet.Database

This client library is a powerful tool for MSSQL/PostgreSQL.

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: tomasz.margacz@gmail.com

Sample code:
var selectCommandWithParam = _dbClient.ExecuteCommand("Select * from dbo.Test where id = @id", new { id = selectCommand.FirstOrDefault().Id });
var selectProcedureWithParam = _dbClient.ExecuteStoredProcedure("dbo.GetTest", new { id = selectProcedure.FirstOrDefault().Id });

int insertCount = _dbClient.ExecuteCommand("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") });.

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 Z.EntityFramework.Plus.EF6
paket add DotNet.Database
DotNet.Database Download (Unzip the "nupkg" after downloading)



Tags



STATS

must-have-score

avg-downloads-per-day

1

days-since-last-release

237