Hello all,

I am creating a BO using the BLG in Mere Mortals and basing it on a view. I am only creating the main class and an Entty class. Now the view is just a list of colums from a couple of tables and it is grouping data by 3 columns with a couple of summed numeric columns.

My question is why does the BLG type the summed columns as decimal with nulls (i.e. 'decimal?'). The columns from the base tables do not allow nulls, so I am curious as to why the BLG does this. The real question I need answered is when I run a stored procedure via a method in this BO to be returned into the Entity class, I get the following error:

"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."

When I run the stored procedure in SSMS, the rows get returned fine and there are no nulls.

Any help is appreciated.

TIA

Bob