无效的列名C# - c#

我对C＃和Visual Studio MVC还是很陌生，并且正在从事一个简单的项目，在该项目中，我需要实现可以通过表单发布的评论页面（我尚未实现）。这是我的问题，我不断收到“无效列ID”错误。我一直在网上查找所有答案，但没有找到能解决我问题的任何东西。我来自Java，因此某些概念对我而言并不十分明显，尤其是自从昨天开始以来。

这是我的上下文：

namespace MonLivredor.Models {
public class CommentaireContext: DbContext {
    public CommentaireContext() {}
    public IDbSet < Commentaire > Liste {
        get;
        set;
    }
    protected override void OnModelCreating(DbModelBuilder modelBuilder) {
        Database.SetInitializer < CommentaireContext > (null);
        base.OnModelCreating(modelBuilder);
       }
   }
}

这是我的控制器：

using MonLivredor.Models;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace MonLivredor.Controllers
{
public class CommentaireController : Controller
{
    private CommentaireContext context = new CommentaireContext();
    // GET: Commentaire
    public ActionResult Commentaire()
    {

        Commentaire com1 = new Commentaire("Jacky", "[email protected]", "Bonjour je m'apelle Jacky et j'aime le C#");
        Commentaire com2 = new Commentaire("Bobby", "[email protected]", "Bonjour je m'apelle Bobby et je deteste le Java");

        if (context.Liste.Count() == 0)
        {
            context.Liste.Add(com1);
            context.Liste.Add(com2);
            context.SaveChanges();
            return View(context);
        }
        else
        {
            return View(context);
        }
    }

模型：

namespace MonLivredor.Models
{
[Table("Commentaires")]
public class Commentaire 
{
    [Key]
    public int ID { get; set; }
    [Required]
    public String Nom { get; set; }
    public String Mail { get; set; }
    public String Message { get; set; }
    public DateTime date;
    public int i = 0;

    public Commentaire(String nom, String mail, String message)
    {
        date = DateTime.Now;
        this.Nom = nom;
        this.Mail = mail;
        this.Message = message;
        ID = i;
        i++;
    }

    public Commentaire()
    {
        date = DateTime.Now;
    }


}
}

在我看来，我只希望能够看到以下消息：

@model MonLivredor.Models.CommentaireContext
<h1>Commentaires</h1>

<tr>
@foreach (var com in Model.Liste)
{
    <td>
        <a href="mailto:com.Mail">@com.Nom  @com.date</a>
        <p>@com.Message</p>
    </td>

}
</tr>

抱歉，代码混乱，我已经把它弄乱了，答案可能很愚蠢。收到错误后，我将重定向到该行的视图页面：

@foreach (var com in Model.Liste)

错误“无效的列名称ID”。

堆栈跟踪：

[SqlException (0x80131904): Invalid column name 'ID'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2442126
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5736904
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +628
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +3731
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58
   System.Data.SqlClient.SqlDataReader.get_MetaData() +89
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +379
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2026
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +375
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +240
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +12
   System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c) +9
   System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch(TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) +72
   System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) +356
   System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior) +166
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +12
   System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +37

[EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.]
   System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +112
   System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute(ObjectContext context, ObjectParameterCollection parameterValues) +744
   System.Data.Entity.Core.Objects.<>c__DisplayClass7.<GetResults>b__6() +97
   System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) +288
   System.Data.Entity.Core.Objects.<>c__DisplayClass7.<GetResults>b__5() +154
   System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +189
   System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +279
   System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() +11
   System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() +45
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +381
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +58
   MonLivredor.Controllers.CommentaireController.Commentaire() in C:\Users\Bob\documents\visual studio 2015\Projects\MonLivredor\MonLivredor\Controllers\CommentaireController.cs:26
   lambda_method(Closure , ControllerBase , Object[] ) +62
   System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +14
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +157
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
   System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +22
   System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +32
   System.Web.Mvc.Async.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d() +50
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +225
   System.Web.Mvc.Async.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +34
   System.Web.Mvc.Async.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() +26
   System.Web.Mvc.Async.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult) +100
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +27
   System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +13
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +36
   System.Web.Mvc.Controller.<BeginExecute>b__15(IAsyncResult asyncResult, Controller controller) +12
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +22
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +26
   System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10
   System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState) +21
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +28
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9744373
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

