Unable to update model from database in ASP.NET MVC

See more:

ASP.NET

entity-framework

I am using Database first approach, and when I try to update model from database then it is generate entities in the "Store Procedure / Functions" folder. But it will not generate any class or entity in the "Complex Type" folder.

I don't no what happening with this, when I make Following SP in Database then after Updating model from database "Complex Type" folder can not do anything, But in the case of other SP's, it will generate entities/classes whose name ends with "_Result".

Create Procedure Admin_USP_UserAccess
(
   @UserID int
)
SELECT User_Access.AccessTypeID FROM User_Access INNER JOIN Users ON User_Access.UserID = Users.UserID WHERE User_Access.UserID = @UserID

I think the issue is in the above SP, because I am following same process for other SP's and everything works fine.

I want to know the whole story works behind this.

What I have tried:

I try to use the classes generated by EF in the "Complex Type" folder but the class for "Admin_USP_UserAccess" SP is not available.