dotConnect for Google BigQuery Documentation
Devart.Data.BigQuery Namespace / BigQueryConnectionStringBuilder Class
Properties Methods

On this page
    BigQueryConnectionStringBuilder Class Members
    On this page

    The following tables list the members exposed by BigQueryConnectionStringBuilder.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the BigQueryConnectionStringBuilder class.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets the authentication type: AuthenticationType.UserAccount, AuthenticationType.ServiceAccount, or AuthenticationType.UserAccountInteractive.  
    Public PropertyGets or sets the OAuth 2.0 client ID of your application registered in the Google Cloud Console. Required for the AuthenticationType.UserAccount authentication type. For AuthenticationType.UserAccountInteractive, if it is not specified, the client ID of the Devart application is used.  
    Public PropertyGets or sets the OAuth 2.0 client secret of your application registered in the Google Cloud Console. Required for the AuthenticationType.UserAccount authentication type. For AuthenticationType.UserAccountInteractive, if it is not specified, the client secret of the Devart application is used.  
    Public PropertyGets or sets time span in seconds for connection to live. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public Property (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets the time to wait while trying to establish a connection before terminating the attempt and generating an error. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public Property (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets the ID of the default dataset. If it is specified, metadata is retrieved only for this dataset.  
    Public PropertyGets or sets the name of the Google Cloud Storage bucket that BigQueryLoader uses by default to store data temporarily before loading it to Google BigQuery.  
    Public PropertyGets or sets the time in seconds to wait while trying to execute a command before terminating the attempt and generating an error. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets a value indicating whether the connection is automatically enlisted in the current transaction context (TransactionScope). The default value is true.  
    Public PropertyGets or sets the number of retry attempts to re-run a command in case when the command failed because of an exception, that indicates that the reason of the failure may be temporary. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertySpecifies a data source-specific command that should be executed immediately after establishing the connection. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public PropertyReturns true. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public Property (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public PropertyReturns the value of given key. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyCollection of keys in the Devart.Data.SqlShimConnectionStringBuilder. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets the license key. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyDetermines whether to use local SQL engine for SELECT queries, that are too complex to translate them directly to Google BigQuery API calls or to throw an exception. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyThe maximum number of connections allowed in the pool. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyThe minimum number of connections allowed in the pool. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets a value indicating whether object names are normalized: dots and double quotes are replaced with underscores, and names longer than 63 characters are shortened. The default value is false. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets a value indicating whether password is stored in connection string after connection is opened. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets pooling mode. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets a comma-separated list of columns that are considered primary key columns for tables that have no declared primary key. Specify a column name for all tables, or table.column for a specific table.  
    Public PropertyGets or sets the ID of the Google Cloud project to connect to.  
    Public PropertyGets or sets the host name or IP address of the proxy server to which to connect. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets the password for the proxy server account. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets the port number of the proxy server. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets the proxy server account name. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets a value indicating whether the connection is read-only (allows only SELECT statements). (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets the OAuth 2.0 refresh token used for the AuthenticationType.UserAccount and AuthenticationType.UserAccountInteractive authentication types.  
    Public PropertySpecifies a data source-specific command that should be executed immediately after first establishing the connection. Unlike InitializationCommand, this command is not executed when a connection is taken from the pool. (Inherited from Devart.Common.DbConnectionStringBuilder)
    Public PropertyGets or sets the service account key for the AuthenticationType.ServiceAccount authentication type: either the content of the key JSON file or the path to this file.  
    Public PropertyGets or sets the location to store OAuth 2.0 refresh tokens between sessions. This parameter is applicable only for some of the data sources that use OAuth 2.0. It is not used in dotConnect for Google BigQuery. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyGets or sets a value indicating whether queries use the legacy SQL dialect of Google BigQuery instead of GoogleSQL. The default value is false.  
    Public PropertyGets or sets the value of the User-Agent HTTP header sent to the service. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyIndicates whether all the datetime values retrieved from the data source are returned as UTC values or converted to local time, and whether date values, specified on the application side (for example, in SQL statements) are considered UTC or local. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public PropertyCollection of values in the Devart.Data.SqlShimConnectionStringBuilder. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Top
    Public Methods
     NameDescription
    Public Method (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodSets all Devart.Data.SqlShimConnectionStringBuilder properties to default values. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public MethodIndicates whether specified key is set in the Devart.Data.SqlShimConnectionStringBuilder object. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public MethodOverloaded. Overridden. Returns a value indicating whether this BigQueryConnectionStringBuilder has same parameters as given DbConnectionStringBuilder.  
    Public MethodSets value of the specified key to default. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public MethodDetermines whether the key will be serialized if required. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Public Method (Inherited from System.Data.Common.DbConnectionStringBuilder)
    Public MethodAttempts to get a key value. (Inherited from Devart.Data.SqlShimConnectionStringBuilder)
    Top
    See Also