public void Button1_Click(object sender, EventArgs e)
{
using (var db = new DBStafEntities())
{
var Customer = db.Customers.Select(c => new { c.Name, Phone = c.Telephone_Number, ID = c.CustomerId });
dataGridView1.DataSource = Customer.ToList();
db.SaveChanges();
}
using (var db = new DBStafEntities())
{
var Order = db.Orders.Select(o => new
{
Data = o.OrderDate,
Product = o.Product_Description,
id = o.OrderId
});
dataGridView2.DataSource = Order.ToList();
}
using (var db = new DBStafEntities())
{
var Cars = db.Cars.Select(o => new { o.Marka, o.Owner, o.Price, id = o.CarId });
dataGridView4.DataSource = Cars.ToList();
}
}
// using (var db = new DBStafEntities())
// {
// var query = db.Customers.Select(c => new
// {
// ID_order = c.CustomerId,
// c.Name,
// Phone = c.Telephone_Number,
// });
// dataGridView1.DataSource = query.ToList();
// }
// using (var db = new DBStafEntities())
// {
// var query = db.Orders.Select(o => new
// {
// ID_customer = o.OrderId,
// Data = o.OrderDate,
// Product = o.Product_Description
// });
//dataGridView2.DataSource = query.ToList();
// }
// using (DBStafEntities db = new DBStafEntities())
// {
// var Query = db.Customers.Join(db.Orders, customers => customers.CustomerId, orders => orders.OrderId,
// ((customers, orders) => new
// {
// Name = customers.Name,
// Phone = customers.Telephone_Number,
// Data = orders.OrderDate,
// Product = orders.Product_Description
// }));
//dataGridView1.DataSource = Query.ToList();
// }
private void Button2_Click(object sender, EventArgs e)
{
using (var db = new DBStafEntities())
{
var Query = from customers in db.Customers
join cars in db.Cars on customers.CustomerId equals cars.CarId // Добавленны данные по таблицам
join orders in db.Orders on customers.CustomerId equals orders.OrderId
select new
{
customers.Name,
Phone = customers.Telephone_Number,
Id = customers.CustomerId,
cars.Marka,
cars.Price,
cars.Owner,
Data = orders.OrderDate,
Product = orders.Product_Description,
CustomerId = orders.CustomerID,
orders.OrderId
};
dataGridView3.DataSource = Query.ToArray();
}
}