CODEWITHSUNDEEP
c#.netdatabaseentity-frameworkrazor
Arrow
Arrow

Reputation: 2924

Invalid Column name - but it isn't

I am getting an "Invalid column" error when I try to view a webpage that displays product data in a WebGrid.

I am currently running a live version of the exact same code, which works. However, this local version isn't working for this 1 particular page.

enter image description here

As you can see, the code referenced in the picture below exactly matches the Column name depicted beneath the error message.

I'm completely stumped. I have no clue what to do right now. It's telling me "invalid column", but it isn't. It's there, and I triple-checked for any spelling errors in my code (which is below), and everything is fine!

What gives?

<div id="grid">
  @grid.GetHtml(
    headerStyle : "HeaderStyle",
    columns: grid.Columns(
      grid.Column(
        columnName : "PartNumber",
        header : "Part Number",
        style : "PartNumberStyle"
      ),
      grid.Column(
        columnName : "Product",
        header : "Description"
      ),
      grid.Column(
        columnName : "Quantity",
        header : "Quantity"
      ),
      grid.Column(
        columnName : "ZincPlatedCL2UnitPrice",
        header : "Zinc Plated CL2 Unit Price",
        format: @<a href="?Action=Add&PartNumber=@item["PartNumber"]&Product=@item["Product"]&Type=Zinc Plated CL2 Unit Price&Units=1&UnitPrice=@item["ZincPlatedCL2UnitPrice"]&IsBoxed=0">@item["ZincPlatedCL2UnitPrice"]</a>
      ),
      grid.Column(
        columnName : "ZincPlatedCL2BoxPrice",
        header : "Zinc Plated CL2 Box Price",
        format: @<a href="?Action=Add&PartNumber=@item["PartNumber"]&Product=@item["Product"]&Type=Zinc Plated CL2 Box Price&Units=1&BoxPrice=@item["ZincPlatedCL2BoxPrice"]&IsBoxed=1">@item["ZincPlatedCL2BoxPrice"]</a>
      )
    )
  )
</div>
Stack trace

[InvalidOperationException: Invalid column name "ZincPlatedCL2UnitPrice".]
WebMatrix.Data.DynamicRecord.VerifyColumn(String name) +17193
WebMatrix.Data.DynamicRecord.get_Item(String name) +17
WebMatrix.Data.DynamicRecord.TryGetMember(GetMemberBinder binder, Object& result) +7 CallSite.Target(Closure , CallSite , Object ) +140 System.Dynamic.UpdateDelegates.UpdateAndExecute1(CallSite site, T0 arg0) +432
Microsoft.Internal.Web.Utils.DynamicHelper.GetMemberValue(Object obj, String memberName) +26
Microsoft.Internal.Web.Utils.DynamicHelper.TryGetMemberValue(Object obj, String memberName, Object& result) +24
System.Web.Helpers.WebGridRow.TryGetMember(String memberName, Object& result) +57 System.Web.Helpers.WebGridRow.get_Item(String name) +58 CallSite.Target(Closure , CallSite , Object , String ) +100
System.Dynamic.UpdateDelegates.UpdateAndExecute2(CallSite site, T0 arg0, T1 arg1) +685
ASP.<>c__DisplayClass1f.b__1c(TextWriter __razor_template_writer) in c:\Users\Jase\Documents\Visual Studio 2012\WebSites\One Stop Fasteners\Shared\Products\TekScrews\SelfDrillingMetalUseCL2.cshtml:98 System.Web.WebPages.HelperResult.WriteTo(TextWriter writer) +10
System.Web.Helpers.<>c__DisplayClass10.b__f(TextWriter tw) +42 System.Web.WebPages.HelperResult.ToString() +82
System.Web.Helpers.<>c__DisplayClass4.b__3(TextWriter __razor_helper_writer) +1444 System.Web.WebPages.HelperResult.ToString() +82
System.Web.WebPages.HelperResult.ToHtmlString() +9
System.Web.HttpUtility.HtmlEncode(Object value) +38
System.Web.WebPages.WebPageBase.Write(Object value) +68
ASP._Page_Shared_Products_TekScrews_SelfDrillingMetalUseCL2_cshtml.Execute() in c:\Users\Jase\Documents\Visual Studio 2012\WebSites\One Stop Fasteners\Shared\Products\TekScrews\SelfDrillingMetalUseCL2.cshtml:82 System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +197
System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +69 System.Web.WebPages.WebPage.ExecutePageHierarchy() +151 System.Web.WebPages.StartPage.RunPage() +17 System.Web.WebPages.StartPage.ExecutePageHierarchy() +62
System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +76
System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContextBase httpContext) +114

