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 vote318 views2 answers
C# get filename without extension
C#
0 vote310 views1 answer
C# print decimal with zero at the end
C#
0 vote347 views1 answer
Delete last modification on EntityFramework Core
C#
6 votes305 views2 answers
Unity check collider layer
C#
0 vote332 views1 answer
Pyqt send message to another instance
C#
0 vote362 views3 answers
C# replace multiple characters
C#
0 vote323 views1 answer
C# create console for winform
C#
13 votes350 views3 answers
C# get last item in list
C#
0 vote323 views1 answer
Select a whole row out of a 2d array C#
C#
0 vote302 views1 answer
Open another form with C# Winforms
C#