LINQ更新查询foreach [英] LINQ update query foreach
本文介绍了LINQ更新查询foreach的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我尝试创建LINQ更新查询
i试试这个sp
I try to create LINQ update query
i try this sp
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
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 ?
推荐答案
创建一个函数,将值复制到对象上并从ForEach调用该函数
Create a function that copies the values onto the object and call that function from your ForEach
// 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;
}
.ForEach(x => Update(x, Service_frequency, Next_Service, Create_reminder));
这篇关于LINQ更新查询foreach的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文