Entity FrameWork

Question

Hi

I have installed Entity Framework. When i add Ado.Net Entity Model using Code First From DataBase it shows only Tables & Views.

Include Foreign Keys in the model is - Disabled.

Import selected Stored Procedures & Functions into the Entity model is - Disabled

Thanks

Sachin Singh · Answer

for DB first approach with stored procedure follow my article https://www.sharpencode.com/article/EntityFramework/database-first-approach/what-about-store-procedure-and-functions

Sachin Singh · Answer

Then after generating the context do this protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity () .MapToStoredProcedures(s => s.Insert(u => u.HasName( "InsertEmployee" , "dbo" )) .Update(u => u.HasName( "UpdateEmployee" , "dbo" )) .Delete(u => u.HasName( "DeleteEmployee" , "dbo" )) ); } where EmployeeMaster is any class that can map to your SP

Sachin Singh · Answer

if you have foreign keys then just click on next and it will automatically create the navigation properties. For the Stored procedure make sure you have some stored procedure on the database then only the button will be enabled.

Ramco Ramco · Answer

Hi Sachin When i have selected EF Designer from Database then it is showing Stored Procedure etc. I want that it should be in Models folder . Is it possible It is showing as shown in below link - https://imgur.com/YrliGZb Thanks

Pranam Bhat · Answer

Please elaborate your question and need. What's the requirement?