protected void DeleteRecord(object sender, EventArgs e)
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
PersonalDetail p = db.PersonalDetails.Where(pp => pp.AutoId.Equals(52)).FirstOrDefault();
db.PersonalDetails.DeleteObject(p);
db.SaveChanges();
}
lblMessage.Text = "Record delete from the database successfully!";
}
protected void SaveUsingLinqWithTransaction(object sender, EventArgs e)
{
using (TransactionScope scope = new TransactionScope())
{
try
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
PersonalDetail p = new PersonalDetail()
{
Active = true,
Age = int.MaxValue,
FirstName = "firstnamne",
LastName = "lastname"
};
db.PersonalDetails.AddObject(p);
db.SaveChanges();
DemoDatabaseModel.Menu m = new DemoDatabaseModel.Menu()
{
MenuDescription = "description1",
MenuName = "Menu1Menu1Menu1Menu1Menu1Menu1Menu21", //Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1",
MenuUrl = "http://www.fundooVideo.com/",
ParentMenuId = 1,
MenuId = 127
};
db.Menus.AddObject(m);
db.SaveChanges();
}
scope.Complete();
}
catch (Exception ee)
{
Response.Write(ee.ToString());
}
}
}
protected void UpdateRecord(object sender, EventArgs e)
{
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
PersonalDetail p = db.PersonalDetails.Where(pp => pp.AutoId.Equals(52)).FirstOrDefault();
p.Active = false;
p.Age = 30;
p.FirstName = "Ranjit modified";
p.LastName = "Mahato modified";
db.SaveChanges();
}
lblMessage.Text = "Record updated to the database successfully!";
}
protected void InsertRecord(object sender, EventArgs e)
{
PersonalDetail p = new PersonalDetail()
{
Active = true,
Age = 20,
FirstName = "Ranjit",
LastName = "Mahato"
};
using (DemoDatabaseDB db = new DemoDatabaseDB())
{
db.PersonalDetails.AddObject(p);
db.SaveChanges();
}
lblMessage.Text = "Record added to the database successfully!";
}