Class SqlType

Namespace

LinqToDB.DataProvider.SqlServer

Assembly

linq2db.dll

See Data types.

public abstract class SqlType

Inheritance

object

SqlType

Derived

SqlType<T>

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Constructors

SqlType(string)

protected SqlType(string dataType)

Parameters

dataType string

Properties

BigInt

public static SqlType<long?> BigInt { get; }

Property Value

SqlType<long?>

BinaryMax

public static SqlType<byte[]?> BinaryMax { get; }

Property Value

SqlType<byte[]>

Bit

public static SqlType<bool?> Bit { get; }

Property Value

SqlType<bool?>

CharMax

public static SqlType<string?> CharMax { get; }

Property Value

SqlType<string>

Cursor

public static SqlType<object?> Cursor { get; }

Property Value

SqlType<object>

Date

public static SqlType<DateTime?> Date { get; }

Property Value

SqlType<DateTime?>

Datetime

public static SqlType<DateTime?> Datetime { get; }

Property Value

SqlType<DateTime?>

Image

public static SqlType<byte[]?> Image { get; }

Property Value

SqlType<byte[]>

Int

public static SqlType<int?> Int { get; }

Property Value

SqlType<int?>

Money

public static SqlType<decimal?> Money { get; }

Property Value

SqlType<decimal?>

NCharMax

public static SqlType<string?> NCharMax { get; }

Property Value

SqlType<string>

NText

public static SqlType<string?> NText { get; }

Property Value

SqlType<string>

NVarCharMax

public static SqlType<string?> NVarCharMax { get; }

Property Value

SqlType<string>

Real

public static SqlType<float?> Real { get; }

Property Value

SqlType<float?>

RowVersion

public static SqlType<byte[]?> RowVersion { get; }

Property Value

SqlType<byte[]>

SmallDatetime

public static SqlType<DateTime?> SmallDatetime { get; }

Property Value

SqlType<DateTime?>

SmallInt

public static SqlType<short?> SmallInt { get; }

Property Value

SqlType<short?>

SmallMoney

public static SqlType<decimal?> SmallMoney { get; }

Property Value

SqlType<decimal?>

SqlVariant

public static SqlType<object?> SqlVariant { get; }

Property Value

SqlType<object>

Table

public static SqlType<object?> Table { get; }

Property Value

SqlType<object>

Text

public static SqlType<string?> Text { get; }

Property Value

SqlType<string>

TinyInt

public static SqlType<byte?> TinyInt { get; }

Property Value

SqlType<byte?>

UniqueIdentifier

public static SqlType<Guid?> UniqueIdentifier { get; }

Property Value

SqlType<Guid?>

VarBinaryMax

public static SqlType<byte[]?> VarBinaryMax { get; }

Property Value

SqlType<byte[]>

VarCharMax

public static SqlType<string?> VarCharMax { get; }

Property Value

SqlType<string>

Methods

Binary()

public static SqlType<byte[]?> Binary()

Returns

SqlType<byte[]>

Binary(int)

public static SqlType<byte[]?> Binary(int size)

Parameters

size int

Returns

SqlType<byte[]>

Char()

public static SqlType<string?> Char()

Returns

SqlType<string>

Char(int)

public static SqlType<string?> Char(int size)

Parameters

size int

Returns

SqlType<string>

Datetime2()

public static SqlType<DateTime?> Datetime2()

Returns

SqlType<DateTime?>

Datetime2(int)

public static SqlType<DateTime?> Datetime2(int size)

Parameters

size int

Returns

SqlType<DateTime?>

DatetimeOffset()

public static SqlType<DateTimeOffset?> DatetimeOffset()

Returns

SqlType<DateTimeOffset?>

DatetimeOffset(int)

public static SqlType<DateTimeOffset?> DatetimeOffset(int size)

Parameters

size int

Returns

SqlType<DateTimeOffset?>

Decimal()

public static SqlType<decimal?> Decimal()

Returns

SqlType<decimal?>

Decimal(int)

public static SqlType<decimal?> Decimal(int precision)

Parameters

precision int

Returns

SqlType<decimal?>

Decimal(int, int)

public static SqlType<decimal?> Decimal(int precision, int scale)

Parameters

precision int

scale int

Returns

SqlType<decimal?>

Float()

public static SqlType<double?> Float()

Returns

SqlType<double?>

Float(int)

public static SqlType<double?> Float(int n)

Parameters

n int

Returns

SqlType<double?>

Geography()

public static SqlType<object?> Geography()

Returns

SqlType<object>

Geography<T>()

public static SqlType<T> Geography<T>()

Returns

SqlType<T>

Type Parameters

T

Geometry()

public static SqlType<object?> Geometry()

Returns

SqlType<object>

Geometry<T>()

public static SqlType<T> Geometry<T>()

Returns

SqlType<T>

Type Parameters

T

HierarchyID()

public static SqlType<object?> HierarchyID()

Returns

SqlType<object>

HierarchyID<T>()

public static SqlType<T> HierarchyID<T>()

Returns

SqlType<T>

Type Parameters

T

NChar()

public static SqlType<string?> NChar()

Returns

SqlType<string>

NChar(int)

public static SqlType<string?> NChar(int size)

Parameters

size int

Returns

SqlType<string>

NVarChar()

public static SqlType<string?> NVarChar()

Returns

SqlType<string>

NVarChar(int)

public static SqlType<string?> NVarChar(int size)

Parameters

size int

Returns

SqlType<string>

Numeric()

public static SqlType<decimal?> Numeric()

Returns

SqlType<decimal?>

Numeric(int)

public static SqlType<decimal?> Numeric(int precision)

Parameters

precision int

Returns

SqlType<decimal?>

Numeric(int, int)

public static SqlType<decimal?> Numeric(int precision, int scale)

Parameters

precision int

scale int

Returns

SqlType<decimal?>

Time()

public static SqlType<TimeSpan?> Time()

Returns

SqlType<TimeSpan?>

Time(int)

public static SqlType<TimeSpan?> Time(int size)

Parameters

size int

Returns

SqlType<TimeSpan?>

ToString()

Returns a string that represents the current object.

public override string ToString()

Returns

string

A string that represents the current object.

VarBinary()

public static SqlType<byte[]?> VarBinary()

Returns

SqlType<byte[]>

VarBinary(int)

public static SqlType<byte[]?> VarBinary(int size)

Parameters

size int

Returns

SqlType<byte[]>

VarChar()

public static SqlType<string?> VarChar()

Returns

SqlType<string>

VarChar(int)

public static SqlType<string?> VarChar(int size)

Parameters

size int

Returns

SqlType<string>

Xml()

public static SqlType<string?> Xml()

Returns

SqlType<string>

Xml<T>()

public static SqlType<T> Xml<T>()

Returns

SqlType<T>

Type Parameters

T