Esempio n. 1
0
        public static void Main()
        {
            Database.SetInitializer(new MigrateDatabaseToLatestVersion<NewsEntity, Configuration>());
            var db = new NewsEntity();

            var news = db.News.ToList();

            news.ForEach(n => Console.WriteLine(n.Content));
        }
Esempio n. 2
0
        static void Main()
        {
            Database.SetInitializer(new MigrateDatabaseToLatestVersion<NewsEntity, Configuration>());

            var firstUserContext = new NewsEntity();
            var secondUserContext = new NewsEntity();
            var lastId = firstUserContext.News.Count();
            var end = true;
            var isFirstSave = false;

            Console.WriteLine("First user");
            PrintNewsWithId(lastId);
            Console.Write("Enter the new content: ");
            var newContent = Console.ReadLine();
            UpdateNewsById(firstUserContext, lastId, newContent);
            Console.WriteLine("Changes successfully saved in the DB.");

            Console.WriteLine();

            Console.WriteLine("Second user");
            PrintNewsWithId(lastId);

            do
            {

                Console.Write("Enter the new content: ");
                newContent = Console.ReadLine();
                UpdateNewsById(secondUserContext, lastId, newContent);

                if (!isFirstSave)
                {
                    firstUserContext.SaveChanges();
                    isFirstSave = true;
                }

                try
                {
                    secondUserContext.SaveChanges();
                    end = false;
                    Console.WriteLine("Changes successfully saved in the DB.");
                }
                catch (DbUpdateConcurrencyException)
                {
                    Console.Write("Conflict! Content from DB: ");
                    PrintNewsWithId(lastId);

                    end = true;

                    firstUserContext.Dispose();
                    secondUserContext.Dispose();

                    secondUserContext = new NewsEntity();
                }
            } while (end);
        }
Esempio n. 3
0
 static void UpdateNewsById(NewsEntity dbContext, int newsId, string newContent)
 {
     var updatedNews = dbContext.News.Find(newsId);
     updatedNews.Content = newContent;
 }
Esempio n. 4
0
 static void PrintNewsWithId(int newsId)
 {
     var contex = new NewsEntity();
     var newsContent = contex.News.Find(newsId).Content;
     Console.WriteLine(newsContent);
 }