Hey all,
I've been asked for a customer to write a piece of data access using
EntLib 2.0. I'd like to use the standard entlib database factory class
because a transition to SQL Server is still a viable option in the near
future.
The problem is that the project will use Oracle till then, and there is
no integrated security activated on the Oracle Server (and it won't be
in the near future). For compliance reasons every user must connect
using their own unique user/pass which is the same as the web
application. So basically we do forms authentication, store the
user/pass in the session and pass it to the datalayer when appropriate.
The problem is that I cannot find a way to merge the credentials into
the connection string for that specific session. The only solution I
found was to use the direct constructor of the OracleDatabase class, but
that won't play nice with other configurable stuff in the web.config
(like packages, prefixes and other configurable data).
Any ideas on how to fix this easily? I've considered sub-classing the
OracleDatabase class, but would like an easier solution... Is there a
method, event or anything that lets you manipulate the connection string
just before it's use, or can I plug into the database settings class
somehow and get my configuration data in there without affecting other
user sessions?
Jesse
I've been asked for a customer to write a piece of data access using
EntLib 2.0. I'd like to use the standard entlib database factory class
because a transition to SQL Server is still a viable option in the near
future.
The problem is that the project will use Oracle till then, and there is
no integrated security activated on the Oracle Server (and it won't be
in the near future). For compliance reasons every user must connect
using their own unique user/pass which is the same as the web
application. So basically we do forms authentication, store the
user/pass in the session and pass it to the datalayer when appropriate.
The problem is that I cannot find a way to merge the credentials into
the connection string for that specific session. The only solution I
found was to use the direct constructor of the OracleDatabase class, but
that won't play nice with other configurable stuff in the web.config
(like packages, prefixes and other configurable data).
Any ideas on how to fix this easily? I've considered sub-classing the
OracleDatabase class, but would like an easier solution... Is there a
method, event or anything that lets you manipulate the connection string
just before it's use, or can I plug into the database settings class
somehow and get my configuration data in there without affecting other
user sessions?
Jesse