A number of factors would influence the decision : Complexity of the business rules vis-a-vis available skill sets Future directions (e.g. migrating to different OS / Technology / Database platforms. for scaling. For multi-site installs.) Which model meets performance / availability / reliability / serviceability criteria. Hemant K Chitale http://hemantoracledba.blogspot.com sent from my smartphone On Nov 8, 2010 9:52 PM, "RP Khare" <passionate_programmer@xxxxxxxxxxx> wrote: Hi, I read Tom Kyte's "Effective Oracle by Design". There he says to write most of the code in the DB itself to reduce application code. It is good in a distributed environment, but is it advantageous in an standalone application also? My app. is in .NET. ................ Rohit.