title: Save data from grid using Dapper.net and ServiceStack.OrmLite
body: <p>I'm using datagridview for CRUD operations. </p>
  
  <p>Earlier when I used <strong>ADO.net</strong> and later when I moved to <strong>EF</strong> i successfully was committing every command that I wanted. Insert, update or delete. </p>
  
  <p>Suppose i want to update first row, or four row and eleven row, and what if i delete a second, and also what if i need to add a new row. All that in same time using <strong>datagridview</strong>. </p>
  
  <p>Then after all this modification i just need to call <strong>DA.Update(DS)</strong> or in EF <strong>SaveChanges</strong> and all my data will be saved. In first two scenario i can do exactly that!</p>
  
  <p>Example for first two: ADO.NET AND EF6</p>
  
  <p>I have done this in the following way :</p>
  
  <ol>
  <li><p>ADO.NET:</p>
  
  <pre><code>    Dim command As New SqlCommand
  
      command = New SqlCommand(query, conn)
      command.CommandTimeout = 200
      ds = New DataSet
      SQLDA = New SqlDataAdapter(command)
  
  
      SQLDA.Fill(ds)
      Dim cb As New SqlCommandBuilder(SQLDA)
      Dim bs As New BindingSource
      bs .DataSource = ds.Tables(0)
      DGV.DataSource = bs 
  
      button_clik
    SQLDA.UPDATE(ds)    'save all changes i have made
  </code></pre></li>
  <li><p>EF</p>
  
  <pre><code>        db = New _Context
  
          db.tPROMs.Load()
  
          Dim b = db.tPROMs.Local.ToBindingList
  
          b.AllowEdit = True
          b.AllowNew = True
          b.AllowRemove = True
  
          Dim bs As New BindingSource
          bs.DataSource = b
          DGV.DataSource = bs 
  
          button_clik
          db.SaveChanges()   'save all changes i have made
  </code></pre></li>
  </ol>
  
  <p>Now how can i save data directly from the grid using <strong>DAPPER.NET</strong> or <strong>ServiceStack.OrmLite</strong></p>
  
  <p>So far I have done this over ADO.NET and later with EF6. But for better performance now I want to do with Dapper.net or ServiceStack.OrmLite.</p>
  
  <ol start="3">
  <li><p><strong>DAPPER.NET</strong></p>
  
  <pre><code>        ???????  
  </code></pre></li>
  <li><p><strong>ServiceStack.OrmLite</strong></p>
  
  <pre><code>        ???????
  </code></pre></li>
  </ol>
  
  <p><a href="https://stackoverflow.com/questions/29265396/save-data-from-grid-using-dapper-net-and-servicestack-ormlite/29266257#29266257">My question</a></p>