Hi

Many of us use SQL server as our preferred choice with our .NET applications. While designing the database we have number of options in terms of selecting data types for our columns. We should be clear about the usage and scope and  mapping of data from Db to our App.

Here is a list of some good articles that may help you decide the most appropriate data type for your column and then convert it into an equivalent .NET data type.

Choosing data type :http://dotnetguts.blogspot.com/2007/10/datatypes-in-sql-server-2005.html

SQL data  types and categories: http://msdn.microsoft.com/en-us/library/ms187752.aspx

Mapping table: http://msdn.microsoft.com/en-us/library/ms131092.aspx