public void CreateDatabaseAndObserveTheSchemaManually()
{
using (var context = new DataAnnotationContext("DataAnnotation"))
{
var list = context.Users.ToList();
}
}
public void InsertAutoGeneratedGuid()
{
using (var context = new DataAnnotationContext("DataAnnotation"))
{
context.Categories.Add(new DACategory { CategoryName = "Test Generated Guid" });
context.SaveChanges();
}
}
public void TestTPTWhetherInsertToSubTypeCauseAutomaticallyInsertToBaseTypeBeforeHand()
{
var category = new DACategory { CategoryName = "test" };
using (var context = new DataAnnotationContext("DataAnnotation"))
{
context.Categories.Add(category);
context.ProductOutOfStocks.Add(new DAProductOutOfStock {Category = category, LastDate = DateTime.Now});
context.SaveChanges();
}
}
public void TestTPHOfProductAndProductInStock()
{
var category = new DACategory { CategoryName = "test" };
using (var context = new DataAnnotationContext("DataAnnotation"))
{
context.Categories.Add(category);
context.Products.Add(new DAProduct { ProductIdentity = 123, ProductName = "Product 1", CategoryId = category.CategoryId });
context.SaveChanges();
}
using (var context = new DataAnnotationContext("DataAnnotation"))
{
var persistedCategory = context.Categories.FirstOrDefault(x => x.CategoryId == category.CategoryId);
context.ProductInStocks.Add(new DAProductInStock
{
ProductIdentity = 2,
ProductName = "Product 2",
Remaining = 2,
Category = persistedCategory
});
context.SaveChanges();
}
}
public void UpdateRowsWhichEnableRowVersionExpectsConcurrencyException()
{
using (var context = new DataAnnotationContext("DataAnnotation"))
{
context.Categories.Add(new DACategory { CategoryName = "Test Generated Guid" });
context.SaveChanges();
var first = context.Categories.FirstOrDefault();
var second = first.Clone();
first.CategoryName = "Update by First";
second.CategoryName = "Update by Second";
context.Categories.Attach(first);
context.Entry(first).State = EntityState.Modified;
context.SaveChanges();
first.CategoryName.Should().Be("Update by First");
context.Categories.Attach(second);
context.Entry(second).State = EntityState.Modified;
context.SaveChanges();
}
}