update in linqpad 4.42.01

ramnz2

need to update a property on a single row.
I cannot execute this
Option option = Options.Where(p=> p.UserControlToCall.StartsWith("OptionsEditptid")).FirstOrDefault())
option.Code = "aaa"
entity Option is declared no where (intellisense does not show any singular entities ...all are collections).
I can run this with no problem
Options.Where(p=> p.UserControlToCall.StartsWith("OptionsEditptid")).FirstOrDefault())

JoeAlbahari

Have you set the query language to "C# Statements?"

Also, you need semicolons after statements, and you must call SubmitChanges to save the changes at the end:

Option option = Options.FirstOrDefault(p=> p.UserControlToCall.StartsWith("OptionsEditptid"));
option.Code = "aaa";
SubmitChanges();

ramnz2

sorry for the delay on this issue...Joe the problem is as soon as i type Option..which it does not pop on the intellisense.

JoeAlbahari

When I try typing your code (with the table names edited to match what's in my database), I get autocompletion at exactly the right spots.

Where exactly in your code are you not getting it?

ramnz2

LInqPad4 intellisense ....I started typing Option and only Options shows on intellisense.
here is the snapshot of the screen

JoeAlbahari

And the query executes correctly?