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

object

C1ConnectionBase<C1SnowflakeConnection>

C1SnowflakeConnection

Implements

Namespace: C1.AdoNet.Snowflake

Assembly: C1.AdoNet.Snowflake.dll

Syntax

public sealed class C1SnowflakeConnection : C1ConnectionBase<C1SnowflakeConnection>, IComponent, IDbConnection, IDisposable, IAsyncDisposable, IExtendedConnection

Public NotInheritable Class C1SnowflakeConnection
    Inherits C1ConnectionBase(Of C1SnowflakeConnection)
    Implements IComponent, IDbConnection, IDisposable, IAsyncDisposable, IExtendedConnection

Constructors

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.