Update Operation in LINQ to SQL or Entity Framework

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

I want to update one column in LINQ to SQL. My Query is like :-

C#

private void UpdateCourse()
{
      OperationDataContext OdContext = new OperationDataContext();
      //Get Single course which need to update
      COURSE objCourse = OdContext.COURSEs.Single(course => course.course_name == "B.Tech");
      //Field which will be update
      objCourse.course_desc = "Bachelor of Technology";
      // executes the appropriate commands to implement the changes to the database
      OdContext.SubmitChanges();
}

My question is first it take record from COURSEs which match the criteria Than it update it. It this right approach? or SP is right solution here.

Suggest!

Posted 21-Jul-15 1:53am

_Dhull

Updated 21-Jul-15 2:04am

Wendelius

v3

Add a Solution

Comments

Herman<T>.Instance 21-Jul-15 9:44am

What is right approach? Both ways work. Which one suits you better?

_Dhull 22-Jul-15 0:19am

Both are good and working but which one is efficient? Linq is hitting DB twice, once fro fetch record than update it. Which one is fast and efficient?

Herman<T>.Instance 22-Jul-15 4:33am

your Sp has a query plan in the Db so that should performance better.

3 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)

Satya Prakash (consultant) · Answer 1 · 2015-07-21T08:03:00

1. If you need to update a single value. Go for LINQ and update using Entity Framework.

int num = OdContext.SaveChanges();

It saves this modification to the database when we do OdContext.SaveChanges(). This method also returns the number of rows updated in the database.

2. For saving or updation of number of columns. Better to go for Store procedures if performance is a major concern.

cristinakity · Answer 2 · 2015-07-21T06:37:00

Solution 1

It's Right :-) taht way you only update the course_desc field... What's the matter?

Posted 21-Jul-15 6:37am

cristinakity

**_Dhull** · Answer 3 · 2015-07-21T18:22:00

Solution 3

Yes both will work fine. But which one is fast and efficient? Suppose i have 15 column in table all are varchar(max) than LINQ TO SQL first fetch all column and than update means 2 hit to DB. Which one(above mention way OR Stored procedure) is fast and preferred?

Posted 21-Jul-15 18:22pm