The DynamicParameters Dbtype works fine even if the types don't match.[.net core]

Viewed 27

I think when I call function DynamicParameter.Add(), Dbtype is not works

I'm using Dapper when I connect to DB. I tried to request query to DB with below code

var parameters = new DynamicParameters();
parameters.Add("@Uid", value: uId, dbType: DbType.string);
var sql = @"select * from User where Uid = @Uid";

The column 'Uid' of 'User' table is type of int. As you saw, I requested query with Uid parameter type of string. I expected it occurred error, however it worked well.

So I'd like to ask. DynamicParameter doesn't check parameter type when add data or run query? If so, why does Dbtype in DynamicParameter.Add() parameter exist?

Thanks in advance

0 Answers
Related