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"]);
}
