Dapper c# mssql select with parameters return null

Question

in my case Dapper return null when i try use parameters:

User user;
            using (var c = new SqlConnection(con.GetConnectionString()))
            {

                var sql = @$"SELECT 
                                tt_id as Id,
                                tt_imie AS Name, 
                                tt_nazwisko AS Surname, 
                                tt_login AS Login
                            FROM nteren_terenowi
                            WHERE tt_login = '@Login'
                                  AND tt_pin = @Pin
                                  AND tt_czy_aktywny = 1;";

                user = c.QueryFirstOrDefault<User>(sql, credentials.GetParam(), commandTimeout: 3000); //its null
            }

    public class UserIdentityMobile : IDynamicParameters
    {
        public string Login { get; set; }
        public string Pin { get; set; }

        public DynamicParameters GetParam()
        {
            Dictionary<string, object> dictionary = new Dictionary<string, object>();
            dictionary.Add("Login", this.Login);
            dictionary.Add("Pin", this.Pin);

            return new DynamicParameters(dictionary);
        }
    }

if I pass params hardcoded in sql user is not null. Someone can help me :)?

Adding single quotes around a parameter placeholder transform that placeholder in a literal string. It is no more used to signal where the parameter value should be used by the dbengine but it is taken at its literal value. Remove the single quotes around @Login — Steve
– Steve, Commented May 26, 2020 at 14:20

Darkwing · Accepted Answer · 2020-05-26 14:14:57Z

3

I think WHERE tt_login = '@Login' should be WHERE tt_login = @Login

answered May 26, 2020 at 14:14

Darkwing

7,6857 gold badges37 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dapper c# mssql select with parameters return null

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related