Tablas que resumen las correlaciones de ESQL a .NET.
Tipo de intermediario 1 | Tipo de CLR 1 | Tipo de intermediario 2 | Tipo de CLR 2 |
---|---|---|---|
Integer Not Null | Int64 | Date Not Null | DateTimeOffset |
Integer | Nullable<Int64> | Date | Nullable<DateTimeOffset> |
Int Not Null | Int32 | Time Not Null | TimeSpan |
Int | Nullable<Int32> | Time | Nullable<TimeSpan> |
Decimal Not Null | Decimal | Timestamp Not Null | DateTimeOffset |
Decimal | Nullable<Decimal> | Timestamp | Nullable<DateTimeOffset> |
Float Not Null | Double | Gmttime Not Null | TimeSpan |
Float | Nullable<Double> | Gmttime | Nullable<TimeSpan> |
Bit Not Null | BitArray | Gmttimestamp Not Null | DateTime |
Bit | "" | Gmttimestamp | Nullable<DateTime> |
Blob Not Null | Byte[] | Interval Not Null 1 | TimeSpan |
Blob | "" | Interval 1 | Nullable<TimeSpan> |
Character Not Null | String | Interval YEAR – MONTH | No soportado |
Character | "" | ||
Char Not Null | Char | Reference Not Null | NBElement |
Char | Nullable<Char> | Reference | "" |
Boolean Not Null | Boolean | ||
Boolean | Nullable<Boolean> |
Tipo de intermediario | Tipo C# (In) | Tipo C# (Out) | Tipo C# (Inout) |
---|---|---|---|
Integer Not Null | long | out long | ref long |
Integer | long? | out long? | ref long? |
Int Not Null | int | out int | ref int |
Int | int? | out int? | ref int? |
Decimal Not Null | decimal | out decimal | ref decimal |
Decimal | decimal? | out decimal? | ref decimal? |
Float Not Null | double | out double | ref double |
Float | double? | out double? | ref double? |
Bit Not Null | BitArray | out BitArray | ref BitArray |
Bit | "" | "" | "" |
Blob Not Null | Byte[] | out Byte[] | ref Byte[] |
Blob | "" | "" | "" |
Character Not Null | string | out string | ref string |
Character | "" | "" | "" |
Char Not Null | char | out char | ref char |
Char | char? | out char? | ref char? |
Boolean Not Null | bool | out bool | ref bool |
Boolean | bool? | out bool? | ref bool? |
Date Not Null | DateTimeOffset | out DateTimeOffset | ref DateTimeOffset |
Date | DateTimeOffset? | out DateTimeOffset? | ref DateTimeOffset? |
Time Not Null | TimeSpan | out TimeSpan | ref TimeSpan |
Time | TimeSpan? | out TimeSpan? | ref TimeSpan? |
Timestamp Not Null | DateTimeOffset | out DateTimeOffset | ref DateTimeOffset |
Timestamp | DateTimeOffset? | out DateTimeOffset? | ref DateTimeOffset? |
Gmttime Not Null | TimeSpan | out TimeSpan | ref TimeSpan |
Gmttime | TimeSpan? | out TimeSpan? | ref TimeSpan? |
Gmttimestamp Not Null | DateTime | out DateTime | ref DateTime |
Gmttimestamp | DateTime? | out DateTime? | ref DateTime? |
Interval Not Null 1 | TimeSpan | out TimeSpan | ref TimeSpan |
Interval 1 | TimeSpan? | out TimeSpan? | ref TimeSpan? |
Interval YEAR - MONTH | No soportado | No soportado | No soportado |
Reference Not Null | NBElement | No soportado | ref NBElement |
Reference | "" | "" | "" |
Tipo de intermediario | Tipo VB (In) | Tipo VB (Out) | Tipo VB (Inout) |
---|---|---|---|
Integer Not Null | ByVal Long | <Out()> ByRef Long | ByRef Long |
Integer | ByVal Long? | <Out()> ByRef Long? | ByRef Long? |
Int Not Null | ByVal Integer | <Out()> ByRef Integer | ByRef Integer |
Int | ByVal Integer? | <Out()> ByRef Integer? | ByRef Integer? |
Decimal Not Null | ByVal Decimal | <Out()> ByRef Decimal | ByRef Decimal |
Decimal | ByVal Decimal? | <Out()> ByRef Decimal? | ByRef Decimal? |
Float Not Null | ByVal Double | <Out()> ByRef Double | ByRef Double |
Float | ByVal Double? | <Out()> ByRef Double? | ByRef Double? |
Bit Not Null | ByVal BitArray | <Out()> ByRef BitArray | ByRef BitArray |
Bit | "" | "" | "" |
Blob Not Null | ByVal Byte() | <Out()> ByRef Byte() | ByRef Byte() |
Blob | "" | "" | "" |
Character Not Null | ByVal String | <Out()> ByRef String | ByRef String |
Character | "" | "" | "" |
Char Not Null | ByVal Char | <Out()> ByRef Char | ByRef Char |
Char | ByVal Char? | <Out()> ByRef Char? | ByRef Char? |
Boolean Not Null | ByVal Boolean | <Out()> ByRef Boolean | ByRef Boolean |
Boolean | ByVal Boolean? | <Out()> ByRef Boolean? | ByRef Boolean? |
Date Not Null | ByVal DateTimeOffset | <Out()> ByRef DateTimeOffset | ByRef DateTimeOffset |
Date | ByVal DateTimeOffset? | <Out()> ByRef DateTimeOffset? | ByRef DateTimeOffset? |
Time Not Null | ByVal TimeSpan | <Out()> ByRef TimeSpan | ByRef TimeSpan |
Time | ByVal TimeSpan? | <Out()> ByRef TimeSpan? | ByRef TimeSpan? |
Timestamp Not Null | ByVal DateTimeOffset | <Out()> ByRef DateTimeOffset | ByRef DateTimeOffset |
Timestamp | ByVal DateTimeOffset? | <Out()> ByRef DateTimeOffset? | ByRef DateTimeOffset? |
Gmttime Not Null | ByVal TimeSpan | <Out()> ByRef TimeSpan | ByRef TimeSpan |
Gmttime | ByVal TimeSpan? | <Out()> ByRef TimeSpan? | ByRef TimeSpan? |
Gmttimestamp Not Null | ByVal DateTime | <Out()> ByRef DateTime | ByRef DateTime |
Gmttimestamp | ByVal DateTime? | <Out()> ByRef DateTime? | ByRef DateTime? |
Interval Not Null 1 | ByVal TimeSpan | <Out()> ByRef TimeSpan | ByRef TimeSpan |
Interval 1 | ByVal TimeSpan? | <Out()> ByRef TimeSpan? | ByRef TimeSpan? |
Interval YEAR - MONTH | No soportado | No soportado | No soportado |
Reference Not Null | ByVal NBElement | No soportado | ByRef NBElement |
Reference |
Tipo de intermediario | Tipo F# (In) | Tipo F# (Out) | Tipo F# (Inout) |
---|---|---|---|
Integer Not Null | int64 | [<Out>] byref<int64> | byref<int64> |
Integer | Nullable<int64> | [<Out>] byref<Nullable<int64>> | byref<Nullable<int64>> |
Int Not Null | int | [<Out>] byref<int> | byref<int> |
Int | Nullable<int> | [<Out>] byref<Nullable<int>> | byref<Nullable<int>> |
Decimal Not Null | decimal | [<Out>] byref<decimal> | byref<decimal> |
Decimal | Nullable<decimal> | [<Out>] byref<Nullable<decimal>> | byref<Nullable<decimal>> |
Float Not Null | double | [<Out>] byref<double> | byref<double> |
Float | Nullable<double> | [<Out>] byref<Nullable<double>> | byref<Nullable<double>> |
Bit Not Null | BitArray | [<Out>] byref<BitArray> | byref<BitArray> |
Bit | "" | "" | "" |
Blob Not Null | byte[] | [<Out>] byref<byte[]> | byref<byte[]> |
Blob | "" | "" | "" |
Character Not Null | char | [<Out>] byref<char> | byref<char> |
Character | "" | "" | "" |
Char Not Null | string | [<Out>] byref<string> | byref<string> |
Char | Nullable<char> | [<Out>] byref<Nullable<char>> | byref<Nullable<char>> |
Boolean Not Null | bool | [<Out>] byref<bool> | byref<bool> |
Boolean | Nullable<bool> | [<Out>] byref<Nullable<bool>> | byref<Nullable<bool>> |
Date Not Null | DateTimeOffset | [<Out>] byref<DateTimeOffset> | byref<DateTimeOffset> |
Date | Nullable<DateTimeOffset> | [<Out>] byref<Nullable<DateTimeOffset>> | byref<Nullable<DateTimeOffset>> |
Time Not Null | TimeSpan | [<Out>] byref<TimeSpan> | byref<TimeSpan> |
Time | Nullable<TimeSpan> | [<Out>] byref <Nullable<TimeSpan>> | byref<Nullable<TimeSpan>> |
Timestamp Not Null | DateTimeOffset | [<Out>] byref<DateTimeOffset> | byref<DateTimeOffset> |
Timestamp | Nullable<DateTimeOffset> | [<Out>] byref<Nullable<DateTimeOffset>> | byref<Nullable<DateTimeOffset>> |
Gmttime Not Null | TimeSpan | [<Out>] byref<TimeSpan> | byref<TimeSpan> |
Gmttime | Nullable<TimeSpan> | [<Out>] byref<Nullable<TimeSpan>> | byref<Nullable<TimeSpan>> |
Gmttimestamp Not Null | DateTime | [<Out>] byref<DateTime> | byref<DateTime> |
Gmttimestamp | Nullable<DateTime> | [<Out>] byref<Nullable<DateTime>> | byref<Nullable<DateTime>> |
Interval Not Null 1 | TimeSpan | [<Out>] byref<TimeSpan> | byref<TimeSpan> |
Interval 1 | Nullable<TimeSpan> | [<Out>] byref<Nullable<TimeSpan>> | byref<Nullable<TimeSpan>> |
Interval YEAR - MONTH | No soportado | No soportado | No soportado |
Reference Not Null | NBElement | No soportado | byref<NBElement> |
Reference | "" | "" | "" |
Tipo de intermediario | Tipo CPP (In) | Tipo CPP (Out) | Tipo CPP (Inout) |
---|---|---|---|
Integer Not Null | long long | [Out] long long% | long long% |
Integer | Nullable<long long> | [Out] Nullable<long long>% | Nullable<long long>% |
Int Not Null | int | [Out] int% | int% |
Int | Nullable<int> | [Out] Nullable<int>% | Nullable<int>% |
Decimal Not Null | Decimal | [Out] Decimal% | Decimal% |
Decimal | Nullable<Decimal> | [Out] Nullable<Decimal>% | Nullable<Decimal>% |
Float Not Null | double | [Out] double% | double% |
Float | Nullable<double> | [Out] Nullable<double>% | Nullable<double>% |
Bit Not Null | BitArray^ | [Out] BitArray^% | BitArray^% |
Bit | "" | "" | "" |
Blob Not Null | array<unsigned char>^ | [Out] array<unsigned char>^% | array<unsigned char>^% |
Blob | "" | "" | "" |
Character Not Null | String^ | [Out] String^% | String^% |
Character | "" | "" | "" |
Char Not Null | wchar_t | [Out] wchar_t% | wchar_t% |
Char | Nullable<wchar_t> | [Out] Nullable<wchar_t>% | Nullable<wchar_t>% |
Boolean Not Null | bool | [Out] bool% | bool% |
Boolean | Nullable<bool> | [Out] Nullable<bool>% | Nullable<bool>% |
Date Not Null | DateTimeOffset | [Out] DateTimeOffset% | DateTimeOffset% |
Date | Nullable<DateTimeOffset> | [Out] Nullable<DateTimeOffset>% | Nullable<DateTimeOffset>% |
Time Not Null | TimeSpan | [Out] TimeSpan% | TimeSpan% |
Time | Nullable<TimeSpan> | [Out] Nullable<TimeSpan>% | Nullable<TimeSpan>% |
Timestamp Not Null | DateTimeOffset | [Out] DateTimeOffset% | DateTimeOffset% |
Timestamp | Nullable<DateTimeOffset> | [Out] Nullable<DateTimeOffset>% | Nullable<DateTimeOffset>% |
Gmttime Not Null | TimeSpan | [Out] TimeSpan% | TimeSpan% |
Gmttime | Nullable<TimeSpan> | [Out] Nullable<TimeSpan>% | Nullable<TimeSpan>% |
Gmttimestamp Not Null | DateTime | [Out] DateTime% | DateTime% |
Gmttimestamp | Nullable<DateTime> | [Out] Nullable<DateTime>% | Nullable<DateTime>% |
Interval Not Null 1 | TimeSpan | [Out] TimeSpan% | TimeSpan% |
Interval 1 | Nullable<TimeSpan> | [Out] Nullable<TimeSpan>% | Nullable<TimeSpan>% |
Interval YEAR - MONTH | No soportado | No soportado | No soportado |
Reference | NBElement^ | No soportado | NBElement^% |
"" | "" | "" |
Tipo de intermediario 1 | Tipo de JScript 1 | Tipo de intermediario 2 | Tipo de JScript 2 |
---|---|---|---|
Integer Not Null | long | Date Not Null | DateTimeOffset |
Int Not Null | int | Time Not Null | TimeSpan |
Decimal Not Null | decimal | Timestamp Not Null | DateTimeOffset |
Float Not Null | double | Gmttime Not Null | TimeSpan |
Bit Not Null | BitArray | Gmttimestamp Not Null | DateTime |
Blob Not Null | byte[] | Interval Not Null 1 | TimeSpan |
Character Not Null | String | Interval YEAR - MONTH | No soportado |
Char Not Null | Char | Reference Not Null | NBElement |
Boolean Not Null | boolean |
Las variables que se declaran como CONSTANT (o las referencias a las variables que se declaran como CONSTANT) no pueden tener la dirección INOUT u OUT.
Si un valor que es demasiado grande para el tipo de datos .NET se pasa como parámetro a una rutina .NET, se emite una excepción. Esta excepción se puede producir en el caso de que a un parámetro INT se le pase un valor mayor que el valor signed int .NET más grande (2^31-1) o en el caso de que a un parámetro CHAR se le pase más de un carácter.
Si un valor NULL se pasa como parámetro a una rutina .NET en la que el parámetro está marcado como NOT NULL, se emite una excepción.
Se puede utilizar una referencia (REFERENCE) a una variable escalar en la llamada (CALL) de un método, si el tipo de datos de la variable a la que la referencia hace referencia coincide con el tipo de datos de la firma de método .NET.