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 Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

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