ADOUtils.Tests.DatabaseTest.BasicOperation.Should_execute_stored_procedure C# (CSharp) Method

        public void Should_execute_stored_procedure()
        {
            TestUtils.Execute(@"
            CREATE PROCEDURE SP
            @Param1 nvarchar(max),
            @Param2 int
            AS BEGIN
            SELECT @param1 AS Param1, @Param2 AS Param2
            END
            ");

            var actual = _target.Query("EXEC SP @Param1, @Param2", new { Param1 = "p1", Param2 = 2 }).Select(r => new {
                Param1 = r["Param1"],
                Param2 = r["Param2"]
            }).Single();

            actual.Param1.Should().Be.EqualTo("p1");
            actual.Param2.Should().Be.EqualTo(2);
        }