Matching between the SQL server type and. Net Type

 

 Sqlparameter vparam =NewSqlparameter ("@ Question_type",Typeof(Byte));

Vparam. value = qquestiontype;

Sqlparameter vparam =NewSqlparameter ("@ Question_type",Typeof(Byte));
Vparam. value =Int. Parse (qquestiontype );

 

The difference between the first and second sections is type conversion. If the question_type field is of the byte type in the database, the second type is recommended. type Matching Improves query performance. Of course, the first case is, SQL regards parameters as nvarchar type and can also run, but it takes a lot of time. I estimate that indexes are not used in this case.