# C1.AdoNet.Json.C1JsonConnection

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="C1_AdoNet_Json_C1JsonConnection" data-uid="C1.AdoNet.Json.C1JsonConnection" class="text-break">C1JsonConnection Class
</h1>
  <div class="markdown level0 summary"><pre><code>&lt;xref href=&quot;C1.AdoNet.Json.C1JsonConnection&quot; data-throw-if-not-resolved=&quot;false&quot;&gt;&lt;/xref&gt; represents a connection to a Json server. 
</code></pre>
<p>The connection can be used to query the data hosted by the server or request modifications.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.marshalbyrefobject">MarshalByRefObject</a></div>
    <div class="level2"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.componentmodel.component">Component</a></div>
    <div class="level3"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.common.dbconnection">DbConnection</a></div>
    <div class="level4"><a class="xref" href="../C1.AdoNet.CSV/C1.DataConnector.AdoNet.C1ConnectionBase.html">C1ConnectionBase</a></div>
    <div class="level5"><a class="xref" href="C1.DataConnector.AdoNet.C1ConnectionBase-1.html">C1ConnectionBase</a>&lt;<a class="xref" href="C1.AdoNet.Json.C1JsonConnection.html">C1JsonConnection</a>&gt;</div>
    <div class="level6"><span class="xref">C1JsonConnection</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.componentmodel.icomponent">IComponent</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.idbconnection">IDbConnection</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.idisposable">IDisposable</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.iasyncdisposable">IAsyncDisposable</a></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.AdoNet.Json.html">C1.AdoNet.Json</a></h6>
  <h6><strong>Assembly</strong>: C1.AdoNet.Json.dll</h6>
  <h5 id="C1_AdoNet_Json_C1JsonConnection_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public sealed class C1JsonConnection : C1ConnectionBase&lt;C1JsonConnection&gt;, IComponent, IDbConnection, IDisposable, IAsyncDisposable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public NotInheritable Class C1JsonConnection
    Inherits C1ConnectionBase(Of C1JsonConnection)
    Implements IComponent, IDbConnection, IDisposable, IAsyncDisposable</code></pre>
  </div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection__ctor" data-uid="C1.AdoNet.Json.C1JsonConnection.#ctor">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.-ctor.html#C1_AdoNet_Json_C1JsonConnection__ctor">C1JsonConnection()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.html">C1JsonConnection</a> instance.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection__ctor_C1_AdoNet_Json_C1JsonConnectionStringBuilder_" data-uid="C1.AdoNet.Json.C1JsonConnection.#ctor(C1.AdoNet.Json.C1JsonConnectionStringBuilder)">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.-ctor.html#C1_AdoNet_Json_C1JsonConnection__ctor_C1_AdoNet_Json_C1JsonConnectionStringBuilder_">C1JsonConnection(C1JsonConnectionStringBuilder)</a>
        </td>
        <td class="markdown level1 summary"><p>Initialize a new <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.html">C1JsonConnection</a> instance using the specified connection string.
expressed in a <a class="xref" href="C1.AdoNet.Json.C1JsonConnectionStringBuilder.html">C1JsonConnectionStringBuilder</a>.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection__ctor_System_String_" data-uid="C1.AdoNet.Json.C1JsonConnection.#ctor(System.String)">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.-ctor.html#C1_AdoNet_Json_C1JsonConnection__ctor_System_String_">C1JsonConnection(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Initialize a new <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.html">C1JsonConnection</a> instance using the specified connection string.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_ApiConfigFile" data-uid="C1.AdoNet.Json.C1JsonConnection.ApiConfigFile">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.ApiConfigFile.html#C1_AdoNet_Json_C1JsonConnection_ApiConfigFile">ApiConfigFile</a>
        </td>
        <td class="markdown level1 summary"><p>The path to the config file for http/https Json source.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_DataModel" data-uid="C1.AdoNet.Json.C1JsonConnection.DataModel">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.DataModel.html#C1_AdoNet_Json_C1JsonConnection_DataModel">DataModel</a>
        </td>
        <td class="markdown level1 summary"><p>Specifies the data model to use when parsing JSON documents and generating the database metadata.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_DataSource" data-uid="C1.AdoNet.Json.C1JsonConnection.DataSource">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.DataSource.html#C1_AdoNet_Json_C1JsonConnection_DataSource">DataSource</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the name of the database server to which to connect.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_Database" data-uid="C1.AdoNet.Json.C1JsonConnection.Database">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.Database.html#C1_AdoNet_Json_C1JsonConnection_Database">Database</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the name of the current database after a connection is opened,
