Tim,

Kevin is taking this discussion up offline, but I wanted to answer your last question. Yes, I did try to manually change the data types in the entities to nullable, but that is a lot of work when you have many tables and then you lose all ability to automatically regenerate the business layer. I found a better approach to test my theory was to change all the numeric data types in my database to be nullable and then regenerate the business layer with the proper "Required" and "Allow Empty Value" settings for each column and then the BLG generates all my business rule properly so I don't have to modify any of them or the entities. I had to reset my database columns back to not nullable where appropriate. I know it was hokey, but it worked and I didn't have to manually modify any of the business rules or entities. When you have hundreds of tables and more than a thousand numeric data fields, it's nice to not have to modify all those generated business rules and entities.

Al