Entity Framework Multiple Stored Procedures

Question

I am quite new to the Entity Framework, and only have recently started looking into it. I have been using Linq to SQL for sometime now in a C# enviroement and found it really wonderful to use.

Currently I use sqlmetal to generate a DataContext File (Linq to SQL).

Now after some time I thought it would be nice to use to the Entity Framework, (Linq to Entities), I can see that in some respect there are syntatical similarities between the two, i.e. accessing and creating new instances providing the connection string.

However what Im interested in is when the mapping is generated, is there a way to automatically import all the stored procedures, similar to how sqlmetal does it. So that I dont have to import each one individually.

Thank you in advance.

Dennis Traub · Accepted Answer · 2011-09-09 09:33:27Z

2

In the Model Designer (inside Visual Studio, default view option for *.edmx files)

right click --> Update Model from Database

in the "Add" tab of the resulting dialog you can select any or all Stored Procedures.

Edit: Here's a screenshot of the dialog I'm talking about, found at a tutorial at robbagby.com

edited Sep 9, 2011 at 9:33

answered Sep 8, 2011 at 13:37

Dennis Traub

51.9k7 gold badges100 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Valeklosse Over a year ago

Thank you very much. The tutorial was very helpful. Unfortunately even tho it added all the stored procedures into the Model Store. It didnt add them to the Function Imports. Im guessing there is no real way of getting round this, so will have to add each one individually.

Collectives™ on Stack Overflow

Entity Framework Multiple Stored Procedures

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related