LINQpad: Global function SubmitChanges not found

Question

I've got a C#-Statement in LINQpad 4.0 like this:

var x = (from y in MyTable
where y.ID == 12345
select y).Single(); 
x.PropA = "abc";
SubmitChanges();

When i execute the Statements i get the error The name "SubmitChanges" is not available in the current context

How can i fix the problem or update my data using linqpad? On my research i just found something about using a second datacontext, but it should work with the first context...

I think you have to create your own context if you want to use methods like SubmitChanges — asawyer, Sep 12 '11 at 13:10

score 1 · Answer 1 · answered Sep 12 '11 at 13:59

1

Most likely, you've not set a database (connection). Choose a database from the dropdown list above the query, or drag a connection from the Schema Explorer on the left onto your query.

answered Sep 12 '11 at 13:59

Joe Albahari

30,118
7
80
91

score 0 · Answer 2 · answered Nov 04 '14 at 01:12

0

For the Entity Framework, you'll need to use the method SaveChanges() msdn.

answered Nov 04 '14 at 01:12

Devin

23
7

LINQpad: Global function SubmitChanges not found

2 Answers2

Linked