private void button4_Click(object sender, EventArgs e)
{
using (var context = new AdventureWorks2008Entities())
{
//var query = from p in context.SelectPeople()
// where p.LastName.StartsWith("Kl")
// select p;
//foreach (var per in query)
//{
// listBox1.Items.Add(string.Format("{0} {1}", per.FirstName, per.LastName));
//}
//where p.BusinessEntityID == 8
var query = (from p in context.People
where p.LastName.StartsWith("K")
select new { p.LastName, p.FirstName, p.MiddleName, p.BusinessEntityID }).Count();
//foreach (var per in query)
//{
// listBox1.Items.Add(string.Format("{0} {1}", per.FirstName, per.LastName));
//}
//var secondquery = query.Where(p => p.BusinessEntityID == 8);
//foreach (var per in secondquery)
//{
// //listBox1.Items.Add(string.Format("{0} {1}", per.FirstName, per.LastName));
// textBox1.Text = per.FirstName + " " + per.LastName;
//}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
using (var context = new AdventureWorks2008Entities())
{
var busent = context.BusinessEntities.Where(p => p.BusinessEntityID == 292).First();
var per = new Person();
per.PersonType = "SC";
per.NameStyle = true;
per.Title = "Geek";
per.FirstName = "Scott";
per.MiddleName = "L";
per.LastName = "Klein";
per.Suffix = "Mr";
per.EmailPromotion = 1;
per.rowguid = Guid.NewGuid();
per.ModifiedDate = DateTime.Now;
busent.Person = per;
context.SaveChanges();
MessageBox.Show("record inserted");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
using (var context = new AdventureWorks2008Entities())
{
var per = context.People.Where(p => p.BusinessEntityID == 292).First();
context.DeleteObject(per);
context.SaveChanges();
MessageBox.Show("record deleted");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
using (var context = new AdventureWorks2008Entities())
{
var per = context.People.Where(p => p.BusinessEntityID == 292).First();
per.Title = "Head Geek";
per.ModifiedDate = DateTime.Now;
per.PersonType = "EM";
context.SaveChanges();
MessageBox.Show("record updated");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.Message);
}
}
static void Main(string[] args)
{
AdventureWorks2008Entities context = new AdventureWorks2008Entities();
//Address address = new Address();
//address.AddressLine1 = "Rua dos Bobos, 0";
//address.AddressLine2 = "Bairro do Morais";
//address.City = "Vinicius";
//address.PostalCode = "00000-000";
//address.StateProvinceID = 1;
//address.rowguid = new Guid();
//address.ModifiedDate = DateTime.Now;
//context.AddToAddresses(address);
//Address address = (from a in context.Addresses where a.AddressID == 32525 select a).First();
//address.City = "Rio de Janeiro";
Address address = context.Addresses.Single(a => a.AddressID == 32525);
context.Addresses.DeleteObject(address);
context.SaveChanges();
}
