IDbConnection (ExecuteQueryMultiple)

IDbConnectionExecuteQueryMultiple.cs

using (var connection = new SqlConnection(connectionString))
{
     // Call the method by passing multiple statements
     var extractor = connection.ExecuteQueryMultiple("SELECT * FROM [dbo].[Customer] WHERE Id = @CustomerId; " +
          "SELECT * FROM [dbo].[Order] WHERE CustomerId = @CustomerId; " +
          "SELECT GETUTCDATE() AS RetrievedDateTimeUtc;",
          new { CustomerId = 10045 });
          
     // Extract the results
     var customer = extractor.Extract<Customer>().FirstOrDefault();
     var orders = extractor.Extract<Order>().ToList();
     var retriveDateTime = extractor.Scalar<DateTime>();
}