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