I have got error in MVC?

Kiran Kumari

hi everyone

i want to get data from my storeprocedure i am calling but i get this message

The data reader is incompatible with the specified 'SH_SDTModel.SP_DashBoardReports_Result'. A member of the type, 'SNo', does not have a corresponding column in the data reader with the same name.

below are my code where i called this SP

public IList GetLblValues()
{
SH_SDTEntities databaseee = new SH_SDTEntities();
var data5 = databaseee.SP_DashBoardReports(Convert.ToDateTime("1/1/2019"), Convert.ToDateTime("6/1/2019"), "JobWiseStatus_SUM").ToList();
if (data5 != null)
{
return data5;
}
else
return null;
}

i placed debugger and got error on this stage

public virtual ObjectResult SP_DashBoardReports(Nullable dateFrom, Nullable dateTo, string mode)
{
var dateFromParameter = dateFrom.HasValue ?
new ObjectParameter("DateFrom", dateFrom) :
new ObjectParameter("DateFrom", typeof(System.DateTime));
var dateToParameter = dateTo.HasValue ?
new ObjectParameter("DateTo", dateTo) :
new ObjectParameter("DateTo", typeof(System.DateTime));
var modeParameter = mode != null ?
new ObjectParameter("Mode", mode) :
new ObjectParameter("Mode", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SP_DashBoardReports", dateFromParameter, dateToParameter, modeParameter);
}

how can i solve this can anyone solve this???

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohsin Arif7y ago
Accepted answer
hi kiran i haad already faced this issue
this can be happen due to this that you have multiple methods or mode in One SP so MVC generate automatically its property which are not is usefull for you if you see this in your

SP_DashBoardReports_Result

its automatically generated class which is generated by EF , you see here there would be some properties like this SNo .

its solution is you make a new SP and place only one mode/Method then do this your code would be run properly
some testing code i would like to share
public IList GetLblValues()
       {
           SH_SDTEntities databaseee = new SH_SDTEntities();
           var data5 = databaseee.SP_DashBoardReportsTest(Convert.ToDateTime("1/1/2019"), Convert.ToDateTime("6/1/2019"), "JobWiseStatus_SUM").ToList();
          if (data5 != null)
               {
                   return data5;
               }
               else
                   return null;

           }

       }
and in Sql change SP as i say and now run it will work.
+1
Mohsin Arif7y ago
i think you have place modes which returns same type of field in one SP ..
but i not confirmed
0
Kiran Kumari7y ago
Mohsin Arif

yes i can work thanks..
but my question is now how can i do these multiple mode in one SP
0
Kiran Kumari7y ago
Sivakumar Koneti

i have seen this but , my SP is not like this.
0
Sivakumar Koneti7y ago
see this once you can get solution

https://stackoverflow.com/questions/41133390/the-data-reader-is-incompatible-with-the-specified-does-not-have-a-correspon
0