Multiple Result Sets
Required package:
Dapper.FluentMap
Problem solved
Section titled “Problem solved”Read each result set through a mapping-aware grid reader.
When to use it
Section titled “When to use it”Use this capability when the column shape and .NET model should remain separated by explicit, reviewable configuration.
Example
Section titled “Example”using var multi = connection.QueryMultipleMapped(sql);var customers = multi.ReadMapped<Customer>();var orders = multi.ReadMapped<Order>();How it works
Section titled “How it works”FluentMap registers typed metadata and applies it through the matching materialization path. SQL, connections, parameters, and lifecycle remain responsibilities of the application and Dapper.