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

2 votes216 views1 answer
Unity default rotation
C#Unity
0 vote146 views1 answer
How to draw a dot in c#
C#
0 vote147 views2 answers
Winform not maximizing
C#
2 votes103 views1 answer
How to take user input in string in c#
C#
18 votes214 views1 answer
Unity delete all children
C#Unity
0 vote154 views1 answer
Create dropdown in datatable c# dynamically
C#
0 vote189 views1 answer
Get execution directory c#
C#
0 vote141 views1 answer
How to get error code from exception in c#
C#
0 vote207 views1 answer
Unity dictionary check if key exists
C#Unity
0 vote150 views3 answers
C# switch
C#