/SQL/Dapper run sql script with parameters

Dapper run sql script with parameters

var parameters = new { UserName = username, Password = password };
var sql = "select * from users where username = @UserName and password = @Password";
var result = connection.Query(sql, parameters);

Source: learndapper.com

Similar codes

3 votes112 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote97 views1 answer
Postgres call view
SQL
6 votes114 views2 answers
Sql display max value
SQL
0 vote121 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote145 views1 answer
Column with prefix in sql
SQL
0 vote120 views1 answer
Is not numeric sql
SQL
2 votes100 views1 answer
Get first 2 letter in sql
SQL
1 vote105 views2 answers
Changes not showing on website server odoo
SQL
3 votes133 views1 answer
Oracle function
SQL
0 vote133 views1 answer
Mysql relationships between tables
SQL