private void AddToDb(BillInfo bill)
 {
     using (DataAccessLayer dbAccess = new DataAccessLayer(_connString))
     {
         dbAccess.AddAndSave(bill);
     }
 }
        public void SetUp()
        {
            _mutex.WaitOne();
            System.Diagnostics.Debug.WriteLine("Begin test " + TestContext.TestName);
            using (DataAccessLayer dbAccess = new DataAccessLayer(_connString))
            {
                BillInfo dummy = new BillInfo {
                    Type = BillType.Unknown, BillName = "", Amount = 0.0, DueDate = new DateTime(1990, 1, 1)
                };
                dbAccess.AddAndSave(dummy);
                _currId = dummy.Id;
            }

            try
            {
                CleanDatabase();
            }
            catch (Exception e)
            {
                ConsoleColor original = Console.BackgroundColor;
                Console.BackgroundColor = ConsoleColor.DarkRed;
                Console.WriteLine(e.Message);
                Console.BackgroundColor = original;
            }
        }