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 int CourseID { get; set; }
public string Title { get; set; }
public int Credits { get; set; }
public int DepartmentID { get; set; }
}
}