public void TestSaveChnages() { UnityDBContext context = new UnityDBContext(); Article article = context.Articles.First(); Console.WriteLine($"文章 {article.Title}({article.ArticleID}) 初始内容数:{article.Contents.Count}"); Console.WriteLine($"数据库内容表查询:{context.Contents.Count()}"); article.Contents.Add(new ContentItem("test add.")); context.SaveChanges(); Console.WriteLine($"数据库内容表查询:{context.Contents.Count()}"); }
public void UnityDBContextTest() { UnityDBContext context = new UnityDBContext(); context.Articles.RemoveRange(context.Articles.ToArray()); context.Contents.RemoveRange(context.Contents.ToArray()); context.SaveChanges(); //测试文章表 int startCount = context.Articles.Count(); Console.WriteLine($"初始文章数目:{startCount}"); Article article = new Article() { ArticleID = "100001", Title = "测试新增文章", ArticleLink = "http://www.cuteleon.com", Description = "测试新增文章", PublishTime = DateTime.Now.ToString(), SADESource = "DBContextTest", DownloadDirectoryName = "测试缓存目录", ArticleFileName = "测试缓存文件名称", State = Article.ArticleStates.New, Contents = new ContentItem[] { new ContentItem() { ImageDescription = "测试新增文章" }, new ContentItem() { ImageDescription = "欢迎使用 Leon Reader." }, new ContentItem() { ImageDescription = "Best Wishes !" } }.ToList(), }; context.Articles.Add(article); context.SaveChanges(); int endCount = context.Articles.Count(); Console.WriteLine($"增加文章后数目:{endCount}"); Assert.AreEqual(startCount + 1, endCount); //测试内容表 startCount = context.Articles.First( art => art.ArticleID == article.ArticleID && art.SADESource == article.SADESource ).Contents.Count; Console.WriteLine($"数据库内文章初始关联内容数目:{startCount}"); article.Contents.Add(new ContentItem("测试插入内容-1")); article.Contents.Add(new ContentItem("测试插入内容-2")); article.Contents.Add(new ContentItem("测试插入内容-3")); context.SaveChanges(); Console.WriteLine("增加文章内容后..."); Console.WriteLine($"文章对象关联内容数目:{article.Contents.Count}"); endCount = context.Articles.First( art => art.ArticleID == article.ArticleID && art.SADESource == article.SADESource ).Contents.Count; Console.WriteLine($"数据库内文章关联内容数目:{endCount}"); Assert.AreEqual(startCount + 3, article.Contents.Count); Assert.AreEqual(endCount, article.Contents.Count); }