Trying to populate a viewmodel from ef ..i can populate the model from ef with no issue but how do I populate the related objects? I'm sure it easy solution!
IssueTracker_Issues is the database table from EF
IssueTracker_IssuesTypes is the database table related to field IssueTypeId
from IssueTracker_Issues
namespace SIMIt.Models
{
public class IssueViewModel
{
public IEnumerable<IssueViewModel> GetIssues()
{
var db = new SBHUBDBContext();
//This populates IssueViewModel but want to also populate the
related model\tables
IEnumerable<IssueViewModel> albums =
db.IssueTracker_Issues.Take(5).ToList().Select(a => new IssueViewModel
{
IssueId = a.IssueId,
IssueTitle = a.IssueTitle,
IssueStatusId = a.IssueStatusId,
IssueTypeId = a.IssueTypeId,
IssueMemberID = a.IssueStatusId,
IssueComments = a.IssueComments,
IssuePriorityId = a.IssuePriorityId
});
return albums;
}
public IssueViewModel()
{
}
public int IssueId { get; set; }
public string IssueTitle { get; set; }
public int IssueCategoryId { get; set; }
public int IssuePriorityId { get; set; }
public int IssueStatusId { get; set; }
public int IssueCreatorId { get; set; }
public int IssueOwnerId { get; set; }
public IssueTypeViewModel IssueType { get; set; } //relation
}
}
public class IssueTypeViewModel
{
public int IssueTypeId { get; set; }
public string IssueType { get; set; }
}
Anthony Salerno | Founder | SmallBiz Australia
Innovation | Web | Software | Developers | Support
Phone : +613 8400 4191 Email : 2Anthony (at) smallbiz.com.au Postal : Po
Box 135, Lower Plenty 3093 ABN : 16 079 706 737
Website : www.smallbiz.com.au <http://www.smallbiz.com.au/>
<<attachment: winmail.dat>>