-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17626 Stack Trace:

[InvalidOperationException: Invalid column name "ZincPlatedCL2UnitPrice".]
WebMatrix.Data.DynamicRecord.VerifyColumn(String name) +17193
WebMatrix.Data.DynamicRecord.get_Item(String name) +17
WebMatrix.Data.DynamicRecord.TryGetMember(GetMemberBinder binder, Object& result) +7 CallSite.Target(Closure , CallSite , Object ) +140 System.Dynamic.UpdateDelegates.UpdateAndExecute1(CallSite site, T0 arg0) +432
Microsoft.Internal.Web.Utils.DynamicHelper.GetMemberValue(Object obj, String memberName) +26
Microsoft.Internal.Web.Utils.DynamicHelper.TryGetMemberValue(Object obj, String memberName, Object& result) +24
System.Web.Helpers.WebGridRow.TryGetMember(String memberName, Object& result) +57 System.Web.Helpers.WebGridRow.get_Item(String name) +58 CallSite.Target(Closure , CallSite , Object , String ) +100
System.Dynamic.UpdateDelegates.UpdateAndExecute2(CallSite site, T0 arg0, T1 arg1) +685
ASP.<>c__DisplayClass1f.b__1c(TextWriter __razor_template_writer) in c:\Users\Jase\Documents\Visual Studio 2012\WebSites\NameRemoved\Shared\Products\TekScrews\SelfDrillingMetalUseCL2.cshtml:98 System.Web.WebPages.HelperResult.WriteTo(TextWriter writer) +10
System.Web.Helpers.<>c__DisplayClass10.b__f(TextWriter tw) +42 System.Web.WebPages.HelperResult.ToString() +82
System.Web.Helpers.<>c__DisplayClass4.b__3(TextWriter __razor_helper_writer) +1444 System.Web.WebPages.HelperResult.ToString() +82
System.Web.WebPages.HelperResult.ToHtmlString() +9
System.Web.HttpUtility.HtmlEncode(Object value) +38
System.Web.WebPages.WebPageBase.Write(Object value) +68
ASP._Page_Shared_Products_TekScrews_SelfDrillingMetalUseCL2_cshtml.Execute() in c:\Users\Jase\Documents\Visual Studio 2012\WebSites\NameRemoved\Shared\Products\TekScrews\SelfDrillingMetalUseCL2.cshtml:82 System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +197
System.Web.WebPages.WebPage.ExecutePageHierarchy(IEnumerable`1 executors) +69 System.Web.WebPages.WebPage.ExecutePageHierarchy() +151 System.Web.WebPages.StartPage.RunPage() +17 System.Web.WebPages.StartPage.ExecutePageHierarchy() +62
System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +76
System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContextBase httpContext) +114

-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17626

Updated: 27/07/2012

When debugging, the exception points to this line of code:

format: @<a href="?Action=Add&PartNumber=@item["PartNumber"]&Product=@item["Product"]&Type=Zinc Plated CL2 Unit Price&Units=1&UnitPrice=@item["ZincPlatedCL2UnitPrice"]&IsBoxed=0">@item["ZincPlatedCL2UnitPrice"]</a>

enter image description here

Upvotes: 0

Views: 2537

Answers (1)

Jon Skeet
Jon Skeet

Reputation: 1504132

Have you definitely checked your local database to make sure that column is in the schema? Perhaps your local database is "old" compared with your Entity Framework schema.

Upvotes: 2

Related Questions