dotConnect for Google BigQuery Documentation
Devart.Data.BigQuery Namespace / BigQueryType Enumeration

On this page
    BigQueryType Enumeration
    On this page
    Specifies the Google BigQuery data type of a parameter or a column.
    Syntax
    'Declaration
     
    Public Enum BigQueryType 
       Inherits System.Enum
       Implements System.IComparable, System.IConvertible, System.IFormattable 
    Members
    MemberDescription
    BigNumericThe BIGNUMERIC (BIGDECIMAL) type. Mapped to System.Decimal.
    BinaryThe BYTES type. Mapped to System.Byte[].
    BooleanThe BOOL type. Mapped to System.Boolean.
    DateThe DATE type. Mapped to System.DateTime.
    DateTimeThe DATETIME type. Mapped to System.DateTime.
    DoubleThe FLOAT64 type. Mapped to System.Double.
    GeographyThe GEOGRAPHY type. Mapped to System.String that contains the value in the WKT format, for example, POINT(1 2).
    IntegerThe INT64 type (aliases: INT, SMALLINT, INTEGER, BIGINT, TINYINT, BYTEINT). Mapped to System.Int64.
    IntervalThe INTERVAL type. Mapped to System.String, for example, 1-2 3 4:5:6.789.
    JsonThe JSON type. Mapped to System.String.
    NumericThe NUMERIC (DECIMAL) type. Mapped to System.Decimal.
    RangeThe RANGE<T> type, where T is DATE, DATETIME, or TIMESTAMP. The type of the range elements is specified by the BigQueryParameter.RangeElementType property. Mapped to System.String, for example, [2024-01-01, 2024-12-31).
    RecordThe STRUCT (RECORD) type. A struct is not returned as a single column: each field of the struct becomes a separate column named struct_name.field_name and is mapped by its own type.
    StringThe STRING type. Mapped to System.String.
    TimeThe TIME type. Mapped to System.TimeSpan.
    TimestampThe TIMESTAMP type. Mapped to System.DateTimeOffset.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             Devart.Data.BigQuery.BigQueryType

    See Also