i trying information database through stored procedure , transfer controller view:
[httppost] public actionresult mostrarrecord(string fecha) { viewbag.message = "siga los pasos para completar el proceso..."; retail2entities cl = new retail2entities(); datetime fechabase = convert.todatetime(fecha); getindividualsensorrecord_result records = cl.getindividualsensorrecord(viewbag.idsensor, viewbag.tiposensor, fechabase); return view(records); } but during runtime, next error
cannot implicitly convert type'system.data.objects.objectresult' 'datarebuilder.models.getindividualsensorrecord_result'.
how can correctly achieve this?
also if place:
var records = cl.getindividualsensorrecord(viewbag.idsensor, viewbag.tiposensor, fechabase);
this model:
namespace datarebuilder.models { using system; public partial class getindividualsensorrecord_result { public system.datetime date { get; set; } public decimal idsensor { get; set; } public bool enter { get; set; } public nullable<decimal> c01 { get; set; } public nullable<decimal> c02 { get; set; } public nullable<decimal> c03 { get; set; } public nullable<decimal> c04 { get; set; } public nullable<decimal> c05 { get; set; } public nullable<decimal> c06 { get; set; } public nullable<decimal> c07 { get; set; } public nullable<decimal> c08 { get; set; } public nullable<decimal> c09 { get; set; } public nullable<decimal> c10 { get; set; } public nullable<decimal> c11 { get; set; } public nullable<decimal> c12 { get; set; } public nullable<decimal> c13 { get; set; } public nullable<decimal> c14 { get; set; } public nullable<decimal> c15 { get; set; } public nullable<decimal> c16 { get; set; } public nullable<decimal> c17 { get; set; } public nullable<decimal> c18 { get; set; } public nullable<decimal> c19 { get; set; } public nullable<decimal> c20 { get; set; } public nullable<decimal> c21 { get; set; } public nullable<decimal> c22 { get; set; } public nullable<decimal> c23 { get; set; } public nullable<decimal> c00 { get; set; } }} this in context.cs
public virtual objectresult<getindividualsensorrecord_result> getindividualsensorrecord(nullable<int> idsensor, nullable<int> entrada, nullable<system.datetime> fech) { var idsensorparameter = idsensor.hasvalue ? new objectparameter("idsensor", idsensor) : new objectparameter("idsensor", typeof(int)); var entradaparameter = entrada.hasvalue ? new objectparameter("entrada", entrada) : new objectparameter("entrada", typeof(int)); var fechparameter = fech.hasvalue ? new objectparameter("fech", fech) : new objectparameter("fech", typeof(system.datetime)); return ((iobjectcontextadapter)this).objectcontext.executefunction<getindividualsensorrecord_result>("getindividualsensorrecord", idsensorparameter, entradaparameter, fechparameter); } i can transfer it, how able explore variable records in view? i.e. model has 10 different strings correspond.
appreciate help.
i believe issue getindividualsensorrecord() returns objectresult trying set complex type getindividualsensorrecord_result. try doing .firstordefault()
Comments
Post a Comment