I have another design issue. The BeerHouse has a BLL function for _addedDate. I have always used a trigger in the table to record when an update occurs. Like so:
ALTER TRIGGER [trgUpdateOperaCompany] ON [dbo].[oh_OperaCompany]
FOR INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON;
UPDATE oh_OperaCompany
SET UPDATE_DATE = getdate()
WHERE PK_OPERACOMPANY_ID =
(SELECT PK_OPERACOMPANY_ID FROM inserted)
END
I copied this style from Siebel. Again this seems more "natural" to me. In these two cases as well as others I suspect I have taken a databse centric approach. Am I just out of date?
http://weboperahouse.com