-
dotnet-api
- C1.AdoNet.CSV Assembly
- C1.AdoNet.D365S Assembly
- C1.AdoNet.GoogleAnalytics Assembly
- C1.AdoNet.Json Assembly
- C1.AdoNet.Kintone Assembly
- C1.AdoNet.Magento Assembly
- C1.AdoNet.OData Assembly
- C1.AdoNet.QuickBooksOnline Assembly
- C1.AdoNet.Salesforce Assembly
- C1.AdoNet.ServiceNow Assembly
- C1.AdoNet.Snowflake Assembly
- C1.DataConnector Assembly
C1.AdoNet.Snowflake.C1SnowflakeConnection
C1SnowflakeConnection Class
<xref href="C1.AdoNet.Snowflake.C1SnowflakeConnection" data-throw-if-not-resolved="false"></xref> represents a connection to a Snowflake server.
The connection can be used to query the data hosted by the server or request modifications.
Inheritance
Namespace: C1.AdoNet.Snowflake
Assembly: C1.AdoNet.Snowflake.dll
Syntax
public sealed class C1SnowflakeConnection : C1ConnectionBase<C1SnowflakeConnection>, IComponent, IDbConnection, IDisposable, IAsyncDisposable, IExtendedConnectionConstructors
| Name | Description |
|---|---|
| C1SnowflakeConnection() | Creates a new C1SnowflakeConnection instance. |
| C1SnowflakeConnection(C1SnowflakeConnectionStringBuilder) | Initialize a new C1SnowflakeConnection instance using the specified connection string expressed in a C1SnowflakeConnectionStringBuilder. |
| C1SnowflakeConnection(string) | Initialize a new C1SnowflakeConnection instance using the specified connection string. |
Properties
| Name | Description |
|---|---|
| Account | The account of the user in Swnowflake. |
| BaseUrl | The base url of the Snowflake server. |
| DataSource | Gets the name of the database server to which to connect. |
| Database | 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. |
| DatabaseConn | The name of the database. |
| FingerPrint | The finger print of the public key after added in Snowflake server |
| OAuthToken | Gets the current access token and refresh token. |
| PrivateKey | The path of the private key file. |
| PrivateKeyPassword | The password of the private key. |
| Role | The role of the user making the request. |
| Schema | The name of the schema. |
| ServerVersion | Gets a string that represents the version of the server to which the object is connected. |
| SupportGroupBy | A boolean specifying whether or not this C1ODataConnection is using SupportGroupBy. |
| SupportLimit | A boolean specifying whether or not this C1ODataConnection is using SupportLimit. |
| SupportOrderBy | A boolean specifying whether or not this C1ODataConnection is using SupportOrderBy. |
| UseDynamicType | A boolean specifying whether or not this C1ODataConnection is using dynamic type. |
| Warehouse | The name of the warehouse. |
Methods
| Name | Description |
|---|---|
| BeginDbTransaction(IsolationLevel) | Begins a transaction on the connection. |
| ChangeDatabase(string) | Changes the current database for an open connection. |
| Close() | Closes the connection to the database. This is the preferred method of closing any open connection. |
| CreateDbCommand() | Creates and returns a DbCommand object associated with the current connection. |
| Dispose(bool) | Dispose the connection. |
| GetColumnsSchema(string[]) | Retrieve the metadata relatively to the columns. |
| GetForeignKeySchema(string[]) | Retrieve the metadata relatively to the foreign keys. |
| GetPrimaryKeySchema(string[]) | Retrieve the metadata relatively to the primary keys. |
| GetTablesSchema(string[]) | Retrieve the metadata relatively to the tables. |
| OnConnectionStringChanged() | A method that is executed everytime that the connection string used by this C1SnowflakeConnectionStringBuilder has changed. |
| Open() | Opens a database connection with the settings specified by the connection string. |
| OpenAsync(CancellationToken) | An asynchronous version of Open() open. |
Events
| Name | Description |
|---|---|
| OAuthTokenRefreshed | Occurs after the token refreshes. |