private static void CreateAndCountTicket()
{
using (var context = new SqLiteTicketsDbContext())
{
var ticket = new Ticket
{
Title = "Title",
Details = "Details",
CreatedAt = DateTime.Now
};
ticket.AddComment("Some Comment", -1);
ticket.AddComment("Some Other Comment", -1);
context.Tickets.Add(ticket);
context.SaveChanges();
}
using (var context = new SqLiteTicketsDbContext())
{
var ticket = context.Tickets
.Include(t => t.Comments)
.FirstOrDefault();
Assert.That(ticket, Is.Not.Null);
Assert.That(ticket.Comments.Count, Is.EqualTo(2));
var ticketCount = context.Tickets.Count();
Assert.That(ticketCount, Is.EqualTo(1));
}
}
public void SetUp()
{
using (var context = new SqLiteTicketsDbContext())
{
context.Database.ExecuteSqlCommand("DELETE FROM Comments");
context.Database.ExecuteSqlCommand("DELETE FROM Tickets");
context.Database.ExecuteSqlCommand("DELETE FROM AppUsers");
}
}