public ActionResult Index()
{
AWEntities ctx = new AWEntities();
var products = ctx.Products.ToList();
return(View(products));
}
private static void ModifyDetailsForSalesOrder()
{
using (var context = new AWEntities())
{
var detailList = context.SalesOrderDetails.Where(d => d.SalesOrderID == 71816).ToList();
// modify an OrderDetail
detailList[0].OrderQty = 10;
//delete an OrderDetail
context.DeleteObject(detailList[1]);
//insert a new OrderDetail
var product = context.Products.SingleOrDefault(p => p.ProductID == 711);
var newDetail = new SalesOrderDetail
{
SalesOrderID = 71816,
ProductID = product.ProductID,
OrderQty = 2,
UnitPrice = product.ListPrice,
UnitPriceDiscount = 0,
ModifiedDate = DateTime.Today
};
context.SalesOrderDetails.AddObject(newDetail);
context.SaveChanges();
}
}
public void FunctionReturnsRowsAffected()
{
var context = new AWEntities();
Assert.AreEqual(1, context.ApplyShipDateToOrder(71796, new DateTime(2011, 2, 2)));
Assert.AreEqual(new DateTime(2011, 2, 2), context.Orders.SingleOrDefault(o => o.SalesOrderID == 71796).ShipDate);
}
private static string ObjectQueryTest()
{
var resultList = new List <decimal>();
decimal testresults = 0;
var sw = new System.Diagnostics.Stopwatch();
var sw2 = new System.Diagnostics.Stopwatch();
for (int i = 0; i < 2; i++)
{
//sw.Reset();
//sw.Start();
resultList.Clear();
var context = new AWEntities(); //<--been moving this in and out of the next for loop
for (int j = 0; j < 100; j++)
{
sw2.Reset();
sw2.Start();
//iterating is about the same time as tolist
var customers = context.CreateQuery <Customer>("Customers").ToList();
sw2.Stop();
resultList.Add(sw2.ElapsedMilliseconds);
}
//sw.Stop();
testresults = sw.ElapsedMilliseconds;
}
Console.WriteLine("obj query 1:{0}", resultList[0]);
Console.WriteLine("obj query 2:{0}", resultList[1]);
Console.WriteLine("obj query 3:{0}", resultList[2]);
return(String.Format("ObjectQuery: {0}ms", testresults));
}
public PartialViewResult Subcategorias(int id)
{
AWEntities db = new AWEntities();
return(PartialView("_Subcategorias",
db.ProductCategories.Find(id).ProductCategory1));
}
public Product_dto Get_ByKey(int key)
{
using (var ctx = new AWEntities())
{
return(ctx.Products.Where(x => x.ProductID == key)
.Select(r => Transform(r)).FirstOrDefault());
}
}
public IEnumerable <Product_dto> GetProducts()
{
using (var ctx = new AWEntities())
{
var results = ctx.Products.AsNoTracking().ToList();
return(results.Select(r => Transform(r)).ToList());
}
}
public void ExecuteFunctionReturnsEntitiesImmediately()
{
var context = new AWEntities();
var details = context.GetOrderDetailsForOrder(71796);
Assert.AreEqual(2, details.Count());
Assert.AreNotEqual(0, context.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Unchanged).Count());
}
public void ModifyQuantityDatabaseIntegration()
{
var context = new AWEntities();
var detail = context.SalesOrderDetails.First();
detail.OrderQty += 1;
context.SaveChanges();
Assert.Inconclusive("the purpose of this test is to see profiler activity, assertions are not applicable");
}
public void FunctionReturnsSetOfComplexTypes()
{
var context = new AWEntities();
var details = context.GetCustomerNamesWithSalesOrderTotals().ToList();
Assert.IsInstanceOfType(details[0], typeof(CustomerOrderOverview), "Function did not return CustomerOrderOverview objects");
Assert.AreNotEqual(0, details.Count());
//test to assure that context is not tracking anything after this query
Assert.AreEqual(0, context.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Unchanged).Count());
}
public void FunctionReturnsSetOfStrings()
{
var context = new AWEntities();
var details = context.GetCustomersWithOrdersGreaterThan(10000).ToList();
Assert.AreNotEqual(0, details.Count());
System.Diagnostics.Debug.WriteLine("# customers: {0}", details.Count);
//test to assure that context is not tracking anything after this query
Assert.AreEqual(0, context.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Unchanged).Count());
}
public Product_dto Save(Product_dto data)
{
using (var ctx = new AWEntities())
{
var efo = Transform(data);
ctx.Products.Attach(efo);
ctx.Entry(efo).State = DbContextHelper.GetEntityState(data);
ctx.SaveChanges();
return(Transform(ctx.Entry(efo).Entity));
}
}
private static void DeleteOrders()
{
using (var context = new AWEntities())
{
var orders = from o in context.SalesOrderHeaders where o.CustomerID == 721 select o;
foreach (var order in orders)
{
context.SalesOrderHeaders.DeleteObject(order);
}
context.SaveChanges();
}
}
private static void TimeObjectQuery()
{
var sw = new System.Diagnostics.Stopwatch();
sw.Start();
using (var context = new AWEntities())
{
var custList = context.AWCustomers.ToList();
}
sw.Stop();
Console.WriteLine("Elapsed Time: {0} ms", sw.ElapsedMilliseconds);
Console.WriteLine("Done. Press any key...");
Console.ReadKey();
}
private static void ExecuteQueryLoop(AWEntities oContext, AWL2SDataContext dContext, List <decimal> resultList, QueryType qType, int LoopCount)
{
var compQuery = CompiledQuery.Compile <AWEntities, IQueryable <AWCustomer> >
((AWEntities ctx ) =>
from c in ctx.AWCustomers select c);
for (int j = 0; j < LoopCount; j++)
{
var sw2 = new System.Diagnostics.Stopwatch();
sw2.Start();
//------------using compiled query
// var customers = compQuery.Invoke(context);
//iterating is about the same time as tolist
switch (qType)
{
case QueryType.L2E:
// oContext = new AWEntities();
oContext.AWCustomers.MergeOption = MergeOption.OverwriteChanges;
var customers = (from c in oContext.AWCustomers select c).ToList();
break;
case QueryType.EntityObject:
// oContext = new AWEntities();
oContext.AWCustomers.MergeOption = MergeOption.OverwriteChanges;
var oqCusts = oContext.CreateQuery <AWCustomer>("AWCustomers").ToList();
break;
case QueryType.L2S:
var l2SCusts = (from c in dContext.L2SCustomers select c).ToList();
break;
case QueryType.CompiledL2E:
var compCusts = compQuery.Invoke(oContext).ToList();
break;
case QueryType.DataReader:
break;
default:
throw new ArgumentOutOfRangeException("qType");
}
sw2.Stop();
resultList.Add(sw2.ElapsedMilliseconds);
}
}
private static string LinqToEntitiesTest()
{
var compQuery = CompiledQuery.Compile <AWEntities,
IQueryable <AWCustomer> >((AWEntities ctx) =>
from cust in ctx.AWCustomers select cust);
var resultList = new List <decimal>();
decimal testresults = 0;
var sw = new System.Diagnostics.Stopwatch();
var sw2 = new System.Diagnostics.Stopwatch();
for (int i = 0; i < 2; i++)
{
sw.Reset();
sw.Start();
resultList.Clear();
var context = new AWEntities(); //<--been moving this in and out of the next for loop
for (int j = 0; j < 100; j++)
{
//sw2.Reset();
//sw2.Start();
//------------using compiled query
// var customers = compQuery.Invoke(context);
//iterating is about the same time as tolist
var customers = (from c in context.AWCustomers select c).ToList();
// sw2.Stop();
//resultList.Add(sw2.ElapsedMilliseconds);
}
//Console.WriteLine("l2e query 1:{0}", resultList[0]);
// Console.WriteLine("l2e query 2:{0}", resultList[1]);
// Console.WriteLine("l2e query 3:{0}", resultList[2]);
// Console.WriteLine("total {0}", resultList.Sum());
// Console.ReadKey();
sw.Stop();
testresults = sw.ElapsedMilliseconds;
}
Console.WriteLine("LINQ to Entities: {0}ms", testresults);
Console.ReadKey();
return(String.Format("LINQ to Entities: {0}ms", testresults));
}
private static void RetrieveAndUpdateCustomer()
{
using (var context = new AWEntities())
{
var query = from c in context.Customers where c.CustomerID == 5 select c;
var customer = query.FirstOrDefault();
var newOrder = new SalesOrderHeader
{
OrderDate = DateTime.Now,
DueDate = DateTime.Now.AddMonths(1),
ModifiedDate = DateTime.Now,
Comment = "Don't forget to ship this!"
};
context.ContextOptions.LazyLoadingEnabled = false;
customer.SalesOrderHeaders.Add(newOrder);
context.SaveChanges();
}
}
private static void NewCustomer()
{
using (var context = new AWEntities())
{
var customer = new Customer
{
FirstName = "Julie",
LastName = "Lerman",
ModifiedDate = DateTime.Now
};
customer.SalesOrderHeaders.Add(new SalesOrderHeader
{
OrderDate = DateTime.Now,
DueDate = DateTime.Now.AddMonths(1),
ModifiedDate = DateTime.Now,
Comment = "Don't forget to ship this too!"
});
context.Customers.AddObject(customer);
context.SaveChanges();
}
}
private static void InsertUpdateAndDeleteEntityWithMappedSprocs()
{
var customer = new Customer
{
First = "Julie",
LastName = "Lerman",
ModifiedDate = DateTime.Now
};
using (var context = new AWEntities())
{
context.Customers.Add(customer);
context.SaveChanges();
customer.Title = "Princess";
customer.CompanyName = "The Data Farm";
context.SaveChanges();
context.Customers.Remove(customer);
context.SaveChanges();
}
}
public ActionResult Demo(string modo = "largo")
{
ViewBag.Titulo = "Demos de controladores";
AWEntities db = new AWEntities();
var list = db.Customers.Where(p => p.FirstName.StartsWith("S") && p.Title == "Ms.")
.OrderBy(p => p.LastName)
.Skip(5)
.Take(5)
.ToList();
if (modo.ToLower() == "corto")
{
return(View("DemoCorto", list));
}
else if (modo.ToLower() == "json")
{
return(Json(list.Select(p => new { nombre = p.FirstName, apellidos = p.LastName }),
JsonRequestBehavior.AllowGet));
}
else
{
return(View(list));
}
}
private static decimal ObjectServicesUpdateTest()
{
List <decimal> testresults = new List <decimal>();
System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
var context = new AWEntities();
for (int j = 0; j < iInnerloop; j++)
{
var customers = from c in context.AWCustomers select c;
foreach (AWCustomer cust in customers)
{
AWCustomer c = cust;
c.ModifiedDate = c.ModifiedDate.AddDays(1);
}
for (int iAdd = 0; iAdd < 10; iAdd++)
{
AWCustomer cust = AWCustomer.CreateAWCustomer(0, true, "new", "cust", "pw", "salt", Guid.NewGuid(), DateTime.Now);
context.AWCustomers.AddObject(cust);
}
sw.Reset();
sw.Start();
context.SaveChanges();
sw.Stop();
testresults.Add((decimal)sw.ElapsedMilliseconds);
clearnewcusts(connectionString);
}
// figure out how long this took
//toss first result, calc average of rest
clearnewcusts(connectionString);
testresults.Remove(0);
return(testresults.Average());
}
private static void init_database()
{
var ctx = new AWEntities();
//Database.SetInitializer<AWEntities>(new DropCreateDatabaseIfModelChanges<AWEntities>());
}
private static void init_database()
{
var ctx = new AWEntities();
//Database.SetInitializer<AWEntities>(new DropCreateDatabaseIfModelChanges<AWEntities>());
}
