How to Update in Linq

osorojo

I'm using a Data Context to connect to SQL Server and trying to troubleshoot an update. I have this much in Linqpad

var results = (from bl in a_Bellows_Lots
where bl.Job == "A2559038A"
where bl.BellowsLot == "17213A"
select bl).SingleOrDefault();

results.Quantity = 8;

???.SubmitChanges();

But I don't know what to call the update from.

My connection is called DataClasses1DataContext(kcserver2.support.PRODUCTION)

I tried DataClasses1DataContext, but it didn't have SubmitChanges sub command.

How do I make a SQL Server table update in Linqpad?

Thanks

sgmoore

Try SubmitChanges() or this.SubmitChanges()

albertcox

Thanx a lot! This helped me