This link refers to very basic fundamental concept where programmers have to deal with multiple data types comparison - the one which is coming from SQL server and the one supported by .NET CLR.
This link provides the data type comparison of SQL and .NET which can help resolve most of the issues we face.