private IssueData GetIssueData(int id) { var issueData = new IssueData(); var context = new FirstIssueContext(); var i = (from c in context.Issues where c.IssueId == id select c).FirstOrDefault(); if (i != null) { issueData.IssueId = i.IssueId; issueData.IssueDate = i.PublishDate; issueData.IssueTitle = i.IssueName; foreach (var a in i.Articles.ToList()) { issueData.Articles.Add(new ArticleData { Author = a.Author.FullName, Id = a.ArticleId, Order = a.Order, Title = a.Title, SubTitle = string.Empty }); } } return issueData; }
private static void SetupDatabase() { // Cant use this initializer in production - got to be migrations Database.SetInitializer(new FirstIssueInitializer()); var context = new FirstIssueContext(); context.Database.Initialize(true); // context.Database.Initialize(false); }
public ApiBaseController() { _dbContext = new FirstIssueContext(); }