Custom Insert/Update on LinqToSql and ASP.NET Dynamic Data

ASP.NET Dynamic Data brings major usability and RAD development changes to the existing ASP.NET data controls. RAD development is significantly increased by the use of a rich scaffolding framework.

If you want to create a custom insert or update for ASP.NET Dynamic data and LinqToSQL then you will have to perform the following steps:
1) Create a partial class for the entity you want to make the insert/update custom. For example if you had a table name employees then your code would look like this:

[ScaffoldTable(true)]
public partial class Employees
{
}

2) Create a Metadata for that class - EmployeesMetadata. Now your code should look like this:

[MetadataType(typeof(EmployeesMetadata))]
[ScaffoldTable(false)]
public partial class Employees
{
    class EmployeesMetadata
    {
        [DisplayName("Person's title")]
        public object Title { get; set; }
    }
}
  

Note: I prefer to put the metadata inside the object which is using it, but you can put it outside. I chose to put it inside because otherwise it will be visible through all the namespace however it is intended to be used only in one place.

3) Now that we have the class above we are able to create our custom Insert and Update methods. Add these methods to the our existing Employees partial class.

Insert Method Code:

public static void Insert(employee instance)
{
     var db = new BasicModelDataContext();

     var employee = new employee
     {
           Title = "myCustomTitle " + instance.Title, // Add "myCustomTitle" string to the existing employee Title inserted from the page
           Name = "My Custom Name" + instance.Name
     };

     db.employees.InsertOnSubmit(employee);
     db.SubmitChanges();
}

Update Method Code:

public static void Update(view_service_point instance)
{
     var db = new BasicModelDataContext();

     var employee=
     db.employees.Where(e => e.id == instance.id).FirstOrDefault();

     employee.Title = instance.Title + " Custom Update";
     employee.Name = instance.Name + "Custom Update";

     db.SubmitChanges();
}

4) Now that you have these two methods that doesn't mean that LinqToSQL will use them instead of the original insert and update action. We need to tell it to use our methods instead. To do that we will need to modify the DataContext. My DataContext's name is "MyDataContext". we need to indicate that instead of insert do our custom insert and instead of update do our custom update.

Code:

public partial class BasicModelDataContext : DataContext
{
        partial void InsertEmployee(Employee instance)
        {
            Employee.Insert(instance);
        }

        partial void UpdateEmployee(Employee instance)
        {
             Employee.Update(instance);
        }
}

This was the final changes, now you have the custom insert and update working.

Any questions let me know.