entity framework - return custom object from stored procedure executed in EntityFramework, can't see object results -
i trying execute stored procedure using entity framework. i've tried below , returns correct amount of rows, when @ data in debug window, shows type, won't let me drill see actual values are.
sqlparameter param1 = new sqlparameter("@targetdate", filedate); var result = db.database.sqlquery<positionsheetcompresults>("dbo.comparepositionsheet @targetdate", param1);
can tell me how this?
here class
public class positionsheetcompresults { public string acctnum { get; set; }
you should write tolist<positionsheetcompresults>();
var result = db.database.sqlquery<positionsheetcompresults>("dbo.comparepositionsheet @targetdate", param1).tolist<positionsheetcompresults>();
Comments
Post a Comment