or the database name specified in the connection string before the connection is opened.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_JsonPath" data-uid="C1.AdoNet.Json.C1JsonConnection.JsonPath">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.JsonPath.html#C1_AdoNet_Json_C1JsonConnection_JsonPath">JsonPath</a>
        </td>
        <td class="markdown level1 summary"><p>The JsonPath of an array element that defines the separation of rows.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_ServerVersion" data-uid="C1.AdoNet.Json.C1JsonConnection.ServerVersion">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.ServerVersion.html#C1_AdoNet_Json_C1JsonConnection_ServerVersion">ServerVersion</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a string that represents the version of the server to which the object is connected.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_Uri" data-uid="C1.AdoNet.Json.C1JsonConnection.Uri">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.Uri.html#C1_AdoNet_Json_C1JsonConnection_Uri">Uri</a>
        </td>
        <td class="markdown level1 summary"><p>The Uniform Resource Identifier (URI) for the JSON resource location.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_BeginDbTransaction_System_Data_IsolationLevel_" data-uid="C1.AdoNet.Json.C1JsonConnection.BeginDbTransaction(System.Data.IsolationLevel)">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.BeginDbTransaction.html#C1_AdoNet_Json_C1JsonConnection_BeginDbTransaction_System_Data_IsolationLevel_">BeginDbTransaction(IsolationLevel)</a>
        </td>
        <td class="markdown level1 summary"><p>Begins a transaction on the connection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_ChangeDatabase_System_String_" data-uid="C1.AdoNet.Json.C1JsonConnection.ChangeDatabase(System.String)">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.ChangeDatabase.html#C1_AdoNet_Json_C1JsonConnection_ChangeDatabase_System_String_">ChangeDatabase(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Changes the current database for an open connection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_Close" data-uid="C1.AdoNet.Json.C1JsonConnection.Close">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.Close.html#C1_AdoNet_Json_C1JsonConnection_Close">Close()</a>
        </td>
        <td class="markdown level1 summary"><p>Closes the connection to the database. This is the preferred method of closing any open connection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_CreateDbCommand" data-uid="C1.AdoNet.Json.C1JsonConnection.CreateDbCommand">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.CreateDbCommand.html#C1_AdoNet_Json_C1JsonConnection_CreateDbCommand">CreateDbCommand()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates and returns a <a class="xref" href="https://learn.microsoft.com/dotnet/api/system.data.common.dbcommand">DbCommand</a> object associated with the current connection.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_GetColumnsSchema_System_String___" data-uid="C1.AdoNet.Json.C1JsonConnection.GetColumnsSchema(System.String[])">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.GetColumnsSchema.html#C1_AdoNet_Json_C1JsonConnection_GetColumnsSchema_System_String___">GetColumnsSchema(string[])</a>
        </td>
        <td class="markdown level1 summary"><p>Retrieve the metadata relatively to the columns.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_GetIndexColumns_System_String___" data-uid="C1.AdoNet.Json.C1JsonConnection.GetIndexColumns(System.String[])">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.GetIndexColumns.html#C1_AdoNet_Json_C1JsonConnection_GetIndexColumns_System_String___">GetIndexColumns(string[])</a>
        </td>
        <td class="markdown level1 summary"><p>Retrieve the metadata relatively to the index columns.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_GetIndexesSchema_System_String___" data-uid="C1.AdoNet.Json.C1JsonConnection.GetIndexesSchema(System.String[])">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.GetIndexesSchema.html#C1_AdoNet_Json_C1JsonConnection_GetIndexesSchema_System_String___">GetIndexesSchema(string[])</a>
        </td>
        <td class="markdown level1 summary"><p>Retrieve the metadata relatively to the indexes.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_GetPrimaryKeySchema_System_String___" data-uid="C1.AdoNet.Json.C1JsonConnection.GetPrimaryKeySchema(System.String[])">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.GetPrimaryKeySchema.html#C1_AdoNet_Json_C1JsonConnection_GetPrimaryKeySchema_System_String___">GetPrimaryKeySchema(string[])</a>
        </td>
        <td class="markdown level1 summary"><p>Retrieve the metadata relatively to the primary keys.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_GetTablesSchema_System_String___" data-uid="C1.AdoNet.Json.C1JsonConnection.GetTablesSchema(System.String[])">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.GetTablesSchema.html#C1_AdoNet_Json_C1JsonConnection_GetTablesSchema_System_String___">GetTablesSchema(string[])</a>
        </td>
        <td class="markdown level1 summary"><p>Retrieve the metadata relatively to the tables.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_OnConnectionStringChanged" data-uid="C1.AdoNet.Json.C1JsonConnection.OnConnectionStringChanged">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.OnConnectionStringChanged.html#C1_AdoNet_Json_C1JsonConnection_OnConnectionStringChanged">OnConnectionStringChanged()</a>
        </td>
        <td class="markdown level1 summary"><p>A method that is executed everytime that the connection string used by this <a class="xref" href="C1.AdoNet.Json.C1JsonConnectionStringBuilder.html">C1JsonConnectionStringBuilder</a> has changed.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_Open" data-uid="C1.AdoNet.Json.C1JsonConnection.Open">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.Open.html#C1_AdoNet_Json_C1JsonConnection_Open">Open()</a>
        </td>
        <td class="markdown level1 summary"><p>Opens a database connection with the settings specified by the connection string.</p>
</td>
      </tr>
      <tr>
        <td id="C1_AdoNet_Json_C1JsonConnection_OpenAsync_System_Threading_CancellationToken_" data-uid="C1.AdoNet.Json.C1JsonConnection.OpenAsync(System.Threading.CancellationToken)">
          <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.OpenAsync.html#C1_AdoNet_Json_C1JsonConnection_OpenAsync_System_Threading_CancellationToken_">OpenAsync(CancellationToken)</a>
        </td>
        <td class="markdown level1 summary"><p>An asynchronous version of <a class="xref" href="C1.AdoNet.Json.C1JsonConnection.Open.html#C1_AdoNet_Json_C1JsonConnection_Open">Open()</a> open.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>
