LINQ update query foreach

Question

0.00/5 (No votes)

See more:

I try to create LINQ update query
i try this sp

SQL

ALTER procedure [dbo].[updateselect_Data]
@ServiceID int,
@Service_frequency nvarchar(50),
@Next_Service nvarchar(50),
@Create_reminder nvarchar(50)

as
Update tbl_fl_Services_schedule
SET 
tbl_fl_Services.Service_frequency=@Service_frequency,
tbl_fl_Services.Next_Service=@Next_Service,
tbl_fl_Services.Create_reminder=@Create_reminder
where
ServiceID=@ServiceID

What I have tried:

query

C#

public static string updateselect_data(int ServiceID, string Service_frequency, string Next_Service, string Create_reminder)
        {
            Data track = new Data();

            var update = (from p in track.tbl_fl_Services where p.ServiceID == ServiceID select p).ToList()
                .ForEach(x => x.Service_frequency = Service_frequency);
}

now i select multiple value in for each loop ?

Posted 12-Oct-16 21:32pm

super_user

Updated 12-Oct-16 23:37pm

Add a Solution

Comments

Suvendu Shekhar Giri 13-Oct-16 3:56am

What's is the issue here?
Can you please explain?

super_user 13-Oct-16 7:43am

how to call parameters Service_frequency ,Next_Service,Create_reminder in foreach loop

1 solution

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)

F-ES Sitecore · Answer 1 · 2016-10-12T23:37:00

Create a function that copies the values onto the object and call that function from your ForEach

C#

// I've guessed the type of your schedule object, you'll need to supply the correct type
public void Update(tbl_fl_Services_schedule schedule, string Service_frequency, string Next_Service, string Create_reminder)
{
    schedule.Service_frequency = Service_frequency;
    schedule.Next_Service = Next_Service;
    schedule.Create_reminder = Create_reminder;
}

C#

.ForEach(x => Update(x, Service_frequency, Next_Service, Create_reminder));