Dapper list params example

CSharp · Console

/Program.cs

// @nuget: Dapper -Version 1.60.6

using Dapper;
using System;
using System.Linq;
using System.Data.SqlClient;

public class Program
{	
	public static void Main()
	{
		using var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerNorthwind());
		
		var customers = conn.Query<Customer>(
			"select CustomerID, CompanyName from Customers where CustomerID like @CustomerID",
			param: new { CustomerID = "M%" }
		).AsList();
		
		var orders = conn.Query<Order>(
			"select * from Orders where CustomerID in @CustomerID",
			param: new { CustomerID = customers.Select(x => x.CustomerID) }
		);
		
		FiddleHelper.WriteTable(orders);
	}

	public class Customer
	{
		public string CustomerID { get; set; }
		public string CompanyName { get; set; }
	}
	
	public class Order
	{
		public int OrderID { get; set; }
		public string CustomerID { get; set; }
		public string ShipName { get; set; }
		public string ShipAddress { get; set; }
	}
}