How to edit data directly in a grid

Hi, I purchased LINQPad premium in an attempt to replace TOAD for Oracle. However, i'm unsure how to be able to edit my data directly in linqpad? I just wanted to update a few rows without having to use proper update statements to change data on the fly for another application.

Can anyone point me to some simple instructions on how to do this?

Comments

  • It appears editing in the data grid is not supported by the IQ driver. So you'll have to do something like the following:
    Sometable
    .First()
    .SomeProperty = "SomeValue";
    
    SubmitChanges();
    Not ideal unfortunately. You might want to ping Joseph Albahari about when/if support will be added. Also, add this to the uservoice forum.
  • Okay. Guess your not familiar if I were to use the actual Oracle ODAC drivers instead? Thanks for the quick reply Sorax.

    I did run the following statement (note: I'm still a novice at Linq so there might be a better way)

    this.ArngSiaAprRevs //Table Name
    .First(a => a.Apprrevid == 1) //Where ID = Value
    .Reviewcomments = "Updated Comments"; //Column set to something
    SubmitChanges();

    Thanks again.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!