private readonly BaseContext _context;
public BuyService(BaseContext context) : base(context)
{
_context = context;
}
var conn = _context.Database.GetDbConnection();
conn.Open();
using (var command = conn.CreateCommand())
{
command.CommandText = sql;//SQL语句
DbDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var row = new Model();
row.enterprisename = reader.GetString(0);
row.onsalenum = reader.GetInt32(1);
row.dealnum = reader.GetInt32(2);
row.dealarea = reader.GetDecimal(3);
row.dealtotalprice = reader.GetDecimal(4) * 0.0001m;
DataList.Add(row);
}
}
reader.Dispose();
}
conn.Close();
原理还是ado.net的方式