Search code examples
entity-frameworkstored-procedurescode-firstef-code-first

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.

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;
}
Solution

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

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