Entity FrameWork

Ramco Ramco

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted 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
+2
Ramco Ramco5y ago
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
+2
Sachin Singh5y ago
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
+2
Sachin Singh5y ago
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.
+2
Pranam Bhat5y ago
Please elaborate your question and need. What's the requirement?
+1