对象不包含定义?GetPosts,评论,评论,用户,帖子,SaveChanges,子评论, [英] Object Doesnot contain the defination?GetPosts , Comments , Comment , Users , Posts , SaveChanges , SubComments ,

查看:56
本文介绍了对象不包含定义?GetPosts,评论,评论,用户,帖子,SaveChanges,子评论,的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

使用Borker92.Models;

使用System.Data.Entity;

使用System.Linq;

使用System.Web.Mvc ; $


命名空间Borker92.Controllers

{

   公共类GetPostController:控制器

    {

       私有对象dbContext;



        //获取:GetPost为
        public ActionResult GetPosts()

        {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; IQueryable的< PostsVM>帖子= DbContext.GetPosts

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;。选择(p值=>新建PostsVM

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; {

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;帖子ID = p.PostID,

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;消息= p.Message,

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP; PostedDate = p.PostedDate.Value

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;       })。AsQueryable();



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;返回查看(帖子);

  &NBSP; &NBSP; &NBSP; }




$
  &NBSP; &NBSP; &NBSP; public PartialViewResult GetComments(int postId)

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; IQueryable的< CommentsVM> comments = dbContext.Comments.Where(c => c.Post.PostID == postId)

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;。选择(C =>新建CommentsVM

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP; {

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP; ComID = c.ComID,

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; CommentedDate = c.CommentedDate.Value,

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; CommentMsg = c.CommentMsg,

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;用户=新UserVM

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;         &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   UserID = c.User.UserID,

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  用户名= c.User.Username,

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   imageProfile = c.User.imageProfile

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  }

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  })。AsQueryable();



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;返回PartialView(&〜/ Views / Shared / MyComments.cshtml",comments);

  &NBSP; &NBSP; &NBSP; }




  &NBSP; &NBSP; &NBSP; [HttpPost]

  &NBSP; &NBSP; &NBSP; public ActionResult AddComment(CommentsVM comment,int postId)

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; // bool result = false;  

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;评论commentEntity = null;

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; int userId =(int)Session [" UserID"];



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; var user = dbContext.Users.FirstOrDefault(u => u.UserID == userId);

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; var post = dbContext.Posts.FirstOrDefault(p => p.PostID == postId);



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; if(评论!= null)

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {

$
  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; commentEntity = new EDMX.Comment

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; CommentMsg = comment.CommentMsg,

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; CommentedDate = comment.CommentedDate,

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }




  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; if(user!= null&& post!= null)

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; post.Comments.Add(commentEntity);

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; user.Comments.Add(commentEntity);



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; dbContext.SaveChanges();

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; // result = true;  

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }


  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; return RedirectToAction(" GetComments"," Comments",new {postId = postId});

  &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; &NBSP; &NBSP; [HttpGet]

  &NBSP; &NBSP; &NBSP; public PartialViewResult GetSubComments(int ComID)

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; IQueryable的< SubCommentsVM> subComments = dbContext.SubComments.Where(sc => sc.Comment.ComID == ComID)

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;。选择(SC =>新建SubCommentsVM

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;&NBSP;&NBSP;&NBSP; {

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; SubComID = sc.SubComID,

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; CommentMsg = sc.CommentMsg,

&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; CommentedDate = sc.CommentedDate.Value,

&NBSP;&NBSP;&NBSP; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;用户=新UserVM

     & NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   UserID = sc.User.UserID,

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  用户名= sc.User.Username,

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;   imageProfile = sc.User.imageProfile

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  }

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  })。AsQueryable();



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;返回PartialView(&〜/ Views / Shared / MySubComments.cshtml",subComments);



  &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; }

}

解决方案
您引用dbContext.SubComments但在的DbContext你的文件的顶部被定义为对象。对象没有任何这些成员,因此错误。您的dbContext变量需要定义为您定义
的任何(DbContext派生)类型。这看起来像EF代码,因此它将是您创建的EF DbContext,然后添加您的各种DbSet< ...>属性为。


using Borker92.Models;
using System.Data.Entity;
using System.Linq;
using System.Web.Mvc;

namespace Borker92.Controllers
{
    public class GetPostController : Controller
    {
        private object dbContext;

        // GET: GetPost
        public ActionResult GetPosts()
        {
            IQueryable<PostsVM> Posts = DbContext.GetPosts
                                             .Select(p => new PostsVM
                                             {
                                                 PostID = p.PostID,
                                                 Message = p.Message,
                                                 PostedDate = p.PostedDate.Value
                                             }).AsQueryable();

            return View(Posts);
        }



        public PartialViewResult GetComments(int postId)
        {
            IQueryable<CommentsVM> comments = dbContext.Comments.Where(c => c.Post.PostID == postId)
                                     .Select(c => new CommentsVM
                                     {
                                         ComID = c.ComID,
                                         CommentedDate = c.CommentedDate.Value,
                                         CommentMsg = c.CommentMsg,
                                         Users = new UserVM
                                         {
                                             UserID = c.User.UserID,
                                             Username = c.User.Username,
                                             imageProfile = c.User.imageProfile
                                         }
                                     }).AsQueryable();

            return PartialView("~/Views/Shared/MyComments.cshtml", comments);
        }


        [HttpPost]
        public ActionResult AddComment(CommentsVM comment, int postId)
        {
            //bool result = false;  
            Comment commentEntity = null;
            int userId = (int)Session["UserID"];

            var user = dbContext.Users.FirstOrDefault(u => u.UserID == userId);
            var post = dbContext.Posts.FirstOrDefault(p => p.PostID == postId);

            if (comment != null)
            {

                commentEntity = new EDMX.Comment
                {
                    CommentMsg = comment.CommentMsg,
                    CommentedDate = comment.CommentedDate,
                };


                if (user != null && post != null)
                {
                    post.Comments.Add(commentEntity);
                    user.Comments.Add(commentEntity);

                    dbContext.SaveChanges();
                    //result = true;  
                }
            }

            return RedirectToAction("GetComments", "Comments", new { postId = postId });
        }
        [HttpGet]
        public PartialViewResult GetSubComments(int ComID)
        {
            IQueryable<SubCommentsVM> subComments = dbContext.SubComments.Where(sc => sc.Comment.ComID == ComID)
                                       .Select(sc => new SubCommentsVM
                                       {
                                           SubComID = sc.SubComID,
                                           CommentMsg = sc.CommentMsg,
                                           CommentedDate = sc.CommentedDate.Value,
                                           User = new UserVM
                                           {
                                               UserID = sc.User.UserID,
                                               Username = sc.User.Username,
                                               imageProfile = sc.User.imageProfile
                                           }
                                       }).AsQueryable();

            return PartialView("~/Views/Shared/MySubComments.cshtml", subComments);

        }
    }
}

解决方案

You are referencing dbContext.SubComments but dbContext at the top of your file is defined to be object. Object doesn't have any of these members, hence the error. Your dbContext variable needs to be defined as whatever (DbContext-derived) type you have defined. This looks like EF code so it'll be the EF DbContext you created and then added your various DbSet<…> properties to.


这篇关于对象不包含定义?GetPosts,评论,评论,用户,帖子,SaveChanges,子评论,的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