Using 10.2.16.1025, VS Professional 2015, Win 10, SQL Server 2016. I have built several SQL stored procedures to fetch data, integrated them into Entity framework and have successfully used them for both main report datasources and as lists of values for report parameters, accessing them as Entity DataSources.
However, one stored procedure does not work right. After adding it to a new Entity datasource for a report parameter, the column names in its output dataset are not displaying, just an unusable thing named 'item'.
When the wizard gets to Select a Context Member, I pick this:
Method: RptUtlTimeZone(Nullable<Int32> systemTimeZoneId, Nullable<Boolean> returnResultSet, String& zoneMsName) : List<RptUtlTimeZoneReturnModel>
Type: Myriad.Pc.Data.SqlServer.PointCentricContext
Assembly: Myriad.Pc.Data.SqlServer, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
Looks similar to all the other stored procedures that work correctly. Note that it does have the output data set definition List<RptUtlTimeZoneReturnModel>
The Wizard completes, I go to Data Explorer and all I see is "item".
Here is part of the file from Visual Studio which describes the output data set - RptUtlTimeZoneReturnModel.cs
public partial class RptUtlTimeZoneReturnModel
{
public System.Int32? SystemTimeZoneId { get; set; }
public System.String ZoneMSName { get; set; }
}
and this looks fine.
But why does Data Explorer not display the proper columns in the output data set? Thanks.