public void Execute_Create_Procedure_And_Read_Results() { using var connection = new SqlConnection(fixture.ConnectionString) .Execute(@" create procedure TestStoredProcedure(@id int) as select * from ( values (1, 'foo1', cast('1977-05-19' as date)), (2, 'foo2', cast('1978-05-19' as date)), (3, 'foo3', cast('1979-05-19' as date)) ) t(first, bar, day) where first = @id "); var results = connection .AsProcedure() .Read("TestStoredProcedure", ("id", 1)) .SelectDictionaries() .ToList(); Assert.Single(results); Assert.Equal(1, results[0].Values.First()); Assert.Equal("foo1", results[0]["bar"]); Assert.Equal(new DateTime(1977, 5, 19), results[0]["day"]); }