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

1 vote336 views1 answer
Unity empty action
C#
0 vote364 views1 answer
Printing pattern in c#
C#
3 votes334 views1 answer
How do I print something in the console at the start of the game unity
C#
9 votes347 views2 answers
C# convert readline to int
C#
5 votes314 views7 answers
If statement
C#
0 vote330 views1 answer
C# read excel file into datatable
C#
1 vote364 views2 answers
Convert memorystream to byte array c#
C#
-2 votes409 views1 answer
Unity3d sort list
C#Unity
1 vote338 views1 answer
C# empty char
C#
0 vote348 views1 answer
How create two database conction in laravel
C#