How to submit changes in LinqPad
I have a problem with committing changes in LinqPad. I am using Oracle database over IQ driver in LinqPad. I can retrieve data but I don't know how to submit changes to database.
I retrieve data from database:
var items = Asyncqueue.Where(x => ids.Any(y=> y == x.Asyncqueueid));
// then I have to fix data
I have tried to set submit action like this:
Asyncqueue.SetSubmitAction(items, SubmitAction.Update);
Solution 1:
Change Language in LINQPad to "C# Program" and use the following code
void Main()
{
var p1 = Person.Single(x => x.Id == 1);
p1.Name = "Test";
SubmitChanges();
}
Solution 2:
If you are using an EF Context, then you need to call SaveChanges()
If you are using a Linq2Sql context, then you need to call SubmitChanges()