public class MallDbContext : DbContext
    {
        public MallDbContext()
            : base("name=DbContext")
        {

        }
        public IDbSet<Category> Category { get; set; }
        public IDbSet<Product> Product { get; set; }
    }
    public class Product
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public string Remark { get; set; }
        public string CategoryId { get; set; }
        public virtual Category Category { get; set; }

    }
    public class Category
    {
        public string Id { get; set; }
        public string Name { get; set; }
        public string MetaTile { get; set; }
        public virtual ICollection<Product> Products { get; set; }
    }

public ActionResult Index()
        {
            Database.SetInitializer<MallDbContext>(null);
            var db = new MallDbContext();
            db.Configuration.AutoDetectChangesEnabled = true;
            db.Configuration.LazyLoadingEnabled = true;
            var query = db.Product.Where(c => c.Category.Name.Contains("临床")).AsEnumerable();
            return View(query);
        }

@model IEnumerable<MvcApplication2.Models.DataModel.Product>

@foreach (var item in Model)
{
    <div>
        产品名称：@item.Name  分类名称：@item.Category.Name
    </div>
}

SELECT 
    [Extent1].[Id] AS [Id], 
    [Extent1].[Name] AS [Name], 
    [Extent1].[Remark] AS [Remark], 
    [Extent1].[CategoryId] AS [CategoryId]
    FROM  [dbo].[Products] AS [Extent1]
    INNER JOIN [dbo].[Categories] AS [Extent2] ON [Extent1].[CategoryId] = [Extent2].[Id]
    WHERE [Extent2].[Name] LIKE N'%临床%'

exec sp_executesql N'SELECT 
    [Extent1].[Id] AS [Id], 
    [Extent1].[Name] AS [Name], 
    [Extent1].[MetaTile] AS [MetaTile]
    FROM [dbo].[Categories] AS [Extent1]
    WHERE [Extent1].[Id] = @EntityKeyValue1',N'@EntityKeyValue1 nvarchar(128)',@EntityKeyValue1=N'00013cf0-e746-4f09-a6a2-1719c8eb5e84'