Class SqlDataType

Inheritance
System.Object
SqlDataType
Implements
IEquatable<ISqlExpression>
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

IEquatable<>
IEquatable<>

Extension Methods