public static void Test() { using (var dbx = new NorthwindDBContext()) { // Order by ascending var resultat = from obj in dbx.Products orderby obj.UnitPrice ascending select obj; // ----------------------------------------------- // Höj priset med 8% var result = from obj in dbx.Products select obj; double dble = 1.08; decimal d = Convert.ToDecimal(dble); foreach (var Product in dbx.Products) { Product.UnitPrice = Product.UnitPrice * d; Console.WriteLine(Product.UnitPrice); } // ----------------------- // Spara ändringar dbx.SaveChanges(); } }
public static void CustomersWithNamesLongerThan25Characters() { using (var db = new NorthwindDBContext()) { var queryResult = db.Customers.Where (x => x.CompanyName.Length > 25).Select (x => x.CompanyName); foreach (var _companyName in queryResult) { Console.WriteLine(_companyName); } } }
public static void OrdersPerEmployee() { #region ADO.NET ***** UPPFATTADE FEL!!! ******* Console.WriteLine("\n\nADO.NET ***** UPPFATTADE FEL!!!\n"); var sqlConnection = new SqlConnection(connectionString); SqlCommand cmd = sqlConnection.CreateCommand(); cmd.CommandText = "SELECT emp.FirstName + ' ' + " + " emp.LastName, COUNT(orders.OrderID)" + " FROM Employees emp" + " INNER JOIN Orders orders " + " ON emp.EmployeeID = orders.EmployeeID" + " GROUP BY emp.LastName, emp.FirstName"; sqlConnection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine("{0}: {1}", reader.GetString(0), reader.GetValue(1)); } reader.Close(); sqlConnection.Close(); #endregion #region ENTITY FRAMEWORK Console.WriteLine("\n\nENTITY FRAMEWORK\n"); using (var db = new NorthwindDBContext()) { var result = from north in db.Employees select north.FirstName + "\n" + north.Orders.Count + "\n"; foreach (var item in result.ToList()) { Console.WriteLine(item); } } #endregion }
public EmployeesController(NorthwindDBContext context) { db = context; }
public InvoiceController(NorthwindDBContext context) { db = context; }
public NorthwindService(NorthwindDBContext context) { dbContext = context; }
public CategoryRepo(NorthwindDBContext db) { _db = db; }
public CustomersController(NorthwindDBContext context) { _context = context; }