主要是想知道各位同行的做法: 是把business logic放在stored procedure裡呢,還是放在高級語言code裡。
myself: 盡可能地把business logic往c#寫的class裡塞,procedure能簡單就簡單,恨不得連個if也沒有,當然俺沒做到,if 總是有幾個的。
I like to put business logic into dll but some simple check into the store procedure.
我們是把C#寫的logic放在數據庫裡,用的時候動態編譯
是,基本logic寫在dll裡面,可配置logic部分存在數據庫中,需要用到的時候動態編譯執行。
In order to manage and maintain data and software. I think that separate data and logic is the best practice.
But anyway, people thinking differently, so there is no right or wrong on either one.