}//TestDBI_T_affirmation_note_Write_to_DB

        //-------------------------------------------------------------------------------------------
        static void TestDBI_T_affirmation_note_Read_from_DB()
        {
            Console.WriteLine("  --START: TestDBI_T_affirmation_note_Read_from_DB");

            SQLServerDB.affirmation_note_Table myTable = new SQLServerDB.affirmation_note_Table();

            int iRows = myTable.CountRows();

            Console.WriteLine("myTable.CountRows = " + iRows.ToString());

            Console.WriteLine("Fill the table in RAM from the SQLServer Database table");
            myTable.ReadItemListFromDatabase();
            myTable.Show();
            if (myTable.itemList.Count != iRows)
            {
                Console.WriteLine("Error.  myTable.itemList.Count != myTable.CountRows." + " should be the same ReadItemListFromDatabase ()");
            }
            else
            {
                Console.WriteLine("OK.  After ReadItemListFromDatabase()");
            }

            Util.pause();

            Console.WriteLine("  --DONE: TestDBI_T_affirmation_note_Read_from_DB");
        }//TestDBI_T_affirmation_note_Read_from_DB
        //-------------------------------------------------------------------------------------------
        static void TestDBI_T_affirmation_note_Write_to_DB()
        {
            Console.WriteLine("  --START: TestDBI_T_affirmation_note_Write_to_DB");

            SQLServerDB.affirmation_note_Table myTable = new SQLServerDB.affirmation_note_Table();
            myTable.itemList = make_affirmation_note_list_1();
            int iRowsStart = myTable.itemList.Count;

            myTable.Show();
            Util.pause();

            Console.WriteLine("  --before clear SQLServer database table");
            Util.pause();
            myTable.Clear_Database_Table();
            int iRows2 = myTable.CountRows();

            if (iRows2 != 0)
            {
                Util.pause("Error.  iRows=" + iRows2 + " should be zero after Clear_Database_Table()");
            }
            else
            {
                Util.pause("OK.  After Clear_Database_Table()");
            }


            Console.WriteLine("Write the table from RAM the SQLServer  Database table");
            myTable.WriteItemListToDatabase();
            int iRows3 = myTable.CountRows();

            if (iRows3 != iRowsStart)
            {
                Util.pause("Error.  iRows3=" + iRows3 + " should be " + iRowsStart + " after WriteItemListToDatabase");
            }
            else
            {
                Util.pause("OK.  After WriteItemListToDatabase()");
            }

            Console.WriteLine("  --after writing to the SQLServer database table.  examine the table using SSMS");
            Util.pause("visually inspect via SSMS?");

            Console.WriteLine("  --DONE: TestDBI_T_affirmation_note_Write_to_DB");
        }//TestDBI_T_affirmation_note_Write_to_DB
        }//TestDBI_T_affirmation_note_Read_from_DB

        //-------------------------------------------------------------------------------------------
        static void TestDBI_T_affirmation_note_T3()
        {
            Console.WriteLine("  --START: TestDBI_T_affirmation_note_T3");


            //Construct myTable in RAM
            SQLServerDB.affirmation_note_Table myTable = new SQLServerDB.affirmation_note_Table();

            //put demo records into myTable
            for (int i = 1; i < 10; i++)
            {
                SQLServerDB.affirmation_note affItem = new SQLServerDB.affirmation_note();
                affItem.affirmationId = i;
                affItem.notes         = "aff_note_" + i.ToString();

                myTable.itemList.Add(affItem);
            }


            //Count SQLServerDB affirmation table rows before clearing
            int iRows = myTable.CountRows();

            Console.WriteLine("myTable.CountRows = " + iRows.ToString());

            Console.WriteLine("  --before clear SQLServer database table");
            Util.pause();

            myTable.Clear_Database_Table();
            int iRows2 = myTable.CountRows();

            Console.WriteLine("myTable.CountRows = " + iRows2.ToString());
            Util.pause();

            myTable.WriteItemListToDatabase();
            Console.WriteLine("after writing to SQLServerDB");
            Util.pause();

            int iRows3 = myTable.CountRows();

            Console.WriteLine("myTable.CountRows = " + iRows3.ToString());
            Util.pause();


            //put demo records into myTable
            myTable.itemList.Clear();
            for (int i = 1; i < 10; i++)
            {
                SQLServerDB.affirmation_note affItem = new SQLServerDB.affirmation_note();
                affItem.affirmationId = i;
                affItem.notes         = "aff_note_" + i.ToString() + "_Rev_A";

                myTable.itemList.Add(affItem);
            }
            myTable.Show();
            Util.pause("--BEFORE the update, showing the planned updates in myTable.itemList");

            myTable.UpdateItemListToDatabase();
            Util.pause("-- AFTER the update, examine the affirmation_note Table using SSMS");

            myTable.Clear_Database_Table_By_AffirmationID(2);
            myTable.Clear_Database_Table_By_AffirmationID(4);
            myTable.Clear_Database_Table_By_AffirmationID(6);
            Util.pause("-- AFTER Clear_Database_Table_By_AffirmationID {2,4,6} using SSMS");

            Console.WriteLine("  --DONE: TestDBI_T_affirmation_note_T3");
        }//TestDBI_T_affirmation_note_T3