Model Class: CourseByTitle.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.Course table.
    /// The SqlParameter attribute defines an argument: titleArgument.
    /// The SqlWhere attribute defines the SQL Where clause using the titleArgument argument.
    /// </summary>
    [SqlParameter("titleArgument", typeof(string))]
    [Table("Course", Schema = "dbo")]
    [SqlWhere("Title = :titleArgument")]
    public class CourseByTitle
    {
        [Key]
        public Int32 CourseID { get; set; }

        public String Title { get; set; }

        public Int32 Credits { get; set; }

        public Int32 DepartmentID { get; set; }

    }
}