static void Main(string[] args) { using (AdventureWorksEntities context = new AdventureWorksEntities()) { var orders = context.SalesOrderHeader; var query = from order in orders group order by order.Contact.ContactID into g select new { Category = g.Key, naxTotalDue = g.Max(order => order.TotalDue) }; foreach (var order in query) { Console.WriteLine("ContactID = {0} \t TotalDue méximo = {1}", order.Category, order.naxTotalDue); } Console.ReadKey(); } }
static void Main(string[] args) { //1 /*using(AdventureWorksEntities AWEntities = new AdventureWorksEntities()) * { * var products = AWEntities.Product; * IQueryable<string> productNames = from p in products * select p.Name; * * Console.WriteLine("Productos:"); * foreach(var productName in productNames) * { * Console.WriteLine(productName); * } * Console.ReadKey(); * }*/ //2 /*using (AdventureWorksEntities AWEntities = new AdventureWorksEntities()) * { * var products = AWEntities.Product; * IQueryable<string> productNames = products.Select(p => p.Name); * * Console.WriteLine("Productos:"); * foreach (var productName in productNames) * { * Console.WriteLine(productName); * } * Console.ReadKey(); * }*/ //3 /*using (AdventureWorksEntities AWEntities = new AdventureWorksEntities()) * { * var products = AWEntities.Product; * IQueryable<Product> productsQuery = from p in products * select p; * IQueryable<Product> largeProducts = productsQuery.Where(p => p.Size == "L"); * * Console.WriteLine("Productos de tamaño 'L':"); * foreach (var product in largeProducts) * { * Console.WriteLine(product.Name); * } * Console.ReadKey(); * }*/ //4 /*using (AdventureWorksEntities context = new AdventureWorksEntities()) * { * IQueryable<Product> productsQuery = from product in context.Product * select product; * * Console.WriteLine("Productos:"); * foreach (var prod in productsQuery) * { * Console.WriteLine(prod.Name); * } * Console.ReadKey(); * }*/ //5 /*using (AdventureWorksEntities context = new AdventureWorksEntities()) * { * var query = from product in context.Product * select new * { * ProductID = product.ProductID, * ProductName = product.Name * }; * Console.WriteLine("Informacion de productos:"); * foreach(var productInfo in query) * { * Console.WriteLine("Product Id: {0} Product name: {1} ", * productInfo.ProductID, productInfo.ProductName); * } * Console.ReadKey(); * }*/ //6 /*decimal totalDue = 500.00M; * using (AdventureWorksEntities context = new AdventureWorksEntities()) * { * var contacts = context.Contact; * var orders = context.SalesOrderHeader; * * var query = from contact in contacts * from order in orders * where contact.ContactID == order.Contact.ContactID * && order.TotalDue < totalDue * select new * { * ContactID = contact.ContactID, * LastName = contact.LastName, * FirstName = contact.FirstName, * OrderID = order.SalesOrderID, * Total = order.TotalDue * }; * foreach(var smallOrder in query) * { * Console.WriteLine("Contact ID: {0} \t Name: {1}, {2} \t Order ID: {3} " + * "\tTotal Due: ${4} ", * smallOrder.ContactID, smallOrder.LastName, * smallOrder.FirstName, smallOrder.OrderID, smallOrder.Total); * } * Console.ReadKey(); * }*/ //7 /*using (AdventureWorksEntities context = new AdventureWorksEntities()) * { * var contacts = context.Contact; * var orders = context.SalesOrderHeader; * * var query = from contact in contacts * from order in orders * where contact.ContactID == order.Contact.ContactID * && order.OrderDate >= new DateTime(2002, 10, 1) * select new * { * ContactID = contact.ContactID, * LastName = contact.LastName, * FirstName = contact.FirstName, * OrderID = order.SalesOrderID, * OrderDate = order.OrderDate * }; * foreach (var order in query) * { * Console.WriteLine("Contact ID: {0} \t Order ID: {3} \t Order date: {4} ", * order.ContactID, order.LastName, order.FirstName, * order.OrderID, order.OrderDate); * } * Console.ReadKey(); * }*/ //8 /*int orderQtyMin = 2; * int orderQtyMax = 6; * using(AdventureWorksEntities context = new AdventureWorksEntities()) * { * var query = from order in context.SalesOrderDetail * where order.OrderQty > orderQtyMin * && order.OrderQty < orderQtyMax * select new * { * SalesOrderID = order.SalesOrderID, * OrderQty = order.OrderQty * }; * foreach(var order in query) * { * Console.WriteLine("Order ID: {0} Order quantity: {1}", * order.SalesOrderID, order.OrderQty); * } * Console.ReadKey(); * }*/ //9 /*String color = "Red"; * using(AdventureWorksEntities context = new AdventureWorksEntities()) * { * var query = from product in context.Product * where product.Color == color * select new * { * Name = product.Name, * ProductNumber = product.ProductNumber, * ListPrice = product.ListPrice * }; * foreach(var product in query) * { * Console.WriteLine("Name: {0}", product.Name); * Console.WriteLine("Product Number: {0}", product.ProductNumber); * Console.WriteLine("List Price: ${0}", product.ListPrice); * Console.WriteLine(""); * } * Console.ReadKey(); * }*/ //10 /*using(AdventureWorksEntities AWEntities = new AdventureWorksEntities()) * { * int?[] productModelIds = { 19, 26, 118 }; * var products = from p in AWEntities.Product * where productModelIds.Contains(p.ProductModelID) * select p; * foreach(var product in products) * { * Console.WriteLine("{0}: {1}", * product.ProductModelID, product.ProductID); * } * Console.ReadKey(); * }*/ //11 /*using(AdventureWorksEntities context = new AdventureWorksEntities()) * { * IQueryable<Contact> sortedNames = from n in context.Contact * orderby n.LastName * select n; * Console.WriteLine("Lista ordenada por apellidos:"); * foreach(Contact n in sortedNames) * { * Console.WriteLine(n.LastName); * } * Console.ReadKey(); * }*/ //12 /*using(AdventureWorksEntities context = new AdventureWorksEntities()) * { * IQueryable<Decimal> sortedPrices = from p in context.Product * orderby p.ListPrice descending * select p.ListPrice; * Console.WriteLine("Lista de precios desde el mas alto al mas bajo"); * foreach(Decimal price in sortedPrices) * { * Console.WriteLine(price); * } * Console.ReadKey(); * }*/ //13 /*using(AdventureWorksEntities context = new AdventureWorksEntities()) * { * IQueryable<Contact> sortedContacts = from contact in context.Contact * orderby contact.LastName, contact.FirstName * select contact; * Console.WriteLine("Contactos ordenados por apellidos luego por nombre:"); * foreach(Contact sortedContact in sortedContacts) * { * Console.WriteLine(sortedContact.LastName + ", " + * sortedContact.FirstName); * } * Console.ReadKey(); * }*/ //14 /*using (AdventureWorksEntities context = new AdventureWorksEntities()) * { * var products = context.Product; * var query = from product in products * group product by product.Style into g * select new * { * Style = g.Key, * AverageListPrice = g.Average(product => product.ListPrice) * }; * foreach(var product in query) * { * Console.WriteLine("Estilo: {0} Precio promedio: {1}", * product.Style, product.AverageListPrice); * } * Console.ReadKey(); * }*/ //15 /*using(AdventureWorksEntities context = new AdventureWorksEntities()) * { * var products = context.Product; * var query = from product in products * group product by product.Color into g * select new * { * Color = g.Key, * ProductCount = g.Count() * }; * foreach(var product in query) * { * Console.WriteLine("Color = {0} \t Cantidad = {1}", * product.Color, product.ProductCount); * } * Console.ReadKey(); * }*/ //16 using (AdventureWorksEntities context = new AdventureWorksEntities()) { var orders = context.SalesOrderHeader; var query = from order in orders group order by order.Contact.ContactID into g select new { Category = g.Key, maxTotalDue = g.Max(order => order.TotalDue) }; foreach (var order in query) { Console.WriteLine("ContactID = {0} \t TotalDue maximo = {1}", order.Category, order.maxTotalDue); } Console.ReadKey(); } }