I have a stored procedure I have been using in my module that retrieves all fields from the file.
I added to fields to the table after the 6th field in the table there are now 27 fields there were 25.
I updated the components in my Project to include the fields added and Compile with no errors.

When I call the procedure and walk through the class for the returned data it skips over the 2 new fields and therefore does not provide the data for the 2 new fields. When I run the SP in a query window in SQL it shows the fields. WHen I reference the new field in my code it does so with no errors.

I can't see what I missed in the DAL does anyone have an Idea as to what is missing or wrong?
should I be able to add fields? I added them in the same order in all the DAL sections
Thanks

I will try clearing 
when you say "application layer interface, inconsistencies will show up on runtime in the application" what are you referring to? meaning if I add new fields and my DAL is not handled to use them?
Thanks

I cleared the cache and it still skips over the properties for the new fields  when running the SP.
And this has turned into an extensive debug session :(
I did at one point change the SP to reference all the fields by name but this did not make a difference