We have created several small client applications with .netTiers and have been very happy with the templates. We are now looking at using .netTiers with out internal CRM application and we are seeing some areas where we might have some issues.
Scenario 1:
When adding a new appointment (and many other event type tables) to the database it is first required to create a even log entry. I know this can be done at the .netTiers layer or through triggers but that is not how the existing code works and we are trying to keep the existing SQL code as much as possible. The best way I have seen is to override the insert method for saving the new record and call the alternate stored procedure. If this is the way then we will have to override the insert, update and delete for 30% of the tables in the system. Is there a better way?
Scenario 2:
Several procs exist in the system that are overloaded versions of the base procs. For example, there is a proc to do an insert into the lead table but it first checks if the lead exists prior to the attempt (the check uses some fuzzy logic). Again, this proc is preferred to the standard insert but in this case the proc has 2 additional fields which are not part of the base proc call. The application provides these two extra fields but they are not used in the insert. How would this be done in .netTiers?
Scenario 3:
We use SQL Server for the primary database, but there are times when we need to lookup information in our Oracle database. Is there a way to switch back and forth between the two? There are no schema similarities and most of the time we are executing straight-up SQL in the Oracle DB.
Thanks in advance.