private void button1_Click(object sender, EventArgs e)
{
//instantiate the data set
DafestyEntities context = new DafestyEntities();
///*dataGridView1.DataSource = context.Customers.ToList();*/
//LINQ
//var q = from x in context.Customers
// where x.CustomerID == "1001"
// select x;
//rhs = objt query
//Customer c = q.First();//sql command fired here
//label1.Text = c.CustomerName;
//var qq = from x
// in context.Customers
// orderby x.CustomerName
// //where x.Age>50 && x.CustomerName.Substring(0,1) == "S"
// select new { x.CustomerID, x.CustomerName, x.MemberStatus };
//dataGridView1.DataSource = qq.ToList();
//lambda
//dataGridView1.DataSource = context.Customers.Where(x =>x.Age >=50 && x.MemberStatus == "A").ToList();
//dataGridView1.DataSource = context.Customers.Where(y => y.MemberStatus == "A").OrderBy(x => x.CustomerName).ToList();
decimal?amt = context.Customers.Sum(x => x.AmountSpent);
label1.Text = amt.ToString();
}
private void button3_Click(object sender, EventArgs e)
{
DafestyEntities context = new DafestyEntities();
//Customer c = context.Customers.Where(x => x.CustomerID == "1000").First();
//label1.Text = c.CustomerName;
//label2.Text = c.MemberStatus;
//add customer
Customer c = new Customer();
//c.CustomerID = "1007";
//c.CustomerName = "Venkat";
//c.MemberStatus = "Z";
//context.Customers.Add(c);
//deletion
context.Customers.Remove(c);
context.SaveChanges();
}
