SqlSugar使用DataReader防止内存溢出-刘天佑博客-记录生活和成长的一个自媒体博客

var startTime= DateTime.Today.AddDays(day);
var endTime = date.AddDays(1).AddMilliseconds(-1);
List<KPI_BASE_IISLOG> data = new List<KPI_BASE_IISLOG>();

using (var reader = Db.Ado.GetDataReader("SELECT * FROM KPI_BASE_IISLOG WHERE VISIT_TIME>@startTime and VISIT_TIME<@endTime",
new List<SugarParameter>()
{ new SugarParameter("@startTime",startTime),
  new SugarParameter("@endTime", endTime)
}))
{
while (reader.Read())//循环读取数据
{
var model = new KPI_BASE_IISLOG
{
//把数据ADD到实体或者添加进DataTable
};
data.Add(model);
}
Db.Ado.Close();//释放
}