| Data PRovider | Parameter format |
| sqlclient | @parametername |
| oledb | ? mark |
| odbc | ? mark |
| Oracleclient | : parametername |
各種數(shù)據(jù)庫參數(shù)是不同的，如上表格為對應(yīng)關(guān)系
| .net framework type | dbtype | sqldbtype | oledbtype | odbctype | oracletype |
| Boolean | Boolean | bit | boolean | bit | byte |
| byte | byte | tinyint | unsignedtinyint | tinyint | byte |
| char | char | char | char | ||
| datetime | datetime | datetime | datetimestamp | datetime | datetime |
| decimal | decimal | decimal | decimal | numeric | number |
| double | double | float | double | double | double |
| single | single | real | single | real | float |
| guid | guid | uniqueidentifier | guid | uniqueidentifier | raw |
| int16 | int16 | smallint | smallint | smallint | int16 |
| int32 | int32 | int | int | int | int32 |
| int64 | int64 | bigint | bigint | bigint | number |
| string | string | nvarchar(max 4000) | varwchar | nvarchar | nvarchar |
更詳細對比請看如下鏈接
新聞熱點
疑難解答
圖片精選
