MVC 4.5 with entity framework

Question

0.00/5 (No votes)

See more:

Hello,

I am working on project in which we are going to use MVC 4.5 and Entity Framework6.

There are some doubts in my mind that are;
1. Can we use stored Procedure with Entity framework. Because there is a scenario where we insert
and update data in multiple tables on single button click which could easily achieved using a
stored procedure on one hit on the Database. If we do not use stored procedure then we have to
hit database many times.
Is there any better alternative in entity framework for this scenario only.

2. Can we upload our project on the server without publishing it. Because in our case small
changes frequently take place and we have to upload a single page many times on the server for
a small change. If not then please suggest a better alternative of it.

Regards,
Ashish verma

Posted 18-Aug-14 22:02pm

Aashish vermaa

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NowYouSeeMe · Answer 1 · 2014-08-18T22:08:00

Solution 1

1.yes..you can use stored procedure in entity frame work.but in the case of simple CRUD operations,entity method is more efficient

Entity Framework CRUD Operations Using Stored Procedures[^]

2.yes..you can copy that particular file only n paste in web server

Posted 18-Aug-14 22:08pm

NowYouSeeMe

Updated 19-Aug-14 22:41pm

v2

Comments

Aashish vermaa 19-Aug-14 4:24am

In that case where changes take places in view, controller and model as well.

NowYouSeeMe 20-Aug-14 5:06am

http://www.entityframeworktutorial.net/stored-procedure-in-entity-framework.aspx

nrgjack · Answer 2 · 2014-08-19T04:27:00

1. usually i use a generic repository (search for repository pattern) you could implement a InsertOrUpdate method in your repository and make it available across every entity, you don't need to create one SP for entity.

2. you can publish your files and look for the ones that have last edit time grater than the version of the server, for example for changes on .cshtml / .config / .js files you can upload the modified file, if you changed the model / controller you need too upload only the .dll that contains that specific class