Quick Copy paste Code Snippets

The following example below demonstrates how we can go about exposing the DbSet.SqlQuery method when using IDbSet interface Please comment below if you have a better approach.

The following sql statement allows you to view the relationships between primary keys and foreign keys with other tables. SELECT uc.constraint_name||CHR(10)    || '('||ucc1.TABLE_NAME||'.'||ucc1.column_name||')' constraint_source    , 'REFERENCES'||CHR(10)    || '('||ucc2.TABLE_NAME||'.'||ucc2.column_name||')' references_column     FROM user_constraints uc ,     user_cons_columns ucc1 ,     user_cons_columns ucc2     WHERE uc.constraint_name = ucc1.constraint_name     AND uc.r_constraint_name = ucc2.constraint_name     and ucc1.position        = ucc2.position     AND uc.constraint_type   = 'R'     --AND uc.constraint_name   = 'FKF32F2C126588DBBC'     order by ucc1.table_name ,     uc.constraint_name;     CONSTRAINT_TYPE (from 11gR2 docs) C - Chec...