.NET
Microsoft Technologies based on the .NET software framework.
4,103 questions
Import stored proc and functions into entity model disabled?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 85%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mr Edge
221
Reputation points
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?
.NET
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,359 questions
{count} votes
-
Karen Payne MVP 35,556 Reputation pointsFeb 19, 2022, 2:41 PM Have you tried using EF Power Tools ?
-
Mr Edge 221 Reputation points
Feb 20, 2022, 10:36 AM 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 29,946 Reputation pointsFeb 21, 2022, 4:15 PM Database first has function import since the procedures exist in the DB. In code first the entities are used to create the database objects.
Sign in to comment
Sign in to answer