How to Update in Linq

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

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!