从.NET调用表值SQL函数

CREATE FUNCTION [dbo].[MyTableValuedFunction]()
RETURNS TABLE
AS
RETURN
(
    SELECT column1, column2 FROM MyTable
)

using (SqlConnection connection = new SqlConnection("connectionString"))
{
    connection.Open();

    using (SqlCommand command = new SqlCommand("SELECT * FROM MyTableValuedFunction()", connection))
    {
        using (SqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // Process the result set
            }
        }
    }
}