使用实体框架 ExecuteStoreQuery 返回数据表 [英] Returning a DataTable using Entity Framework ExecuteStoreQuery

问题描述

我使用的系统有许多需要显示的存储过程.为我的每个对象创建实体是不切实际的.

I am working with a system that has many stored procedures that need to be displayed. Creating entities for each of my objects is not practical.

是否有可能以及如何使用 ExecuteStoreQuery 返回 DataTable ?

Is it possible and how would I return a DataTable using ExecuteStoreQuery ?

public ObjectResult<DataTable> MethodName(string fileSetName) {
using (var dataContext = new DataContext(_connectionString))
{
var returnDataTable = ((IObjectContextAdapter)dataContext).ObjectContext.ExecuteStoreQuery<DataTable>("SP_NAME","SP_PARAM");
return returnDataTable;
}

推荐答案

不，我认为这行不通 - 实体框架旨在返回实体，并不意味着返回DataTable 对象.

No, I don't think that'll work - Entity Framework is geared towards returning entities and isn't meant to return DataTable objects.

如果您需要 DataTable 对象，请改用直接的 ADO.NET.

If you need DataTable objects, use straight ADO.NET instead.

这篇关于使用实体框架 ExecuteStoreQuery 返回数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！