Is there any method to compare the data types of two different Databases.
有没有方法可以比较两个不同数据库的数据类型。
1 个解决方案
#1
5
Jet Engine (Access) | Sql-Server | C#
--------------------+-------------------------------------+--------------------
Text (len < 256) | char, nchar, varchar, nvarchar | string
Memo | text, ntext, the above with len>255 | string
Byte | tinyint | byte
Integer | smallint | short
Long Integer | integer (int) | int
Single | real | float
Double | float | double
Replication ID | uniqueidentifier | Guid
Decimal | decimal | decimal
Date/Time | smalldatetime, datetime, datetime2 | DateTime
Binary (8 bytes)| timestamp, rowversion (Since V2008) | byte[] (8 bytes)
Currency | smallmoney, money | decimal
AutoNumber | int + identity property | int
Yes/No | bit | bool
OLE Object | image | byte[]
Hyperlink | <no equivalent> | string
<no equivalent> | binary, varbinary | byte[]
I took this information from How to Migrate from Access to SQL Server 2000 and added the c# column.
我从如何从Access迁移到SQL Server 2000中获取此信息并添加了c#列。
Note also that most types are nullable in the databases. Map nullable columns to Nullable<T>
(T?
) in C# unless the .NET type is a reference type.
另请注意,大多数类型在数据库中都可以为空。除非.NET类型是引用类型,否则将可空列映射到C#中的Nullable
#1
5
Jet Engine (Access) | Sql-Server | C#
--------------------+-------------------------------------+--------------------
Text (len < 256) | char, nchar, varchar, nvarchar | string
Memo | text, ntext, the above with len>255 | string
Byte | tinyint | byte
Integer | smallint | short
Long Integer | integer (int) | int
Single | real | float
Double | float | double
Replication ID | uniqueidentifier | Guid
Decimal | decimal | decimal
Date/Time | smalldatetime, datetime, datetime2 | DateTime
Binary (8 bytes)| timestamp, rowversion (Since V2008) | byte[] (8 bytes)
Currency | smallmoney, money | decimal
AutoNumber | int + identity property | int
Yes/No | bit | bool
OLE Object | image | byte[]
Hyperlink | <no equivalent> | string
<no equivalent> | binary, varbinary | byte[]
I took this information from How to Migrate from Access to SQL Server 2000 and added the c# column.
我从如何从Access迁移到SQL Server 2000中获取此信息并添加了c#列。
Note also that most types are nullable in the databases. Map nullable columns to Nullable<T>
(T?
) in C# unless the .NET type is a reference type.
另请注意,大多数类型在数据库中都可以为空。除非.NET类型是引用类型,否则将可空列映射到C#中的Nullable