C#

private void saveToolStripButton_Click(object sender, EventArgs e)
{
    /*1) Check to see if the author exit
     *      Method: CheckAuthor(String FirstName, String LastName)
     *              payload: Use bool to see if Firstname = Author_table.Firstname & LastName = Author_table.Lastname
     *                       IF the author exist
     *                           -- just call CheckBookExit_ADD(String Title)
     *                       ELSE
     *                           -- Add the author to table
     *                           -- CheckBookExit_ADD (String Title)
     *2) Check to see if the book exit and add accordingly
     *        Method: CheckBookExit_ADD (String Title,String Price,String Keywords,Bool Retired)
     *                Payload: use bool to see if the title exist in the databasebase Book_table.Title = title
     *                         IF the book exist
     *                              -- Add item to BookNumber table.
     *                                     AddBookNumber(int BookID)
     *                              -- Check to see if there is instance in the BookAuthor Linker Table and add accordingly
     *                                     CheckBookAuthor(int AuthorID, int BookID)
     *                          ELSE
     *                               -- Add the book's title,price,keywords,retired to the book table
     *                               -- Add the book number by calling AddBookNumber() don't pass it a value so you get the next book id
     *                               -- Check to see if there is an instance in BookAuthor Linker and add if needed
     *                                      CheckBookAuthor(int AuthorID, int BookID)
     *3) Add the booknumber and Surrogatenumber to the booknumber table
     *         Method: AddBookNumber( int BookID)
     *                 Payload:  add bookID to database and add the surrogatenumber's max value + 1
     *
     * 4) Check to see if the authorID and BookId is in the linker table
     *           Method: CheckBookAuthor(int AuthorID, int BookID)
     *               Payload: use bool to see if the values are in the table
     *                         IF
     *                            they are do nothing
     *                         ELSE
     *                            add the values to the table
     *
     */
    CheckAuthor(authorFirstTextBox.Text, authorLastTextBox.Text);

}

//---------------------------BOOK INSERT METHODS ---------------------------------------
public void CheckAuthor(String FirstName, String LastName)
{
    /*
     * payload: Use bool to see if Firstname = Author_table.Firstname & LastName = Author_table.Lastname
     *                       IF the author exist
     *                           -- just call CheckBookExit_ADD()
     *                       ELSE
     *                           -- Add the author to table
     *                           -- CheckBookExit_ADD ()
     *
     */
    using (var db = new momdbDataContext())
    {
        try
        {
            StatusLabel.Text = "Adding Item to database";
            List<Author> authorList = new List<Author>();
            bool exist = db.Authors.Any(a => a.AuthorFirst == FirstName && a.AuthorLast == LastName);

            if (exist)
                CheckBookExist_ADD();

            else
            {
                Author authorInsert = new Author { AuthorFirst = authorFirstTextBox.Text, AuthorLast = authorLastTextBox.Text };
                authorList.Add(authorInsert);
                db.Authors.InsertAllOnSubmit(authorList);
                db.SubmitChanges();
                Debug.WriteLine(db.Log);

                CheckBookExist_ADD();

            }
        }
        catch (Exception oops)
        {
            MessageBox.Show(oops.ToString());
        }

    }

}

