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.