C#和EF无法将相关实体添加到模型中

我想获得包含标签的帖子列表。

我有模型:

public class BlogPostGetByUrlSlugDto
{
    public int Id { get; set; }
    public string Title { get; set; }
    public string Category { get; set; }
    public string Color { get; set; }
    public string UrlSlug { get; set; }
    public string Description { get; set; }
    public IList<BlogTagGetByPostIdDto> Tags { get; set; }
}

public class BlogTagGetByPostIdDto
{
    public string Name { get; set; }
    public string UrlSlug { get; set; }
}

到目前为止，我的代码:

public BlogPostGetByUrlSlugDto GetByUrlSlug(string urlSlug)
{
    var blogPostQuery = _blogPostRepository.Query;

    return blogPostQuery
                .Where(b => b.UrlSlug.Equals(urlSlug))
                .ToList()
                .Select(bp => new BlogPostGetByUrlSlugDto
                {
                    Id = bp.Id,
                    Title = bp.Title,
                    Category = bp.BlogCategory.Name,
                    Color = bp.BlogCategory.Color,
                    UrlSlug = bp.UrlSlug,
                    Description = bp.Description,
                    Tags = bp.BlogTags.Select(t => new BlogTagGetByPostIdDto
                                        {
                                            Name = t.Name,
                                            UrlSlug = t.UrlSlug
                                        })
                                        .ToList()
                })
                .Single();
}

我在Object reference not set to an instance of an object行中得到.Select(bp => new BlogPostGetByUrlSlugDto。

知道为什么吗？
_blogPostRepository.Query的存储库是:

public interface IRepository<T> where T : class
{
    T FindById(int id, bool asNoTracking = false);

    T FindSingle(Expression<Func<T, bool>> predicate = null, bool asNoTracking = false, params Expression<Func<T, object>>[] includes);

    IQueryable<T> Find(Expression<Func<T, bool>> predicate = null, bool asNoTracking = false, params Expression<Func<T, object>>[] includes);


    /// <summary>
    /// Add entity to the repository
    /// </summary>
    /// <param name="entity">The entity to add</param>
    void Add(T entity);

    /// <summary>
    /// Attach entity to the repository
    /// </summary>
    /// <param name="entity">The entity to attach</param>
    void Attach(T entity);

    bool Exists(T entity);

    /// <summary>
    /// Updates entity within the repository
    /// </summary>
    /// <param name="entity">The entity to update</param>
    void Update(T entity, bool partial = false);


    /// <summary>
    /// Mark entity by id to be deleted within the repository
    /// </summary>
    /// <param name="entity">The entity to delete</param>
    void Delete(object id);


    /// <summary>
    /// Mark entity to be deleted within the repository
    /// </summary>
    /// <param name="entity">The entity to delete</param>
    void Delete(T entity);


    /// <summary>
    /// Get an item matching the id
    /// </summary>
    T GetById(int id);

    /// <summary>
    /// Get an item or itens matching the Expression including opcional parameters
    /// </summary>
    IList<T> Get(Expression<Func<T, bool>> filter = null, Func<IQueryable<T>, IOrderedQueryable<T>> orderBy = null, string includeProperties = "");

    /// <summary>
    /// Get an item matching to prediate
    /// </summary>
    //T Get(Func<T, bool> predicate);


    /// <summary>
    /// Get all the itens matching to prediate
    /// </summary>
    IList<T> GetAll(Func<T, bool> predicate);


    ///// <summary>
    ///// Get all the element of this repository
    ///// </summary>
    ///// <returns>Entities list</returns>
    IList<T> GetAll();


    /// <summary>
    /// Allow to send Linq queries to the entity
    /// </summary>
    IQueryable<T> Query { get; }


    /// <summary>
    /// Saves the pending changes back into the DataContext.
    /// </summary>
    void Save();
}

查询的实现:

public class Repository<T> : IRepository<T> where T : class
{
    protected DbContext _dataContext;
    protected DbSet<T> _dbSet;

    public virtual IQueryable<T> Query
    {
        get
        {
            return _dbSet;
        }
    }
}

最佳答案

要在主查询中加载实体(此过程称为eager loading)，可以使用 Include() method并将集合作为表达式传递。

要使用Entity Framework的某些扩展，请记住添加以下 namespace :

using System.Data.Entity;

例如，尝试以下操作:

var result = _blogPostRepository.Query
                               .Where(b => b.UrlSlug.Equals(urlSlug))
                               .Include(b => b.Tags)
                               .Select(bp => new BlogPostGetByUrlSlugDto
                                {
                                    Id = bp.Id,
                                    Title = bp.Title,
                                    Category = bp.BlogCategory.Name,
                                    Color = bp.BlogCategory.Color,
                                    UrlSlug = bp.UrlSlug,
                                    Description = bp.Description,
                                    Tags = bp.Tags.Select(t => new BlogTagGetByPostIdDto
                                                        {
                                                            Name = t.Name,
                                                            UrlSlug = t.UrlSlug
                                                        })
                                })
                                .FirstOrDefault();

return result;

由于您调用ToList或Single或FistOrDefault方法，因此它将执行查询到数据库。在您的代码中，您调用ToList()，它将执行数据库中的查询并为标签执行每个查询(延迟加载)。

阅读本文以了解更多有关如何引导Earger/Lazy加载的信息。
http://msdn.microsoft.com/en-us/data/jj574232.aspx