如何使用EF Core 3创建和插入存储过程

CREATE PROCEDURE [dbo].[InsertPerson]
    @Name NVARCHAR(50),
    @Age INT
AS
BEGIN
    INSERT INTO [Persons] ([Name], [Age])
    VALUES (@Name, @Age)
END

public class InsertPersonModel
{
    public string Name { get; set; }
    public int Age { get; set; }
}

public class MyDbContext : DbContext
{
    public DbSet<InsertPersonModel> Persons { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("connectionString");
    }
}

using (var context = new MyDbContext())
{
    var nameParam = new SqlParameter("@Name", "John");
    var ageParam = new SqlParameter("@Age", 25);

    context.Database.ExecuteSqlRaw("EXEC [dbo].[InsertPerson] @Name, @Age", nameParam, ageParam);
}