C#

Nathan Minier wrote:

EF Code first does not support views, and you cannot use views as entities.

public class User //persistence model
{
   public string UserName {get;set;}
   public string PasswordHash {get;set;}
   public DateTime Created { get; set; }
   public int RoleId { get; set}

   [Foreginkey("Role")
   public virtual Role Role { get; set;}
}

public class Role // persistence model
{
   public int Id { get; set; }
   public string Title { get; set; }
   public int GroupId {get; set; }

   [ForeignKey("GroupId")]
   public virtual Group AssignedGroup {get; set;} //not gonna bother defining past here

   public virtual ICollection<User> Users { get; set; }
}

public class UserViewModel //view model with specific projections
{
   public string UserName {get;set;}
   public string Role {get; set;}
   public DateTime Created { get; set; } 

   public UserViewModel(){}
   public UserViewModel(User user)
   {
      UserName = user.UserName;
      Role = user.Role.Title;
      Created = user.Created;
   }
}

public class UserController: ApiController //WebAPI2 sample for SNGs
{
   ...
   public IEnumerable<UserViewModel> GetUsers()
   {
      return myDbContext.Users.Select(x => new UserViewModel(x)).ToArray(); //Database call is made here
   }
}

public partial class CreateYourViewMigration : DbMigration
{
    public override void Up()
    {
        const string script = @"CREATE VIEW dbo.YourView As ...";
        var context = new YourContext();
        context.Database.ExecuteSqlCommand(script);
    }

    public override void Down()
    {
        const string script = @"DROP VIEW dbo.YourView;";
        var context = new YourContext();
        context.Database.ExecuteSqlCommand(script);
    }
}