public void ResourceDelete()
{
var resource = new Resource()
{
Name = "Account",
ResourceDocs = new List<ResourceDoc>()
{
new ResourceDoc()
{
Language = "en",
Summary = "This is the default English summary"
},
new ResourceDoc()
{
Language = "fr",
Summary = "This is the French summary"
}
}
};
using (var repository = new ResourceRepository())
{
repository.Add(resource);
repository.SaveChanges();
repository.DeleteById(resource.Id);
repository.SaveChanges();
}
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["api.docs.data"].ConnectionString))
{
connection.Open();
using (var command = new SqlCommand("SELECT Id, Name FROM Resources", connection))
{
using (var reader = command.ExecuteReader())
{
Assert.IsFalse(reader.Read(), "Resources table");
}
}
using (var command = new SqlCommand("SELECT Id, ResourceId, Language, Summary FROM ResourceDocs", connection))
{
using (var reader = command.ExecuteReader())
{
Assert.IsFalse(reader.Read(), "Docs table");
}
}
}
}