Are there any open source libraries, etc. that can be installed in an instance of SQL Server (2008 or later) that can enforce AOP standards? I would really like to avoid applying cross-cutting pattern issues to our development staff. AOP seems to be the best option if available.
If it does not exist yet, I will try to collapse it.
EDIT:
Some examples can be subclassed in a table to create specific types of tables, for example mixin characteristics. I am in a data warehouse environment with a lot of audit requirements, so we create multi-threaded tables. It would be great to have
CREATE BITEMPORAL TABLE
which will add the transaction and the actual time and modify the CRUD statements for these tables. (Yes, I know that looks and triggers can do this somewhat). A more difficult task is to save procedures with specific logging or transaction parameters, such as
CREATE PROC FOO
and the body will be automatically wrapped using the appropriate T-SQL to perform these actions. Yes, it is possible to add stored procedures to accept these arguments and generate SQL and compile these artifacts. But the disadvantage is that there is no coercion - the developer can bypass this procedure and use CREATE PROC directly, and the content in syscomments is the generated code, and not the annotated version of AOP, which violates the abstraction.
source share