How to submit changes in LinqPad

Question

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

Did you try SaveChanges();? What have you tried? Any errors? — Erwin, Aug 26 '13 at 08:51
That's my problem. I don't know where I can call SaveChanges or somethin similar. — bangoo, Aug 26 '13 at 09:12
Query your db, change value of record, call SaveChanges() ... — Erwin, Aug 26 '13 at 09:50

score 80 · Accepted Answer · edited Oct 01 '18 at 13:01

80

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

edited Oct 01 '18 at 13:01

D.R.

20,268
21
102
205

answered Aug 26 '13 at 12:16

Erwin

3,060
26
24

49

it should be SubmitChanges() – Joe Jun 26 '14 at 18:16
38

SubmitChanges for Linq-to-SQL and SaveChanges for Entity Framework. – Erwin Jun 27 '14 at 11:28
8

You can also just change to "C# Statements" and leave out the `Main` function. – Arithmomaniac May 31 '16 at 13:49
He's asking for IQ driver, so SubmitChanges is correct – Robert Ivanc Jun 24 '17 at 09:16
No need for it to be switched to C# Program. C# Statement(s) works as well. See https://stackoverflow.com/a/54010176/1943 @Adrian's answer below. – Ryan Shripat Jun 23 '20 at 16:01
what if I have a composit object because of a Join? – macf00bar Aug 08 '22 at 13:25

score 17 · Answer 2 · edited Feb 06 '23 at 19:50

17

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

edited Feb 06 '23 at 19:50

KyleMit

30,350
66
462
664

answered Jan 02 '19 at 16:52

Adrian Grigore

33,034
36
130
210

How to submit changes in LinqPad

2 Answers2

Linked