call stored procedure in mvc 5 entity framework

call stored procedure in mvc 5 entity framework

     
   private void GetDashboardDetailByTenant()
   {
           proc_DashboardInfoTenant_Result dashbordObject = new TenantRepository().GetDashboardInfoTenant(_userSession.TenantID);
           if(dashbordObject != null){
           }
   }


   public proc_DashboardInfoTenant_Result GetDashboardInfoTenant(int TenantId)
   {
            return base.Context.proc_DashboardInfoTenant(TenantId).SingleOrDefault();
   }


  public virtual ObjectResult<proc_DashboardInfoTenant_Result> proc_DashboardInfoTenant(Nullable<int> tenantId)
  {
            var tenantIdParameter = tenantId.HasValue ?
                new ObjectParameter("TenantId", tenantId) :
                new ObjectParameter("TenantId", typeof(int));
   
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<proc_DashboardInfoTenant_Result>("proc_DashboardInfoTenant", tenantIdParameter);


 }


ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

www.code-sample.com/. Powered by Blogger.
^