public void CreateAndDeleteRssFromUriFileSystem() { // Create and delete Rss in succession. Any db locking issues? string inputUri = @"..\..\..\SolutionArtefacts\jc_blog_rss.xml"; Rss rss = new Rss(inputUri); Assert.IsTrue(rss != null); using (jarwinEntities context = new jarwinEntities()) { context.feeds.Add(rss.feed); try { context.SaveChanges(); } catch (Exception ex) { Assert.Fail("Error - failed to insert Feed record: " + ex.Message); } int feedID = (int)rss.feed.feed_id; // Value provided by SQL Server identity column. int feedItemID = 0; foreach (var feedItem in rss.feedItems) { feedItem.feed_id = feedID; feedItem.feed_item_id = feedItemID; context.feed_item.Add(feedItem); feedItemID += 1; } try { context.SaveChanges(); } catch (Exception ex) { Assert.Fail("Error - failed to insert FeedItem record: " + ex.Message); } try { rss.Delete((int)rss.feed.feed_id); } catch (Exception ex) { Assert.Fail("Error - failed to delete Feed or FeedItem record: " + ex.Message); } } }
public async void CreateAndUpdateRssFromUriFileSystem() { // Create and then update. string inputUri = @"..\..\..\SolutionArtefacts\jc_blog_rss.xml"; Rss rss = new Rss(inputUri); Assert.IsTrue(rss != null); using (jarwinEntities context = new jarwinEntities()) { context.feeds.Add(rss.feed); try { context.SaveChanges(); } catch (Exception ex) { Assert.Fail("Error - failed to insert Feed record: " + ex.Message); } int feedID = (int)rss.feed.feed_id; // Value provided by identity column. int feedItemID = 0; foreach (var feedItem in rss.feedItems) { feedItem.feed_id = feedID; feedItem.feed_item_id = feedItemID; context.feed_item.Add(feedItem); feedItemID += 1; } try { context.SaveChanges(); } catch (Exception ex) { Assert.Fail("Error - failed to insert FeedItem record: " + ex.Message); } //try //{ // bool success = await rss.Update((int)rss.feed.feed_id); // Assert.IsTrue(success); //} //catch (Exception ex) //{ // Assert.Fail("Error - failed to update Feed or FeedItem record: " + ex.Message); //} } }