How to submit changes in LinqPad

bangoo picture bangoo · Aug 26, 2013 · Viewed 16.6k times · Source

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);

Answer

Erwin picture Erwin · Aug 26, 2013

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();
}