Dapper delete where in list

The syntax for List<> support in dapper is slightly different than in an actual T-SQL query. See: https://github.com/StackExchange/Dapper

DELETE FROM [Employee] 
WHERE EmployeeId in @empIds
It does not require braces around the IN clause's parameter. And you can just pass an IEnumerable<>. Like this

new { empIds = new[] { Guid.NewGuid(), Guid.NewGuid() } }

Similar codes

0 vote224 views1 answer
Unity master volume changer
C#Unity
2 votes172 views1 answer
Unity how to refrsh scene
C#
94 votes237 views6 answers
How to convert string to int in c#
C#
1 vote180 views1 answer
Get last element in a list vb.net
C#
2 votes166 views1 answer
Unity ray from mouse position
C#
2 votes169 views2 answers
Linq pick random element
C#
18 votes200 views6 answers
C# append array
C#
0 vote181 views1 answer
C# write to lines without extra line
C#
2 votes189 views1 answer
Unity player look at mouse
C#
0 vote230 views1 answer
Unity gun clipping through walls
C#Unity