Import stored proc and functions into entity model disabled?

Mr Edge 221

I created a test database and added a Function. In Visual Studio 2019 i added a new ADO .Net entity model (EF 6), selected the database along with Code First from Database but the option to select the checkbox import selected stored procedure and functions into the entity model is greyed out?

Is there something additional i need to do? If i continue with the process all the tables are converted into Code First C# code?

Karen Payne MVP 35,401 Reputation points

2022-02-19T14:41:54.7+00:00

Have you tried using EF Power Tools ?
Mr Edge 221 Reputation points

2022-02-20T10:36:04.05+00:00

I did see that link but never installed the tools as i was using EF6 but the link is targeting EF Core?

I did find EF6 tools but the description never stated it can extract the Functions. I will have a look at the demo video to see if the Core version would help or not.
AgaveJoe 28,041 Reputation points

2022-02-21T16:15:37.237+00:00

Database first has function import since the procedures exist in the DB. In code first the entities are used to create the database objects.

Share via

Import stored proc and functions into entity model disabled?

Your answer