lundi 29 juin 2015

How to retrieve list/rows of values from "select" stored procedure Function , where stored procedure Function is auto generated from Entity Framework

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