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

0 vote233 views1 answer
Csharp attributes as generics constraints
C#
13 votes187 views1 answer
Unity how to set gameobjkect enabled
C#
0 vote187 views1 answer
Pcamera
C#
4 votes182 views1 answer
C# int min
C#
0 vote236 views1 answer
File.create folder c#
C#
2 votes186 views1 answer
How to edit Camera.size property unity
C#
-2 votes191 views2 answers
Calculate time difference with now in flutter
C#
4 votes189 views1 answer
Unity rotation between 2 points
C#
0 vote230 views1 answer
Change character velocity unity
C#
0 vote186 views1 answer
Stringbuilder to string c#
C#