如何在EF Core中构造具有动态参数数量的原始SQL查询

public class MyDbContext : DbContext
{
    // DbSet和其他上下文配置

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        // 配置数据库连接
        optionsBuilder.UseSqlServer("your_connection_string");
    }
}

public class MyDbContext : DbContext
{
    // DbSet和其他上下文配置

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        // 配置数据库连接
        optionsBuilder.UseSqlServer("your_connection_string");
    }

    public IEnumerable<T> ExecuteSqlQuery<T>(string sql, params object[] parameters)
    {
        using (var command = Database.GetDbConnection().CreateCommand())
        {
            command.CommandText = sql;
            command.Parameters.AddRange(parameters);

            Database.OpenConnection();

            using (var result = command.ExecuteReader())
            {
                while (result.Read())
                {
                    // 处理查询结果
                    // 可以使用result.GetInt32、result.GetString等方法获取特定列的值
                    // 或者使用result.GetFieldValue<T>方法获取指定类型的值
                }
            }

            Database.CloseConnection();
        }
    }
}

using (var context = new MyDbContext())
{
    string sql = "SELECT * FROM TableName WHERE Column1 = @param1 AND Column2 = @param2";
    object[] parameters = new object[] { value1, value2 };

    var result = context.ExecuteSqlQuery<EntityType>(sql, parameters);

    // 处理查询结果
}