高效读取返回SqlDataReader yield懒加载

Reflect<NewsModel.News>.GetModel(reader);方法详解：https://blog.csdn.net/weixin_44003021/article/details/110392165
yield会一条一条的把你的结果返回

public static IEnumerable<NewsModel.News> GetNews()
        {
            string sql = "select * from News";
            using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=NewsDB;Integrated Security=True"))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    var reader = cmd.ExecuteReader();
                    while(reader.Read())
                    {
                      yield return Reflect<NewsModel.News>.GetModel(reader);
                        
                    }
                }
            }
        }