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 vote366 views2 answers
CS0120: An object reference is required for the non-static field, method, or property 'PlayerControls.currentState'
C#
0 vote386 views2 answers
Winforms reportviewer.print report
C#
3 votes386 views1 answer
New color unity
C#Unity
0 vote365 views1 answer
Singleton design pattern c# volatile
C#
2 votes381 views1 answer
Draw sphere gizmo unity
C#Unity
1 vote360 views1 answer
Loop over enum values
C#
0 vote358 views1 answer
How to convert iformfile to byte array c#
C#
0 vote367 views2 answers
ASP.NET Core set update clear cache from IMemoryCache (set by Set method of CacheExtensions class)
C#
0 vote401 views1 answer
Replace double backslash with single backslash c#
C#
11 votes332 views2 answers
Unity how to change rotation
C#