Update, Insert and Delete in DLINQ
Previous:
Writing Queries In DLINQ
Update, Insert and Delete in DLINQ
The following are the code samples for the Update, insert and delete operations.
Insert a new employee:
MyDbDataContext db = new MyDbDataContext(); // Init a new employee object using Object Initializer Employee emp = new Employee() { Id = 10, Name = "New Employee", DepartmentCode = 5 }; db.Employees.Add(emp); db.SubmitChanges(); |
You can see that I must create a new object before I added it to the Employee collection. After I added it, I must call the SubmitChanges method in order to commit the operation.
Delete an employee:
MyDbDataContext db = new MyDbDataContext(); Employee emp = db.Employees.Single(x => x.Id == 10); db.Employees.Remove(emp); db.SubmitChanges(); |
In this case the code is very similar to the insert operation (except that I retrieve the employee before).
Update an existing employee:
MyDbDataContext db = new MyDbDataContext(); Employee emp = db.Employees.Single(x => x.Id == 10); emp.DepartmentCode = 1; db.SubmitChanges(); |
Aspnet Discussion
- - Web application
- - Great Indian Developer Su
- - Aspx page inside Silverli
- - Open aspx page inside Sil
- - Guidance for a novice
