C# 클래스 WebApplications.Utilities.Database.Schema.SqlMetaType

파일 보기 프로젝트 열기: webappsuk/CoreLibraries

공개 프로퍼티들

프로퍼티 타입 설명
DbType DbType
FixedLength int
IsFixed bool
IsLong bool
IsPlp bool
NullableType byte
Precision byte
PropBytes byte
Scale byte
SqlDbType SqlDbType
TDSType byte

공개 메소드들

메소드 설명
GetSqlDbTypeFromOleDbType ( OleDbType dbType, string typeName ) : SqlDbType

Gets the type of the SQL db type from OLE db.

Is100Supported ( SqlDbType type ) : bool

Determines whether the type is compatible in SQL Server 2008.

Is70Supported ( SqlDbType type ) : bool

Determines whether the type is compatible in SQL Server 7.0.

Is80Supported ( SqlDbType type ) : bool

Determines whether the type is compatible in SQL Server 2000.

Is90Supported ( SqlDbType type ) : bool

Determines whether the type is compatible in SQL Server 2005.

IsAnsiType ( SqlDbType type ) : bool

TODO

IsBinType ( SqlDbType type ) : bool

Determines whether the type is a binary data type.

IsCharType ( SqlDbType type ) : bool

Determines whether the data type is a character stream.

IsNCharType ( SqlDbType type ) : bool

Determines whether the type can contain Unicode characters.

IsNewKatmaiType ( SqlDbType type ) : bool

Determines whether the type is new from SQL Server 2008 onwards.

IsSizeInCharacters ( SqlDbType type ) : bool

Determines whether the data size can be determined by the number of characters in the type.

IsVarTime ( SqlDbType type ) : bool

Determines whether the specified type is a time type.

비공개 메소드들

메소드 설명
GetCLRValueFromSqlVariant ( object sqlVal ) : object
GetMaxMetaTypeFromMetaType ( [ mt ) : SqlMetaType
GetMetaTypeFromDbType ( DbType target ) : SqlMetaType
GetMetaTypeFromSqlDbType ( SqlDbType target, bool isMultiValued = false ) : SqlMetaType
GetMetaTypeFromType ( Type dataType ) : SqlMetaType
GetMetaTypeFromValue ( Type dataType, object value, bool inferLen ) : SqlMetaType
GetMetaTypeFromValue ( object value ) : SqlMetaType
GetNullSqlValue ( Type sqlType ) : object
GetSqlDataType ( int tdsType, uint userType, int length ) : SqlMetaType
GetSqlValueFromCLRVariant ( object clrVal ) : object
PromoteStringType ( string s ) : SqlMetaType
SqlMetaType ( byte precision, byte scale, int fixedLength, bool isFixed, bool isLong, bool isPlp, byte tdsType, byte nullableTdsType, [ typeName, [ classType, [ sqlType, SqlDbType sqldbType, DbType dbType, byte propBytes ) : System

Initializes a new instance of the SqlMetaType class.

메소드 상세

GetSqlDbTypeFromOleDbType() 공개 정적인 메소드

Gets the type of the SQL db type from OLE db.
public static GetSqlDbTypeFromOleDbType ( OleDbType dbType, string typeName ) : SqlDbType
dbType OleDbType Type of the db.
typeName string Name of the type.
리턴 SqlDbType

Is100Supported() 공개 정적인 메소드

Determines whether the type is compatible in SQL Server 2008.
public static Is100Supported ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

Is70Supported() 공개 정적인 메소드

Determines whether the type is compatible in SQL Server 7.0.
public static Is70Supported ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

Is80Supported() 공개 정적인 메소드

Determines whether the type is compatible in SQL Server 2000.
public static Is80Supported ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

Is90Supported() 공개 정적인 메소드

Determines whether the type is compatible in SQL Server 2005.
public static Is90Supported ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

IsAnsiType() 공개 정적인 메소드

TODO
public static IsAnsiType ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

IsBinType() 공개 정적인 메소드

Determines whether the type is a binary data type.
public static IsBinType ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

IsCharType() 공개 정적인 메소드

Determines whether the data type is a character stream.
public static IsCharType ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

IsNCharType() 공개 정적인 메소드

Determines whether the type can contain Unicode characters.
public static IsNCharType ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

IsNewKatmaiType() 공개 정적인 메소드

Determines whether the type is new from SQL Server 2008 onwards.
public static IsNewKatmaiType ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

IsSizeInCharacters() 공개 정적인 메소드

Determines whether the data size can be determined by the number of characters in the type.
public static IsSizeInCharacters ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

IsVarTime() 공개 정적인 메소드

Determines whether the specified type is a time type.
public static IsVarTime ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
리턴 bool

프로퍼티 상세

DbType 공개적으로 프로퍼티

The equivalent DbType
public DbType DbType
리턴 DbType

FixedLength 공개적으로 프로퍼티

The number of bytes the type is stored in. If this is -1 then the data type is variable-length.
public int FixedLength
리턴 int

IsFixed 공개적으로 프로퍼티

A bool value indicating whether the data type is fixed-length.
public bool IsFixed
리턴 bool

IsLong 공개적으로 프로퍼티

A bool value indicating whether the data type is a large object/value.
public bool IsLong
리턴 bool

IsPlp 공개적으로 프로퍼티

PLP.
public bool IsPlp
리턴 bool

NullableType 공개적으로 프로퍼티

Nullable TDS value.
public byte NullableType
리턴 byte

Precision 공개적으로 프로퍼티

The precision, which is the number of digits in a numerical data type.
public byte Precision
리턴 byte

PropBytes 공개적으로 프로퍼티

Propbytes.
public byte PropBytes
리턴 byte

Scale 공개적으로 프로퍼티

The scale, which is the number of digits to the right of the decimal point.
public byte Scale
리턴 byte

SqlDbType 공개적으로 프로퍼티

The equivalent SqlDbType
public SqlDbType SqlDbType
리턴 SqlDbType

TDSType 공개적으로 프로퍼티

TDS value.
public byte TDSType
리턴 byte