Loading

How to execute a function with parameters in dapper

Anele Ngqandu

Hi Guys

Please assist executing a dapper function below. I am using oracle Below query complains that its missing a FROM, but when from is added, it complains that the query is missing expression.

var results = connection.Query("select from checkpin(:Username, :Password)", new { Username = input.Username, Password = input.Password }, commandType: CommandType.Text);

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
There are multiple ways, the easiest one is
var parameters = new { UserName = username, Password = password };
var sql = "select * from users where username = @UserName and password = @Password";
var result = connection.Query(sql, parameters);
0