Model Class: CourseInstructorInfo.cs
using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SnapObjects.Data;
namespace Appeon.ApiDoc.Models.School
{
/// <summary>
/// This model class maps to the dbo.CourseInstructor table.
/// It uses the primary key to generate the Where clause for the Update operation.
/// The SqlParameter attribute defines an argument: courseId.
/// The SqlWhere attribute defines the SQL Where clause using the courseId argument.
///
/// CourseID and PersonID are the primary keys.
/// </summary>
[SqlParameter("courseId", typeof(int))]
[Table("CourseInstructor", Schema = "dbo")]
[UpdateWhereStrategy(UpdateWhereStrategy.KeyColumns)]
[SqlWhere("CourseID = :courseId")]
public class CourseInstructorInfo
{
[Key]
public int CourseID { get; set; }
[Key]
public int PersonID { get; set; }
}
}