Invalid Column Name Error (with legit column names)

Sep 3, 2010 at 7:30 PM
Edited Sep 3, 2010 at 7:31 PM

Very often I will create columns in nHydrate, then get a SqlException when writing the DAL to the database. Sometimes I can fix it by restarting VS10 & starting from scratch, but this is inefficient and there must be some reason for getting the error in the first place.

The problem seems very inconsistent to me- for example, the column name 'PositionDescriptionQ2' did not throw an error, while 'PositionDescriptionQ3' did not.

I have encountered this problem with datatypes NVarChar, Bit, and Integer; and with Version and Version

I noticed this happens regardless of underscores or capitalization in the Name and CodeFacade fields.

Thanks very much.

Sep 3, 2010 at 8:05 PM

Please send a model in which  this occurs to