C#

lvItems = new TypeOfLVItemThatIDontKnowAndYouDo();

using (LinqDB dbLinq = new LinqDB(dbSource))
{
   dbLinq.CommandTimeout = UniversalVariables.linqTimeOut; // I've setted as 60 minutes and also 0 infinite. 

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

}

lstFilters.AsParallel().ForAll(chunks =>
{

  using (var dbLinq2 = NewDBInstance(dbSource))
  {
      var lstRecords = (from tb in dbLinq2.Table
                        where (tb .Date.Year == chunks
                        select tb).ToList();
  }

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