public void CheckBookExist_ADD()
{
    /*Payload: use bool to see if the title exist in the databasebase Book_table.Title = title
     *                         IF the book exist
     *                              -- Add item to BookNumber table.
     *                                     AddBookNumber(int BookID)
     *                              -- add instance in the BookAuthor Linker Table and add accordingly
     *                                     CheckBookAuthor(int AuthorID, int BookID)
     *                          ELSE
     *                               -- Add the book's title,price,keywords,retired to the book table
     *                               -- Add the book number by calling AddBookNumber() don't pass it a value so you get the next book id
     *                               -- Check to see if there is an instance in BookAuthor Linker and add if needed
     *                                      CheckBookAuthor(int AuthorID, int BookID)
     */

    using (var db = new momdbDataContext())
    {
        var originalBook = db.Books.Where(t => t.Title == this.titleTextBox.ToString()).FirstOrDefault();

        List<Book> bookList = new List<Book>();
        bool exist = db.Books.Any(b => b.Title == this.titleTextBox.Text);
        if (exist)
        {
            AddBookNumber(originalBook.ID);
            var AuthorID = (from a in db.Authors
                            select a.ID).Max(); // get the last author id inserted
            CheckBookAuthor(originalBook.ID, AuthorID);
        }
        else
        {

            Book bookInsert = new Book
            {
                Title = this.titleTextBox.Text,
                Keywords = keywordsTextBox.Text,
                Price = Convert.ToDecimal(priceTextBox.Text),
                Retired = retiredCheckBox.Checked
            };
            bookList.Add(bookInsert);
            db.Books.InsertAllOnSubmit(bookList);
            db.SubmitChanges();
            var bookID = (from b in db.Books
                          select b.ID).Max(); // get the last bookid inserted
            var AuthorID = (from a in db.Authors
                            select a.ID).Max(); // get the last author id inserted
            CheckBookAuthor(bookID, AuthorID);


        }
    }

}
public void AddBookNumber(int ID)
{
    //Payload:  add bookID to database and add the surrogatenumber's max value + 1

    using (var db = new momdbDataContext())
    {
        var max_Surrogate = (from sn in db.BookNumbers
                             select sn.SurrogateNumber).Max();
        List<BookNumber> bookNumberList = new List<BookNumber>();
        BookNumber booknumberInsert = new BookNumber { BookID = ID, SurrogateNumber = max_Surrogate + 1 };
        bookNumberList.Add(booknumberInsert);
        db.BookNumbers.InsertAllOnSubmit(bookNumberList);
        db.SubmitChanges();
    }
}

public void CheckBookAuthor(int bid, int aid)
{
    using (var db = new momdbDataContext())
    {
        List<BookAuthor> bookAuthorList = new List<BookAuthor>();
        bool exist = db.BookAuthors.Any(a => a.BookID == bid && a.AuthorID == aid);
        if (exist)
            return;
        else
        {
            BookAuthor bookauthorInsert = new BookAuthor { AuthorID = aid, BookID = bid };
            bookAuthorList.Add(bookauthorInsert);
            db.BookAuthors.InsertAllOnSubmit(bookAuthorList);
            db.SubmitChanges();

        }
        StatusLabel.Text = "Add Complete";
        LoadData();
    }
}

private static bool StopThread = false;

private void Form1_Load(object sender, EventArgs e)
{

   System.Threading.Thread local_Thread = new System.Threading.Thread(RunThread);
   local_Thread.Start();

   System.Windows.Forms.Form local_Form = new System.Windows.Forms.Form();
   local_Form.MdiParent = this;
   local_Form.Show();

}

private void RunThread()
{

   System.Data.SqlClient.SqlConnection local_SqlConnection = new System.Data.SqlClient.SqlConnection();
   System.Data.SqlClient.SqlCommand local_SqlCommand = new System.Data.SqlClient.SqlCommand();
   System.Data.SqlClient.SqlDataReader local_SqlDataReader;
   local_SqlConnection.ConnectionString = @"Data Source=MyServer\MyInstance;Initial    Catalog=master;Integrated Security=true;";
   local_SqlConnection.Open();

   while (!StopThread)
   {

      // Command Object setzen
      local_SqlCommand.CommandText = "SELECT * FROM SomeTable";
      local_SqlCommand.CommandTimeout = 0;
      local_SqlCommand.Connection = local_SqlConnection;

      // DataReader
      local_SqlDataReader = local_SqlCommand.ExecuteReader();

      // DataTable füllen
      System.Data.DataTable local_DataTable = new System.Data.DataTable();
      local_DataTable.BeginLoadData();
      local_DataTable.Load(local_SqlDataReader);
      local_DataTable.EndLoadData();

      System.Threading.Thread.Sleep(2000);
   }

}

private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{ StopThread = true; }