Parameters in connections
When using parameters in a connection and transmitting them using the connection wizard, the parameters have a string data type. Not all connections can correctly convert it to a type that the database can accept. Therefore, for some connections, functions have been added that convert string values to other data types supported by connection libraries. The following are the types the string is converted to based on the type of parameter. If it is necessary to assign a type to a parameter value that is not contained in the tables below, or is not implemented, then this can only be done programmatically.
PostgresDataConnection
| NpgsqlDbType Type | C# Type | Example/Format |
|-------------------|-------------------|--------------------------------------------|
| Bigint | long | `123456` |
| Money | decimal | `123456` |
| Numeric | decimal | `123456` |
| Integer | int | `123456` |
| Oid | uint | `123456` |
| Xid | uint | `123456` |
| Cid | uint | `123456` |
| Smallint | short | `123456` |
| InternalChar | byte | `123456` |
| Real | float | `123456.12` |
| Double | double | `123456.12` |
| Boolean | bool | `True` or '1' |
| Bit | string | `1` |
| Timestamp | DateTime | '12:15:12' |
| TimestampTZ | DateTime | '12:15:12' |
| Date | DateTime | '16/02/2008' |
| Time | TimeSpan | `6:12:14` |
| Interval | TimeSpan | `6:12:14` |
| TimeTZ | DateTimeOffset | `05/01/2008` |
| Uuid | Guid | `81a130d2-502f-4cf1-a376-63edeb000e9f` |
| Box | NpgsqlBox | `((x1,y1),(x2,y2)) |
| Circle | NpgsqlCircle | <(x,y),r> (center point and radius) |
| Line | NpgsqlLine | {A,B,C} |
| Polygon | NpgsqlPolygon | ((x1,y1),...) |
| Path | NpgsqlPath | ((x1,y1),...) |
| LSeg | NpgsqlLSeg | ((x1,y1),(x2,y2)) |
| Point | NpgsqlPoint | (x,y) |
| Cidr | NpgsqlCidr | `192.168.100.128/25` IP address with mask |
| Inet | NpgsqlInet | `192.168.100.128/25` IP address |
| MacAddr | PhysicalAddress | '08:00:2b:01:02:03' |
| TsQuery | NpgsqlTsQuery | 'fat & rat' |
| TsVector | NpgsqlTsVector | 'a fat cat sat on a mat and ate a fat rat' |
| Char | string | `a` single char |
| Text | string | 'string' |
| Varchar | string | 'string' |
| Name | string | 'string' |
| Citext | string | 'string' |
| Bytea | string | `12AA` hex string |
| Varbit | string | `01101` bit string |
| Tid | NpgsqlTid | '12345, 123' uint number and ushort number |
| Array | --- | Not implemented |
| Range | --- | Not implemented |
| Hstore | --- | Not implemented |
| Oidvector | --- | Not implemented |
| MacAddr8 | --- | Not implemented |
| Int2Vector | --- | Not implemented |
MySqlDataConnection
| MySqlDbType Type | C# Type | Example |
|------------------|------------------|----------------------------------------|
| Int64 | long | `123456` |
| UInt64 | ulong | `123456` |
| Int32 | int | `123456` |
| Int24 | int | `123456` |
| UInt24 | uint | `123456` |
| UInt32 | uint | `123456` |
| Int16 | short | `123456` |
| UInt16 | ushort | `123456` |
| Decimal | decimal | `123456` |
| NewDecimal | decimal | `123456` |
| Byte | sbyte | `12345` |
| UByte | byte | `12345` |
| Year | byte | `1901` |
| Float | float | `123456.12` |
| Double | double | `123456.12` |
| Bit | bool | `True` or '1' bool |
| Bool | bool | `True` or '1' bool |
| DateTime | DateTime | '16/02/2008 12:15:12' |
| Date | DateTime | '16/02/2008' |
| Newdate | DateTime | '16/02/2008' |
| Time | DateTime | `6:12:14` |
| Timestamp | DateTime | '16/02/2008 12:15:12' |
| Timestamp | DateTime | '16/02/2008 12:15:12' |
| Guid | Guid | `81a130d2-502f-4cf1-a376-63edeb000e9f` |
| VarChar | string | 'string' |
| String | string | 'string' |
| TinyText | string | 'string' |
| MediumText | string | 'string' |
| LongText | string | 'string' |
| Text | string | 'string' |
| VarString | string | 'string' |
| JSON | string | 'string' |
| Enum | string | 'string' |
| Binary | byte[] | `12AA` hex string |
| VarBinary | byte[] | `12AA` hex string |
| Blob | byte[] | `12AA` hex string |
| TinyBlob | byte[] | `12AA` hex string |
| MediumBlob | byte[] | `12AA` hex string |
| LongBlob | byte[] | `12AA` hex string |
| Null | DBNull | |
| Set | --- | Not implemented |
| Geometry | --- | Not implemented |
ClickHouseDataConnection
| ClickHouse Type | C# Type | Example |
|-----------------|----------------|------------------------------------------------------|
| Enum8 | sbyte | `123456` |
| Int8 | sbyte | `123456` |
| Enum16 | short | `123456` |
| Int16 | short | `123456` |
| Int32 | int | `123456` |
| Int64 | long | `123456` |
| Decimal | decimal | `123456` |
| Float32 | float | `123456.12` |
| Float64 | double | `123456.12` |
| UInt8 | byte | `123456` |
| UInt16 | ushort | `123456` |
| UInt32 | uint | `123456` |
| UInt64 | ulong | `123456` |
| Date | DateTime | '16/02/2008 12:15:12' |
| DateTime | DateTimeOffset | `05/01/2008` |
| DateTime64 | DateTimeOffset | `05/01/2008` |
| UUID | Guid | `81a130d2-502f-4cf1-a376-63edeb000e9f` |
| IPv6 | IPAddress | '2001:0db8:85a3:08d3:1319:8a2e:0370:7344' IP address |
| IPv4 | IPAddress | '127.0.0.1' IP address |
| String | string | 'string' |
| FixedString | string | 'string' |
| Nothing | DBNull | |
| Array | --- | Not implemented |
| Nested | --- | Not implemented |
| Tuple | --- | Not implemented |
| Nullable | --- | Not implemented |
| LowCardinality | --- | Not implemented |
MsSqlDataConnection
| SqlDbType Type | C# Type | Example |
|------------------|------------------|----------------------------------------|
| BigInt | long | `123456` |
| Bit | bool | `True` or '1' |
| DateTime | DateTime | '16/02/2008 12:15:12' |
| SmallDateTime | DateTime | '16/02/2008 12:15:12' |
| Date | DateTime | '16/02/2008 12:15:12' |
| Time | DateTime | '16/02/2008 12:15:12' |
| DateTime2 | DateTime | '16/02/2008 12:15:12' |
| Char | string | `a` single char |
| NChar | string | 'string' |
| NText | string | 'string' |
| NVarChar | string | 'string' |
| Text | string | 'string' |
| VarChar | string | 'string' |
| Xml | string | '<xml/>' xml string |
| Decimal | decimal | 'string' |
| Money | decimal | 'string' |
| SmallMoney | decimal | 'string' |
| Real | float | `123456.12` |
| Float | float | `123456.12` |
| Int | int | `123456` |
| UniqueIdentifier | Guid | `81a130d2-502f-4cf1-a376-63edeb000e9f` |
| SmallInt | short | `123456` |
| TinyInt | byte | `123456` |
| DateTimeOffset | DateTimeOffset | `05/01/2008` |
| Variant | object | |
| Udt | object | |
| Binary | byte[] | `12AA` hex string |
| Image | byte[] | `12AA` hex string |
| Timestamp | byte[] | `12AA` hex string |
| VarBinary | byte[] | `12AA` hex string |
| Structured | --- | Not implemented |