How to retrieve list/rows of values from "select" stored procedure Function , where stored procedure Function is auto generated from Entity Framework
I can't retrieve list of values from Stored Procedure Function,I am stucked in some part of code, where Store procedure Function is Auto Generated using Entity FrameWork
Kindly check the code attached and help me to solve this. Thanks in Advance
create procedure [dbo].[SP_MobileList]
(
@MobileId varchar(50) out,
@MobileName varchar(50) out
)
As
Begin
select @MobileId=MobileId,@MobileName=MobileName from BasicMobileData
END
AutoGenerated Code from Entity Framework
//ModelClass
public partial class BasicMobileData
{
public string MobileId { get; set; }
public string MobileName { get; set; }
public string MobileIMEno { get; set; }
public decimal MobilePrice { get; set; }
}
//In Context
public virtual DbSet<BasicMobileData> BasicMobileDatas { get; set; }
//Here it returns single integer value
**public virtual int SP_MobileList(ObjectParameter mobileID, ObjectParameter mobileName)
{
return((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("SP_MobileList", mobileID, mobileName);
}**
Controller Code
public class MobileController : Controller
{
MobileEntities objMobileContext = new MobileEntities();
BasicMobileData objBasicMobileData = new BasicMobileData();
#region "ActionMethods"
public ActionResult MobileDetails()
{
ObjectParameter objParMobileId = new ObjectParameter("MobileId",typeof(string));
ObjectParameter objParMobileName = new ObjectParameter("MobileName", typeof(string));
//I am Stucked in this part of code
// this "foreach" will not work since ,autogenerated "SP_MobileList(,)" is returning single integer value"
foreach(BasicMobileData objBasicMobileData in objMobileContext.SP_MobileList(objParMobileId,objParMobileName)){}
return View();
}
#endregion
}
Aucun commentaire:
Enregistrer un commentaire