Dapper query list of parameters

List<string> names = new List<string> { "Bob", "Fred", "Jack" };
string query = "select * from people where Name in @names";
var stuff = connection.Query<ExtractionRecord>(query, new {names});

Source: dapper-tutorial.net

Dapper query list of parameters

var sql = "SELECT * FROM Invoice WHERE Kind IN @Kind;";

using (var connection = My.ConnectionFactory())
{
	connection.Open();

	var invoices = connection.Query<Invoice>(sql, new {Kind = new[] {InvoiceKind.StoreInvoice, InvoiceKind.WebInvoice}}).ToList();
}

Source: dapper-tutorial.net

Similar codes

4 votes247 views3 answers
Unity ontriggerenter2d
C#
0 vote271 views2 answers
Datagridview mouse click event c#
C#
0 vote291 views2 answers
Unity screentoworldpoint
C#
0 vote245 views1 answer
Check if number is in range c#
C#
3 votes251 views1 answer
Split on uppercase c#
C#
0 vote308 views3 answers
Instantiate object inside of object Unity
C#Unity
1 vote277 views1 answer
Check if current time is in the morning c#
C#
0 vote306 views1 answer
What error code i should return in asp.net core whether user name or password are incorrect
C#
0 vote276 views1 answer
Destroy the game object if the animator has finished its animation
C#
6 votes207 views1 answer
Movement slowly towards target unity
C#