I am using the DAL to aggregate SUM a decimal field and the result is a float. Shouldn't the DAL keep it in same format as the underlying field?
More generally I keep coming across the issue that you cannot combine decimal and float in calculations. So I guess it is better to try and stick with one or the other. Which is the best choice?