This project is read-only.

Invalid Column Name Error (with legit column names)

Sep 3, 2010 at 8:30 PM
Edited Sep 3, 2010 at 8: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 3.6.0.172 and Version 3.6.0.170

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

Thanks very much.

Sep 3, 2010 at 9:05 PM

Please send a model in which  this occurs to chrisd@nhydrate.org.