谢谢你的帮助

参考方案

您应该直接在View中将DbContext类用作模型。您的控制器操作应负责使用DbContext从数据库获取数据并将其传递给View。您的操作方式不会提供Model View Controller模式的好处，而是您正在滥用MVC模式。视图应该只知道它将从控制器接收什么类型的模型，现在在您看来，数据获取代码不是正确的方法。

您做错了几件事，首先在View中的模型声明应为List<MonLivredor.Models.Commentaire>，因此请将其更改为：

@model List<MonLivredor.Models.Commentaire>
<h1>Commentaires</h1>

<tr>
@foreach (var com in Model)
{
    <td>
        <a href="mailto:com.Mail">@com.Nom  @com.date</a>
        <p>@com.Message</p>
    </td>

}

然后在您的操作中有很多问题，您需要从数据库中查询结果，如果没有结果，那么在添加这两项之后，您可以再次从数据库中查询结果：

public ActionResult Commentaire()
{
    IQueryable<Commentaire> result = context.Liste;
    if (!result.Any())
    {

        context.Liste.Add(new Commentaire("Jacky", "[email protected]", "Bonjour je m'apelle Jacky et j'aime le C#"));
        context.Liste.Add(new Commentaire("Bobby", "[email protected]", "Bonjour je m'apelle Bobby et je deteste le Java"));
        context.SaveChanges();

    }

    return View(result.ToList());
}

您还需要将模型构造函数更改为：

public Commentaire(int id,String nom, String mail, String message)
{
    date = DateTime.Now;
    this.Nom = nom;
    this.Mail = mail;
    this.Message = message;
    ID = id;
}

并从控制器或其他选项传递ID值，更好的办法是使数据库自动生成ID列值，这可以使用@bilpor答案完成，但是在更新模型后，您将必须运行迁移至使用新更改更新表。

System.Web.Mvc.HtmlHelper不包含“ DropDownListFor”的定义 - c#

我收到如下所示的运行时异常，编译源代码未显示任何问题。 @ html.TextBoxFor（）不会发生此问题，为什么DropDownListFor会发生这种情况？@Html.DropDownListFor(m => m.EView.EStatusId, @Model.EView.EStatus) public class EView { #region…

Java中的<<或>>>是什么意思？ - java

This question already has answers here: Closed 7 years ago. Possible Duplicate: What does >> and >>> mean in Java?我在一些Java代码中遇到了一些陌生的符号，尽管代码可以正确编译和运行，但对于括号在此代码中的作用却感…

菱形运算符<>是否等于<？> - java

我在util.TreeSet类中发现，其中一个构造函数正在使用具有空泛型类型的新TreeMap调用另一个构造函数。 public TreeSet(Comparator<? super E> comparator) { this(new TreeMap<>(comparator)); } new TreeMap<>是什么意思…

声纳测试用例失败 - java

我正在尝试为我的项目之一获得声纳报告。我已经运行mvn clean installRunning blah.blah.BlahTest1 Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.016 sec Running blah.blah.BlahTest2 Tests run…

休眠映射<键，设置<值>> - java

我有以下表格：@Entity @Table(name = "events") Event --id --name @Entity @Table(name = "state") State --id --name @Entity @Table(name = "action") Action --id …

推荐标签：, , ,

腾讯的同事天天给我安利让我看《三体》，说马化腾和雷军也在…

腾讯的同事天天给我安利让我看《三体》，说马化腾和雷军也在看。自己强行看了两个月，全部给看完了。感觉这文笔也就我读初中的水平……而且写着国内的一些情况，外国人能理解吗？这书为什么会这么火？这水平我也可以去写呀[笑哭][笑哭][笑哭] 招商银行员工：可以写赶紧写一个啊，能拿科幻文学雨果奖。 包清白：哦 楼主：pei ！tui ！你也配姓龙 楼主：@赵龙王 呵呵 […]