EF核心调用存储过程，获取实体列表

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using Microsoft.EntityFrameworkCore;

namespace YourNamespace
{
    public class YourEntity
    {
        public int Id { get; set; }
        public string Name { get; set; }
        // 其他属性...
    }

    public class YourDbContext : DbContext
    {
        public DbSet<YourEntity> YourEntities { get; set; }

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

        // 调用存储过程并获取实体列表
        public List<YourEntity> GetEntityListFromStoredProcedure()
        {
            var entities = new List<YourEntity>();
            
            using (var command = this.Database.GetDbConnection().CreateCommand())
            {
                command.CommandText = "YourStoredProcedureName";
                command.CommandType = CommandType.StoredProcedure;
                
                // 添加存储过程参数（如果有）
                // command.Parameters.AddWithValue("@parameterName", parameterValue);
                
                if (command.Connection.State != ConnectionState.Open)
                    command.Connection.Open();
                
                using (var reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        var entity = new YourEntity();
                        
                        entity.Id = reader.GetInt32(reader.GetOrdinal("Id"));
                        entity.Name = reader.GetString(reader.GetOrdinal("Name"));
                        // 设置其他属性...
                        
                        entities.Add(entity);
                    }
                }
            }
            
            return entities;
        }
    }

    public class Program
    {
        public static void Main(string[] args)
        {
            using (var context = new YourDbContext())
            {
                var entityList = context.GetEntityListFromStoredProcedure();
                
                foreach (var entity in entityList)
                {
                    Console.WriteLine($"Id: {entity.Id}, Name: {entity.Name}");
                }
            }
        }
    }
}