DbToJson 1.0.3

Getting Started

Once installed, DbToJson needs just few steps to work.

1. Make sure DLL exist in references
2. Add section DbToJson to the project's configuration file, like below:

<configuration>
    <configSections>
        <section name="DbToJson" type="System.Configuration.AppSettingsSection"/>
    </configSections>
    <connectionStrings>
        <add name="Test" connectionString="..." providerName="System.Data.SqlClient" />
    </connectionStrings>
    <DbToJson>
        <add key="ConnectionString" value="Test" />
    </DbToJson>
</configuration>

Query

It builds up the interaction with database and return the expected result. The constructor awaits these two parameters:

• Text, equals to the stored procedure's name or SQL text of the query
• Service, that is the response's translation service to use
• isSp, by default to true, can be overrided when you want to execute SQL text

Query query = new Query("GetUsers", new JsonService());

Core

It is the singleton class that communicate with database. Expose the following methods:

• GetObject
• GetObjectList

N.B.: When you want an output in JSON format, use the type dynamic instead of string.

IService

Interface reusable to develop your own response's translation service to use with DbToJson. It expose the following methods:

• TranslateObject, when you have only one result in response
• TranslateObjectList, to translate lists of results
• TranslateObjectCommand, needed when expected return paramaters from the stored procedure

Actually, DbToJson has included following services:

• JsonService, to convert in JSON format
• ObjectService, to convert data in a specific type