Re: Multi threaded app database access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

"Macca" <Macca@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0A4A6F83-56EE-4392-BC54-75F76FBB8631@xxxxxxxxxxxxxxxx

I am in the process of designing my Data Access Layer but and was
wondering
what issues I should look for for in regards to a multi threaded app.

A web app with DB access faces the very same issues, you could read some
articles about how to implement DB access in the web.

My app will be need to initiate access to the database from several places
in the Business logic. I'd appreaciate any advice/suggesstions on best
practices to avoid problems such as accessing the same method in the data
access layer form different parts of the business logic at the same time
etc,

I would keep the DB access class as a stateless class, each method receive a
ICommand that just execute using the selected way (
ExecuteReader/NonQuery/Scalar ). Also each method will create its own
connection.



--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation


.

Relevant Pages

  • Application_End not firing
    ... changing the web.config both of which are supposed to stop the web app. ... in the event and running in debug mode but the breakpoint is never hit. ... The code that I actually need to execute at application_end is to shutdown a ... the component getting shutdown it is throwing the threadabort exceptions ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Application_End not firing
    ... Hi Chris, I have run into the same thing, unfortunately still have not come ... > changing the web.config both of which are supposed to stop the web app. ... > The code that I actually need to execute at application_end is to shutdown a ... > the component getting shutdown it is throwing the threadabort exceptions ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: User with privilege on a stored procedure in SQL Server 2000 / 200
    ... Permissions from All Tasks ... Then turn on Basic Auth on your web app, with Identity Impersonate = True in ... To execute that stored procedure in the client application, ...
    (microsoft.public.dotnet.framework.adonet)
  • Need only execute rights for web app. Did I set this up right?
    ... I have created a web app and now I want to make sure that it only has execute ... rights to run. ... Below is what I put in the assembly file. ...
    (microsoft.public.dotnet.security)
  • Execute rights only for web app using CAS in assembly file???
    ... I have created a web app and now I want to make sure that it only has execute ... rights to run. ... Below is what I put in the assembly file. ...
    (microsoft.public.dotnet.framework.aspnet.security)