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); }