C#

where tb .Date.Year == chunks

WHERE DatePart(year, [Date]) = @year

lstFilters.AsParallel().ForAll(year =>
{
    DateTime minDateInclusive = new DateTime(year, 1, 1);
    DateTime maxDateExclusive = minDateInclusive.AddYears(1);
    
    using (var dbLinq2 = NewDBInstance(dbSource))
    {
        var lstRecords = (from tb in dbLinq2.Table
                          where tb.Date >= minDateInclusive && tb.Date < maxDateExclusive
                          select tb).ToList();

var distinctYears = (from tb in dbLinq.Table select tb.Year).Distinct<int>();

lstFilters = (from tb in dbLinq.Table
                   group tb by new
                       {
                        tb.Date.Year
                       } into dates
                   select dates.Key.Year).ToList();

string cmd_query = "UPDATE [book_tbl] SET [Type_ID] = '@cmbtyp', ...";

string cmd_query = "UPDATE [book_tbl] SET [Type_ID] = @cmbtyp, ...";

string cmd_query = "UPDATE book_tbl SET Type_ID = @cmbtyp, ...";

cmd.Parameters.AddWithValue("@isbn", txtISBN.Text);

//update button
               string cmd_query = "UPDATE book_tbl SET Type_ID = @cmbtyp,category =@cmbcat,title =@title,publisher_ID =@cmbpub, [A_ID] =@cmbauthor,first_name=@fname,last_name=@lname,publication =@pub WHERE ISBN=@isbn ";

               //parameters

               cmd.Parameters.AddWithValue("@cmbtyp", cmbtyp.Text);
               cmd.Parameters.AddWithValue("@cmbcat", cmbcat.Text) ;
               cmd.Parameters.AddWithValue("@title", txtTitle.Text);
               cmd.Parameters.AddWithValue("@cmbpub", cmbpub.Text) ;
               cmd.Parameters.AddWithValue("@cmbauthor", cmbauthor.Text);
               cmd.Parameters.AddWithValue("@fname",txtfname.Text );
               cmd.Parameters.AddWithValue("@lname", txtlname.Text);
               cmd.Parameters.AddWithValue("@pub",txtpub.Text ) ;
               cmd.Parameters.AddWithValue("@isbn",  txtISBN.Text);
               con = new SqlConnection(ConnectionString);
               con.Open();
               //cmd = new SqlCommand();
               cmd = con.CreateCommand();
               cmd.CommandType = CommandType.Text;
               cmd.CommandText = cmd_query;
               cmd.ExecuteNonQuery();
               con.Close();

               MessageBox.Show("record updated successfully");
               //reset controls
               clear();
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
           }

using (con = new SqlConnection(ConnectionString))
   {
   con.Open();

   string cmd_query = "UPDATE book_tbl SET Type_ID = @cmbtyp, category = @cmbcat, title = @title, publisher_ID = @cmbpub, A_ID = @cmbauthor, first_name = @fname, last_name = @lname, publication = @pub WHERE ISBN = @isbn";
   using (cmd = new SqlCommand(cmd_query, con))
      {
      cmd.Parameters.AddWithValue("@cmbtyp", cmbtyp.Text);
      cmd.Parameters.AddWithValue("@cmbcat", cmbcat.Text) ;
      cmd.Parameters.AddWithValue("@title", txtTitle.Text);
      cmd.Parameters.AddWithValue("@cmbpub", cmbpub.Text) ;
      cmd.Parameters.AddWithValue("@cmbauthor", cmbauthor.Text);
      cmd.Parameters.AddWithValue("@fname",txtfname.Text );
      cmd.Parameters.AddWithValue("@lname", txtlname.Text);
      cmd.Parameters.AddWithValue("@pub",txtpub.Text ) ;
      cmd.Parameters.AddWithValue("@isbn",  txtISBN.Text);
      cmd.ExecuteNonQuery();
      }
  }

Quote:

it just won't have it

cmdEsentutl.StartInfo.RedirectStandardError = true;

cmdEsentutl.StartInfo.Arguments = "/y /vss " + GlobalVariables.edge44HistoryDB + "WebCacheV01.dat /d " + "F:\\WebCacheV01.dat";

cmdEsentutl.StartInfo.Arguments = "/y /vss " + GlobalVariables.edge44HistoryDB + " WebCacheV01.dat /d F:\\WebCacheV01.dat";

cmdEsentutl.StartInfo.Arguments = $@"/y /vss {GlobalVariables.edge44HistoryDB} WebCacheV01.dat /d F:\WebCacheV01.dat";

{
    cmdEsentutl.StartInfo.FileName = "esentutl";
    cmdEsentutl.StartInfo.UseShellExecute = false;
    cmdEsentutl.StartInfo.CreateNoWindow = false;
    cmdEsentutl.StartInfo.Arguments = $@"/y /vss {GlobalVariables.edge44HistoryDB}\WebCacheV01.dat /d E:\WebCacheV01.dat";
    cmdEsentutl.StartInfo.RedirectStandardError = true;
    cmdEsentutl.Start();
    cmdEsentutl.WaitForExit();
}

Extensible Storage Engine Utilities for Microsoft(R) Windows(R)
Version 10.0
Copyright (C) Microsoft Corporation. All Rights Reserved.

Initializing VSS subsystem...

   VSS Subsystem Init failed, 0x80042302
Operation terminated with error -2403 (JET_errOSSnapshotNotAllowed, OS Shadow copy not allowed (backup or recovery in progress)) after 0.172 seconds.

1192034 - Import history from Microsoft Edge[^]:

The internet suggests ( http://blogs.msdn.com/b/martinc/archive/2015/02/11/using-esentutl-exe-vss-to-examine-an-in-use-database.aspx[^] ) to make a Volume Shadow Service copy in order to read the database. Doing this from a normal user level produces:

esentutl /mh WebCacheV01.dat /vss

VSS Subsystem Init failed, 0x80070005
Operation terminated with error -2403 (JET_errOSSnapshotNotAllowed, OS Shadow copy not allowed (backup or recovery in progress)) after 0.15 seconds.

Reading:
http://blog.nirsoft.net/2012/12/08/a-few-words-about-the-cache-history-on-internet-explorer-10/[^]

I tried again from a cmd prompt with admin privileges. This worked! Dumping table information failed because the database was not closed (or something, I didn't save the error message).

I ended up using the following magic incantation:

esentutl /y WebCacheV01.dat /vssrec V01 . /d destination\path\for\copy.dat

using (var cmdEsentutl = new Process())
{
    cmdEsentutl.StartInfo.FileName = "esentutl";
    cmdEsentutl.StartInfo.UseShellExecute = false;
    cmdEsentutl.StartInfo.CreateNoWindow = false;
    cmdEsentutl.StartInfo.Arguments = $@"/y {GlobalVariables.edge44HistoryDB}\WebCacheV01.dat /vssrec V01 . /d F:\WebCacheV01.dat";
    cmdEsentutl.StartInfo.Verb = "runas";
    cmdEsentutl.StartInfo.RedirectStandardError = true;
    cmdEsentutl.Start();
    cmdEsentutl.WaitForExit();
}