Making JSON based data access easier in .net

JSON has become such a ubiquitous data exchange standard in recent times, specially after the advent of RESTful API and their use in mobile apps.

There are many ways to develop a data access layer in .net to achieve retrieval in JSON. But in most cases it requires a significant amount of boilerplate code. Ideally, data access should just act like generic router and be minimal.

Lets get to the point… the data access library project hosted at github tries to make life easier…e.g. if there is a stored procedure, fetch can be done to JSON string in couple of lines of code like below


SqlDataRequest dataRequest = new SqlDataRequest("[ConnectionString]");
 string result = dataRequest.Fetch("[usp_Test_Select]", "{ Id : 1 }"));

The first version is available to download at nuget

Because of its ease of use and serialization performance this library relies completely on  Newtonsoft JSON.net.

Check out the project page for more examples, more importantly since it is open source, review/criticize the code or make it better submit a pull request.