I have been searching for several hours and cannot find a way to convert my result to a data table without major hacking. There has to be an easier way. This code fails no matter how many variations I try.


Load from stored procedure
Code:
public DataTable Associates_SelectAll()
{
DataTable dTable = new DataTable();
using(dbContext context = new dbContext())
{
var assocQuery = context.Associates_SelectAll();
dTable = (DataTable)assocQuery;
}
return dTable;
}
Please tell me what I need to do to convert this result to a DataTable. A DataSet would also work.