Using stored procedures in code-first approach?

Question

I am using code-first approach in Entity Framework v6.1.3.

My question is: I am using a code-first approach, should I also inject the stored procedures through my entities or should I just go to my database and create a stored procedure there?

What will be the best method to address the same?

Look at http://stackoverflow.com/questions/4845246/does-entity-framework-code-first-support-stored-procedures — Amirhossein Mehrvarzi, Jul 20 '15 at 12:38
for Calling it http://stackoverflow.com/questions/20901419/how-to-call-stored-procedure-in-entity-framework-6-code-first — Amirhossein Mehrvarzi, Jul 20 '15 at 12:39

score 2 · Answer 1 · answered Jul 20 '15 at 12:35

2

You are using code first, do not create stored procedures. The point of switching to a ORM is to move away from manually adding code directly into SQL. Entity framework provides a way to use existing stored procedures so you don't have to rewrite an entire database but you should move away from creating new stored procedures and keep your business logic where it has always belonged, in the application.

answered Jul 20 '15 at 12:35

Stephen Brickner

2,584
1
11
19

thanks stephen ... actually i did it througth the code ..but due to the large number of records involved it was suggested to me that i use Stored Procedure .. hence the query.. – cpr43 Jul 20 '15 at 12:41

Using stored procedures in code-first approach?

1 Answers1

Linked