C# Class WebApplications.Utilities.Database.Schema.SqlMetaType

Afficher le fichier Open project: webappsuk/CoreLibraries

Méthodes publiques

Свойство Type Description
DbType DbType
FixedLength int
IsFixed bool
IsLong bool
IsPlp bool
NullableType byte
Precision byte
PropBytes byte
Scale byte
SqlDbType SqlDbType
TDSType byte

Méthodes publiques

Méthode Description
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.

Private Methods

Méthode Description
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.

Method Details

GetSqlDbTypeFromOleDbType() public static méthode

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.
Résultat SqlDbType

Is100Supported() public static méthode

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

Is70Supported() public static méthode

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

Is80Supported() public static méthode

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

Is90Supported() public static méthode

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

IsAnsiType() public static méthode

TODO
public static IsAnsiType ( SqlDbType type ) : bool
type SqlDbType The SQL type to check.
Résultat bool

IsBinType() public static méthode

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

IsCharType() public static méthode

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

IsNCharType() public static méthode

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

IsNewKatmaiType() public static méthode

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

IsSizeInCharacters() public static méthode

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.
Résultat bool

IsVarTime() public static méthode

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

Property Details

DbType public_oe property

The equivalent DbType
public DbType DbType
Résultat DbType

FixedLength public_oe property

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

IsFixed public_oe property

A bool value indicating whether the data type is fixed-length.
public bool IsFixed
Résultat bool

IsLong public_oe property

A bool value indicating whether the data type is a large object/value.
public bool IsLong
Résultat bool

IsPlp public_oe property

PLP.
public bool IsPlp
Résultat bool

NullableType public_oe property

Nullable TDS value.
public byte NullableType
Résultat byte

Precision public_oe property

The precision, which is the number of digits in a numerical data type.
public byte Precision
Résultat byte

PropBytes public_oe property

Propbytes.
public byte PropBytes
Résultat byte

Scale public_oe property

The scale, which is the number of digits to the right of the decimal point.
public byte Scale
Résultat byte

SqlDbType public_oe property

The equivalent SqlDbType
public SqlDbType SqlDbType
Résultat SqlDbType

TDSType public_oe property

TDS value.
public byte TDSType
Résultat byte