DbToJson 1.1.1

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
• 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
• GetPrimitive
• Exec