Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. LINQ
  4. How to save changes back to database using 'Link over Dataset'

How to save changes back to database using 'Link over Dataset'

Scheduled Pinned Locked Moved LINQ
csharpdatabaselinqtutorialquestion
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    Chintan Desai
    wrote on last edited by
    #1

    Hi Guys, I am a fresher in LINQ. I want to change UnitPrice (one of the column in table table1) of product name="Alice mutton" and reflect back the changed UnitPrice back to database using data set. I got the result, but with Update() method, in ADO.NET 2.0. How to do the same in LINQ? I think there must be another method. such as SubmitChanges() in Linq to Sql...

    Thanks, Chintan(India)

    J J 2 Replies Last reply
    0
    • C Chintan Desai

      Hi Guys, I am a fresher in LINQ. I want to change UnitPrice (one of the column in table table1) of product name="Alice mutton" and reflect back the changed UnitPrice back to database using data set. I got the result, but with Update() method, in ADO.NET 2.0. How to do the same in LINQ? I think there must be another method. such as SubmitChanges() in Linq to Sql...

      Thanks, Chintan(India)

      J Offline
      J Offline
      Jackeli
      wrote on last edited by
      #2

      I believe there is a full articles and tutorial over at linqhelp.com . Try over there if you can not find your answer here.

      1 Reply Last reply
      0
      • C Chintan Desai

        Hi Guys, I am a fresher in LINQ. I want to change UnitPrice (one of the column in table table1) of product name="Alice mutton" and reflect back the changed UnitPrice back to database using data set. I got the result, but with Update() method, in ADO.NET 2.0. How to do the same in LINQ? I think there must be another method. such as SubmitChanges() in Linq to Sql...

        Thanks, Chintan(India)

        J Offline
        J Offline
        Judah Gabriel Himango
        wrote on last edited by
        #3

        Yep, using LINQ to SQL, you call SubmitChanges on the DataContext.

        Life, family, faith: Give me a visit. From my latest post: "We are Christian, resistance is futile. Your Jewish traits will be assimilated into the Church collective." Judah Himango

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups