insertWords method

gistfile1.cs

 // Put all the words from the dictionary file in the database
        public static void insertWords(List<string> wordList)
        {
            OperationDataContext odContext = new OperationDataContext();
            int wordID = 0;


            foreach (string word in wordList)
            {
                english_dictionary dictionary = new english_dictionary();
                word.Trim();


                // Check whether word is already in dictionary

                var queryWords = from dword in odContext.GetTable<english_dictionary>()
                                 where dword.word == word
                                 select dword;

                if(queryWords.Count() > 0)
                {}
                else
                {
                    Console.WriteLine("Adding {0}....", word);
                    dictionary.word = word;
                    dictionary.wordID = wordID++;
                    odContext.english_dictionaries.InsertOnSubmit(dictionary);
   
                }

            }
            odContext.SubmitChanges();
            Console.WriteLine("Database insert operations complete.");
        }