public void FindAll_WhenCalled_FindsAllInstances()
{
using (var context = new BlogContext())
{
var result = context.Blogs.ToList();
Assert.That(result.Count, Is.EqualTo(2));
}
}
public void FindSpecificBlog_WhenCalled_FindsSpecificInstance()
{
using (var context = new BlogContext())
{
var blog = context.Blogs.Single(b => b.Name.Contains("2"));
Assert.That(blog.Name, Is.EqualTo("Name 2"));
}
}
public void Delete_WhenCalled_DeletesBlog()
{
using (var context = new BlogContext())
{
var blog = context.Blogs.First();
context.Blogs.Remove(blog);
context.SaveChanges();
}
using (var context = new BlogContext())
{
Assert.That(context.Blogs.Count(), Is.EqualTo(1));
}
}
public void ItIsPossibleToAddPostToTheBlog()
{
using (var context = new BlogContext())
{
var blog = context.Blogs.FirstOrDefault();
if (blog != null)
{
blog.Posts.Add(new Post {Title = "Lambda" });
context.SaveChanges();
}
}
using (var context = new BlogContext())
{
Assert.That(context.Blogs.SelectMany(b => b.Posts).Count(), Is.EqualTo(6));
}
}
public void InsertBlog_WhenCalled_InsertsBlog()
{
using (var context = new BlogContext())
{
var newBlog = new Blog { Name = "New Blog", Text = "New Text" };
context.Blogs.Add(newBlog);
context.SaveChanges();
}
using (var context = new BlogContext())
{
context.Blogs
.First(blog => blog.Text.Contains("New"))
.Name.Should().Be("New Blog");
}
}
public void ItIsPossibleToChangePostTitle()
{
using (var context = new BlogContext())
{
var blog = context.Blogs.Include(b=>b.Posts).FirstOrDefault();
if (blog != null)
{
var post = blog.Posts.FirstOrDefault();
if (post != null) post.Title = "Lambda";
context.SaveChanges();
}
}
using (var context = new BlogContext())
{
Assert.That(context.Blogs.SelectMany(b=>b.Posts).Count(p => p.Title=="Lambda"), Is.EqualTo(1));
}
}
public void UpdatingBlog_WhenCalled_UpdatesBlog()
{
using (var context = new BlogContext())
{
var blog = context.Blogs.First();
blog.Name = "Lambda";
context.SaveChanges();
}
using (var context = new BlogContext())
{
context.Blogs.Count(blog => blog.Name.Contains("Lambda"))
.Should().Be(1);
}
}
public void ThereShouldBe5PostsAllInAll()
{
using (var context = new BlogContext())
{
Assert.That(context.Blogs.SelectMany(b=>b.Posts).Count(),Is.EqualTo(5));
}
}
public void RecreateDatabase()
{
Database.SetInitializer(new TestInitializer());
using (var context = new BlogContext())
{
context.Database.Initialize(force: true);
}
}
public void ItIsPossibleToDeletePost()
{
using (var context = new BlogContext())
{
var blog = context.Blogs.Include(b=>b.Posts).FirstOrDefault();
if (blog != null)
{
var post = blog.Posts.FirstOrDefault();
blog.Posts.Remove(post);
context.Entry(post).State = EntityState.Deleted;
context.SaveChanges();
}
}
using (var context = new BlogContext())
{
Assert.That(context.Blogs.SelectMany(b => b.Posts).Count(), Is.EqualTo(4));
}
}
