Breaking News: Grepper is joining You.com. Read the official announcement!

dapper query list of parameters

Blushing Bat answered on December 19, 2020 Popularity 8/10 Helpfulness 3/10

answer dapper query list of parameters

related dapper query list of parameters

dapper query list of parameters

Comment

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});

Popularity 8/10 Helpfulness 3/10 Language csharp

Source: dapper-tutorial.net

Tags: c# dapper list parameters

Link to this answer
Share Copy Link

Contributed on Dec 19 2020

Blushing Bat

0 Answers Avg Quality 2/10

Closely Related Answers

dapper query list of parameters

Comment

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();
}

Popularity 8/10 Helpfulness 1/10 Language csharp

Source: dapper-tutorial.net

Tags: parameters list dapper c# dap

Link to this answer
Share Copy Link

Contributed on Dec 19 2020

Blushing Bat

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

dapper query list of parameters

Contents

More Related Answers

dapper query list of parameters

Closely Related Answers

dapper query list of parameters

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.