Welcome to Retriever.net
In most .net projects some way of accessing database data is required, usually for all new projects many may choose to use ORM frameworks. But at times you just need an easy way to access data without much configuration. With many modern apps and APIs, all you need is JSON as input and output.
This library makes it easy to develop JSON based data access layer without much ADO.net boilerplate code. Currently only works with MS SQL Server database.
This library depends heavily on Newtonsoft.Json
You can do retrieve directly to JSON with couple of lines of code like...
// Param is the db connection string
SqlDataRequest dataRequest = new SqlDataRequest("[ConnectionString]");
string result = dataRequest.Fetch("[dbo].[usp_Test_Select]", "{ Id : 1 }"));
Similarly an insert/update is as simple as...
var obj = new
{
Id = rInt,
Name = "John Doe",
Description = "Demo test description"
};
int rowsAffected = dataRequest.Hurl("[dbo].[usp_Test_Insert]", obj);