Search Results for

    Show / Hide Table of Contents

    Class SqlDataType

    Inheritance
    System.Object
    SqlDataType
    Implements
    ISqlExpression
    IQueryElement
    IEquatable<ISqlExpression>
    ISqlExpressionWalkable
    IEquatable<SqlDataType>
    Namespace: LinqToDB.SqlQuery
    Assembly: linq2db.dll
    Syntax
    public class SqlDataType : object, ISqlExpression, IQueryElement, ISqlExpressionWalkable

    Constructors

    | Improve this Doc View Source

    SqlDataType(DbDataType)

    Declaration
    public SqlDataType(DbDataType dataType)
    Parameters
    Type Name Description
    DbDataType dataType
    | Improve this Doc View Source

    SqlDataType(DataType)

    Declaration
    public SqlDataType(DataType dataType)
    Parameters
    Type Name Description
    DataType dataType
    | Improve this Doc View Source

    SqlDataType(DataType, Nullable<Int32>)

    Declaration
    public SqlDataType(DataType dataType, int? length)
    Parameters
    Type Name Description
    DataType dataType
    System.Nullable<System.Int32> length
    | Improve this Doc View Source

    SqlDataType(DataType, Type)

    Declaration
    public SqlDataType(DataType dataType, Type type)
    Parameters
    Type Name Description
    DataType dataType
    Type type
    | Improve this Doc View Source

    SqlDataType(DataType, Type, Int32)

    Declaration
    public SqlDataType(DataType dataType, Type type, int length)
    Parameters
    Type Name Description
    DataType dataType
    Type type
    System.Int32 length
    | Improve this Doc View Source

    SqlDataType(DataType, Type, Int32, Int32)

    Declaration
    public SqlDataType(DataType dataType, Type type, int precision, int scale)
    Parameters
    Type Name Description
    DataType dataType
    Type type
    System.Int32 precision
    System.Int32 scale
    | Improve this Doc View Source

    SqlDataType(DataType, Type, String)

    Declaration
    public SqlDataType(DataType dataType, Type type, string dbType)
    Parameters
    Type Name Description
    DataType dataType
    Type type
    System.String dbType

    Fields

    | Improve this Doc View Source

    Boolean

    Declaration
    public static readonly SqlDataType Boolean
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Byte

    Declaration
    public static readonly SqlDataType Byte
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    ByteArray

    Declaration
    public static readonly SqlDataType ByteArray
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Char

    Declaration
    public static readonly SqlDataType Char
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    CharArray

    Declaration
    public static readonly SqlDataType CharArray
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DateTime

    Declaration
    public static readonly SqlDataType DateTime
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DateTimeOffset

    Declaration
    public static readonly SqlDataType DateTimeOffset
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbBinary

    Declaration
    public static readonly SqlDataType DbBinary
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbBinaryJson

    Declaration
    public static readonly SqlDataType DbBinaryJson
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbBitArray

    Declaration
    public static readonly SqlDataType DbBitArray
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbBoolean

    Declaration
    public static readonly SqlDataType DbBoolean
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbByte

    Declaration
    public static readonly SqlDataType DbByte
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbChar

    Declaration
    public static readonly SqlDataType DbChar
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbDate

    Declaration
    public static readonly SqlDataType DbDate
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbDateTime

    Declaration
    public static readonly SqlDataType DbDateTime
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbDateTime2

    Declaration
    public static readonly SqlDataType DbDateTime2
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbDateTimeOffset

    Declaration
    public static readonly SqlDataType DbDateTimeOffset
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbDecFloat

    Declaration
    public static readonly SqlDataType DbDecFloat
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbDecimal

    Declaration
    public static readonly SqlDataType DbDecimal
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbDictionary

    Declaration
    public static readonly SqlDataType DbDictionary
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbDouble

    Declaration
    public static readonly SqlDataType DbDouble
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbGuid

    Declaration
    public static readonly SqlDataType DbGuid
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbImage

    Declaration
    public static readonly SqlDataType DbImage
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbInt128

    Declaration
    public static readonly SqlDataType DbInt128
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbInt16

    Declaration
    public static readonly SqlDataType DbInt16
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbInt32

    Declaration
    public static readonly SqlDataType DbInt32
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbInt64

    Declaration
    public static readonly SqlDataType DbInt64
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbJson

    Declaration
    public static readonly SqlDataType DbJson
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbMoney

    Declaration
    public static readonly SqlDataType DbMoney
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbNChar

    Declaration
    public static readonly SqlDataType DbNChar
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbNText

    Declaration
    public static readonly SqlDataType DbNText
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbNVarChar

    Declaration
    public static readonly SqlDataType DbNVarChar
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbSByte

    Declaration
    public static readonly SqlDataType DbSByte
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbSingle

    Declaration
    public static readonly SqlDataType DbSingle
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbSmallDateTime

    Declaration
    public static readonly SqlDataType DbSmallDateTime
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbSmallMoney

    Declaration
    public static readonly SqlDataType DbSmallMoney
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbText

    Declaration
    public static readonly SqlDataType DbText
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbTime

    Declaration
    public static readonly SqlDataType DbTime
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbTimestamp

    Declaration
    public static readonly SqlDataType DbTimestamp
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbTimeTZ

    Declaration
    public static readonly SqlDataType DbTimeTZ
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbUdt

    Declaration
    public static readonly SqlDataType DbUdt
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbUInt16

    Declaration
    public static readonly SqlDataType DbUInt16
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbUInt32

    Declaration
    public static readonly SqlDataType DbUInt32
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbUInt64

    Declaration
    public static readonly SqlDataType DbUInt64
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbVarBinary

    Declaration
    public static readonly SqlDataType DbVarBinary
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbVarChar

    Declaration
    public static readonly SqlDataType DbVarChar
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbVariant

    Declaration
    public static readonly SqlDataType DbVariant
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    DbXml

    Declaration
    public static readonly SqlDataType DbXml
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Decimal

    Declaration
    public static readonly SqlDataType Decimal
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Double

    Declaration
    public static readonly SqlDataType Double
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Guid

    Declaration
    public static readonly SqlDataType Guid
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Int16

    Declaration
    public static readonly SqlDataType Int16
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Int32

    Declaration
    public static readonly SqlDataType Int32
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    LinqBinary

    Declaration
    public static readonly SqlDataType LinqBinary
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SByte

    Declaration
    public static readonly SqlDataType SByte
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Single

    Declaration
    public static readonly SqlDataType Single
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlBinary

    Declaration
    public static readonly SqlDataType SqlBinary
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlBoolean

    Declaration
    public static readonly SqlDataType SqlBoolean
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlByte

    Declaration
    public static readonly SqlDataType SqlByte
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlBytes

    Declaration
    public static readonly SqlDataType SqlBytes
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlChars

    Declaration
    public static readonly SqlDataType SqlChars
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlDateTime

    Declaration
    public static readonly SqlDataType SqlDateTime
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlDecimal

    Declaration
    public static readonly SqlDataType SqlDecimal
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlDouble

    Declaration
    public static readonly SqlDataType SqlDouble
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlGuid

    Declaration
    public static readonly SqlDataType SqlGuid
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlInt16

    Declaration
    public static readonly SqlDataType SqlInt16
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlInt32

    Declaration
    public static readonly SqlDataType SqlInt32
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlInt64

    Declaration
    public static readonly SqlDataType SqlInt64
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlMoney

    Declaration
    public static readonly SqlDataType SqlMoney
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlSingle

    Declaration
    public static readonly SqlDataType SqlSingle
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlString

    Declaration
    public static readonly SqlDataType SqlString
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    SqlXml

    Declaration
    public static readonly SqlDataType SqlXml
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    String

    Declaration
    public static readonly SqlDataType String
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    TimeSpan

    Declaration
    public static readonly SqlDataType TimeSpan
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    UInt16

    Declaration
    public static readonly SqlDataType UInt16
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    UInt32

    Declaration
    public static readonly SqlDataType UInt32
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    UInt64

    Declaration
    public static readonly SqlDataType UInt64
    Field Value
    Type Description
    SqlDataType
    | Improve this Doc View Source

    Undefined

    Declaration
    public static readonly SqlDataType Undefined
    Field Value
    Type Description
    SqlDataType

    Properties

    | Improve this Doc View Source

    CanBeNull

    Declaration
    public bool CanBeNull { get; }
    Property Value
    Type Description
    System.Boolean
    | Improve this Doc View Source

    ElementType

    Declaration
    public QueryElementType ElementType { get; }
    Property Value
    Type Description
    QueryElementType
    | Improve this Doc View Source

    IsCharDataType

    Declaration
    public bool IsCharDataType { get; }
    Property Value
    Type Description
    System.Boolean
    | Improve this Doc View Source

    Precedence

    Declaration
    public int Precedence { get; }
    Property Value
    Type Description
    System.Int32
    | Improve this Doc View Source

    SystemType

    Declaration
    public Type SystemType { get; }
    Property Value
    Type Description
    Type
    | Improve this Doc View Source

    Type

    Declaration
    public DbDataType Type { get; }
    Property Value
    Type Description
    DbDataType

    Methods

    | Improve this Doc View Source

    Equals(ISqlExpression, Func<ISqlExpression, ISqlExpression, Boolean>)

    Declaration
    public bool Equals(ISqlExpression other, Func<ISqlExpression, ISqlExpression, bool> comparer)
    Parameters
    Type Name Description
    ISqlExpression other
    Func<ISqlExpression, ISqlExpression, System.Boolean> comparer
    Returns
    Type Description
    System.Boolean
    | Improve this Doc View Source

    Equals(SqlDataType)

    Declaration
    public bool Equals(SqlDataType other)
    Parameters
    Type Name Description
    SqlDataType other
    Returns
    Type Description
    System.Boolean
    | Improve this Doc View Source

    Equals(Nullable<Object>)

    Declaration
    public override bool Equals(object? obj)
    Parameters
    Type Name Description
    System.Nullable<System.Object> obj
    Returns
    Type Description
    System.Boolean
    | Improve this Doc View Source

    GetDataType(DataType)

    Declaration
    public static SqlDataType GetDataType(DataType type)
    Parameters
    Type Name Description
    DataType type
    Returns
    Type Description
    SqlDataType
    | Improve this Doc View Source

    GetHashCode()

    Declaration
    public override int GetHashCode()
    Returns
    Type Description
    System.Int32
    | Improve this Doc View Source

    GetMaxDisplaySize(DataType)

    Declaration
    public static int? GetMaxDisplaySize(DataType dbType)
    Parameters
    Type Name Description
    DataType dbType
    Returns
    Type Description
    System.Nullable<System.Int32>
    | Improve this Doc View Source

    GetMaxLength(DataType)

    Declaration
    public static int? GetMaxLength(DataType dbType)
    Parameters
    Type Name Description
    DataType dbType
    Returns
    Type Description
    System.Nullable<System.Int32>
    | Improve this Doc View Source

    GetMaxPrecision(DataType)

    Declaration
    public static int? GetMaxPrecision(DataType dbType)
    Parameters
    Type Name Description
    DataType dbType
    Returns
    Type Description
    System.Nullable<System.Int32>
    | Improve this Doc View Source

    GetMaxScale(DataType)

    Declaration
    public static int? GetMaxScale(DataType dbType)
    Parameters
    Type Name Description
    DataType dbType
    Returns
    Type Description
    System.Nullable<System.Int32>
    | Improve this Doc View Source

    TypeCanBeNull(Type)

    Declaration
    public static bool TypeCanBeNull(Type type)
    Parameters
    Type Name Description
    Type type
    Returns
    Type Description
    System.Boolean

    Explicit Interface Implementations

    | Improve this Doc View Source

    IQueryElement.ToString(StringBuilder, Dictionary<IQueryElement, IQueryElement>)

    Declaration
    StringBuilder IQueryElement.ToString(StringBuilder sb, Dictionary<IQueryElement, IQueryElement> dic)
    Parameters
    Type Name Description
    StringBuilder sb
    Dictionary<IQueryElement, IQueryElement> dic
    Returns
    Type Description
    StringBuilder
    | Improve this Doc View Source

    ISqlExpressionWalkable.Walk<TContext>(WalkOptions, TContext, Func<TContext, ISqlExpression, ISqlExpression>)

    Declaration
    ISqlExpression ISqlExpressionWalkable.Walk<TContext>(WalkOptions options, TContext context, Func<TContext, ISqlExpression, ISqlExpression> func)
    Parameters
    Type Name Description
    WalkOptions options
    TContext context
    Func<TContext, ISqlExpression, ISqlExpression> func
    Returns
    Type Description
    ISqlExpression
    Type Parameters
    Name Description
    TContext

    Implements

    ISqlExpression
    IQueryElement
    IEquatable<>
    ISqlExpressionWalkable
    IEquatable<>

    Extension Methods

    Map.DeepCopy<T>(T)
    Sql.IsDistinctFrom<T>(T, T)
    Sql.IsNotDistinctFrom<T>(T, T)
    SqlExtensions.In<T>(T, IEnumerable<T>)
    SqlExtensions.In<T>(T, IQueryable<T>)
    SqlExtensions.In<T>(T, T[])
    SqlExtensions.In<T>(T, T, T)
    SqlExtensions.In<T>(T, T, T, T)
    SqlExtensions.NotIn<T>(T, IEnumerable<T>)
    SqlExtensions.NotIn<T>(T, IQueryable<T>)
    SqlExtensions.NotIn<T>(T, T[])
    SqlExtensions.NotIn<T>(T, T, T)
    SqlExtensions.NotIn<T>(T, T, T, T)
    • Improve this Doc
    • View Source
    In This Article
    Back to top Copyright © 2011-2022 linq2db.com

    Generated by DocFX