protected void Page_Load(object sender, EventArgs e)
{
var daten = new List <Customers>();
if (Cache["db"] == null)
{
var db = new EFNorthwind();
var q = db.Customers.ToList();
Cache.Insert("db", q, null, DateTime.Now.AddDays(1), new TimeSpan(1, 0, 0), System.Web.Caching.CacheItemPriority.Low, null);
daten = q;
}
else
{
daten = Cache["db"] as List <Customers>;
}
}
public List <Customer2> GetCustomers()
{
var db = new EFNorthwind();
db.Configuration.LazyLoadingEnabled = false;
var cust = db.Customers.Take(10).ToList();
var ret = new List <Customer2>();
//serialisierung wegen Order Schachtelung
foreach (var item in cust)
{
ret.Add(new Customer2()
{
CustomerID = item.CustomerID,
CompanyName = item.CompanyName,
ContactName = item.ContactName
});
}
return(ret);
}
