Ecosyste.ms: Packages
An open API service providing package, version and dependency metadata of many open source software ecosystems and registries.
nuget.org : 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: [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") });
Registry
- JSON
purl: pkg:nuget/dotnet.database
Keywords: ORM, MSSQL, SqlClient, PostgreSQL, Npgsql, Object, Relational, Mapping
License:
Latest release: over 6 years ago
First release: over 124 years ago
Dependent repositories: 1
Downloads: 3,805 total
Last synced: 17 days ago