Always match datatypes in code with the columns in the database

It's important to make sure that your datatypes match across all layers in your application. For example, if a column's datatype is VarChar(50), you should have the code in queries and stored procedures use local variables of the same datatype.

Similarly, the ADO.NET code in the data layer should specify the same datatype and length.


Posted By : Dipen Shah
Stay Tuned