// @nuget: Norm.net -Version 3.1.0

// @nuget: System.Data.SqlClient -Version 4.8.2

using System.Data.SqlClient;

using System.Threading.Tasks;

using System;

using Norm;

​

public class Program

{

    public static async Task Main()

    {

        using var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerW3Schools());

        await foreach(var (orderId, productId, quantity) in connection.ReadAsync<int, int, int>("SELECT TOP 10 OrderId, ProductId, Quantity FROM OrderDetails"))

        {

            Console.WriteLine($"order={orderId}, product={productId} with quantity {quantity}");

        }

    }

}