using System.Data.SqlClient;
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%" }
var orders = conn.Query<Order>(
"select * from Orders where CustomerID in @CustomerID",
param: new { CustomerID = customers.Select(x => x.CustomerID) }
FiddleHelper.WriteTable(orders);
public string CustomerID { get; set; }
public string CompanyName { get; set; }
public int OrderID { get; set; }
public string CustomerID { get; set; }
public string ShipName { get; set; }
public string ShipAddress { get; set; }