Data Types For Front End and Back End in .Net

Jet Engine (Access)          Sql-Server                                                      C#

Text                                    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, timestamp                    DateTime

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[]