DevForce Community Forum : Strangest mapping error http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Strangest mapping error Tue, 21 Apr 2026 22:13:11 -700 Thu, 19 Aug 2010 09:23:58 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2077 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Strangest mapping error : I added a new field to a table.... http://www.ideablade.com/forum/forum_posts.asp?TID=2077&PID=8099#8099 Author: BillG
Subject: 2077
Posted: 19-Aug-2010 at 9:23am

I added a new field to a table. I refresh my edmx file and I can see the field in the table object. I add a default value to the field in the classes create method and it compiles fine. I place a breakpoint at the place in the code where an object of the class is created for the first time in the program and the property is not there. I check the SQL statement in Intellitrace and the SQL statement does not have the new field in it. I deleted the table from the edmx and remapped it and still the same thing. I can see the property is there because intellisence picks it up when i type the name of the table and hit .
 
The problem is the select statement does not pick it up. Here is my code.
 
         var query = from InventoryDetail in entityManager.InventoryDetails
                      where InventoryDetail.ItemId == currentItem.ItemId
                      select InventoryDetail;
 
As you can see I am not specifying any fields, I want all of them. The SQL statement in Intellitrace shows all the fields being queried except for the new one. I even added a new field on top of that one and it still won't change the SQL Statement.
 
 

 
]]> Thu, 19 Aug 2010 09:23:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2077&PID=8099#8099