I'm struggling with logic that is duplicated in the front end code and the database. Right now, I just put a comment.

Here is a small example (the current system has a lot of much more complicated formulas).

In the front end, I have a single property that everything use to see the result.

Class CartItem
    
    ' The same formula is found in the database view V_CART_ITEM
    Public Readonly Property Cost As Decimal
        Get
            Return Price * Amount
        End Get
    End Property

End Class

In the database, I have a view that all queries and report use.

CREATE OR REPLACE VIEW V_CART_ITEM AS
-- The cost formula is also found in the class CartItem
select cart_item_id, price * amount as cost
from cart_item;

I think it's not to bad since the formula is only duplicated once in the whole system and a new developper would know what to do if there is ever any changes to be done. I'm wondering if there's a better way.

I'm struggling with logic that is duplicated in the front end code and the database. Right now, I just put a comment.

Here is a small example (the current system has a lot of much more complicated formulas).

In the front end, I have a single property that everything use to see the result.

Class CartItem
    
    ' The same formula is found in the database view V_CART_ITEM
    Public Readonly Property Cost As Decimal
        Get
            Return Price * Amount
        End Get
    End Property

End Class

In the database, I have a view that all queries and report use.

CREATE OR REPLACE VIEW V_CART_ITEM AS
-- The cost formula is also found in the class CartItem
select cart_item_id, price * amount as cost
from cart_item;

I think it's not to bad since the formula is only duplicated once in the whole system and a new developer would know what to do if there are any changes to be made. I'm wondering if there's a better way.