Step 3.1. Model

Step 3.1. Model

Skip and go to the next step

To access the database we will use a LINQ to SQL model. This model will contain 5 tables:

  • aspnet_Role;
  • aspnet_Users;
  • aspnet_UserInRoles;
  • Statuses;
  • Tasks.

Automatically created models (that starts from aspnet) contain many properties that we won't need. So, to simplify visual perception of the model, we'll remove the unnecessary properties.
Also, we will rename properties of the Statuse object. To be correctly processed by the scheduler, they must have names key and label.

Your actions:

  1. Create a LINQ to SQL Class with name Tasks and open it;
  2. Drag the following tables onto the design surface:
    • aspnet_Role;
    • aspnet_Users;
    • aspnet_UserInRoles;
    • Statuses;
    • Tasks.
  3. Delete unnecessary properties from the object. The properties you must leave, see in the image below.



  4. Select the Statuse object and rename the properties: id to key, text to label.




comments powered by Disqus