Microsoft.EntityFrameworkCore中ExecuteScalar的对应物

using Microsoft.EntityFrameworkCore;
using System;

public class MyDbContext : DbContext
{
    public DbSet<MyEntity> MyEntities { get; set; }

    // ...

    public int ExecuteScalar(string sql)
    {
        return this.Database.ExecuteSqlRaw(sql);
    }
}

public class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Program
{
    public static void Main()
    {
        var dbContext = new MyDbContext();

        // 执行原生SQL查询并返回单个标量值
        var result = dbContext.ExecuteScalar("SELECT COUNT(*) FROM MyEntities");
        Console.WriteLine($"Result: {result}");
    }
}