public void EFTest1()
{
var db = new AdventureWorksDB();
var stores = db.Sales_Stores.ToList();
Assert.That(stores.Count > 1);
// Direct Load
var store = stores.First();
Assert.That(store.BusinessEntityId > 0);
Assert.That(store.Test() == "Concrete Class");
// Parent Lazy Load
var person = store.Sales_SalesPerson;
Assert.That(person != null);
Assert.That(person.Test() == "Concrete Class");
Assert.That(person.BusinessEntityId > 0);
// Direct Load
person = db.Sales_SalesPersons.Single(x => x.BusinessEntityId == person.BusinessEntityId); // fetch again from db
Assert.That(person.BusinessEntityId > 0);
Assert.That(person.Test() == "Concrete Class");
// Child Lazy Load
var childs = person.Sales_Stores.ToList();
Assert.That(childs.Count > 0);
Assert.That(childs.First().Test() == "Concrete Class");
}
public ActionResult GetPagingProductList(int nowPage, int perPage)
{
var adventureWorksDB = new AdventureWorksDB();
var data = adventureWorksDB.Product.Skip(nowPage * perPage).Take(perPage);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public FileContentResult GetProductImage(int id)
{
var adventureWorksDB = new AdventureWorksDB();
var willReturn = adventureWorksDB.Product.Single(x => x.ProductID == id);
return(File(willReturn.ThumbNailPhoto.ToArray(), "image/gif"));
}
public void DapperTest1()
{
using (var cn = AdventureWorksDB.CreateConnection())
{
var stores = cn.Query <Sales_Store>("SELECT * FROM [Sales].[Store]");
Assert.That(stores.Count() > 1);
// Direct Load
var store = stores.First();
Assert.That(store.BusinessEntityId > 0);
// Dapper doesn't have Lazy Loading
var person = store.Sales_SalesPerson;
Assert.That(person == null);
}
}
public ActionResult GetTotalProductCount()
{
var adventureWorksDB = new AdventureWorksDB();
return(Content(adventureWorksDB.Product.Count().ToString()));
}
public ActionResult GetProductList()
{
var adventureWorksDB = new AdventureWorksDB();
return(Json(adventureWorksDB.Product, JsonRequestBehavior.AllowGet));
}
