Re: Data Access Layer

Jono Jones wrote:
> Hi there,
>
> Could you point me to a good resource for creating my data access
> layer? I have my database, I have me front end, but I want a nice
> layer between them so I can just call functions in my code behind

"code behind"? This makes me suspect that you are asking about asp.net, so
here is my canned reply:

There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-knowledgeable person here who
can answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.aspnet.

<snip>
> It may be because I'm very tired but it's not clicking (just started
> coding asp.net a few months ago, just getting on to layered coding -
> previously hard coded everything in the presentation layer).
> Previously I wrote in jsp whre I would create a class and I could
> just save that into the database, thorugh underlying mappings that I
> didn't set up.
>
> Any pointers to resources much appreciated.
>
Basically, you do the same thing in asp.net: create a class that exposes the
methods and properties you need to communicate with the database. What
database allows you to save a jsp class in it?

Microsoft has a collection of what they call Application Blocks, one of
which is a Data Access Application Block. You can use it as-is, or just get
ideas from it. Here is a link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • RE: Designing of database system based on .net
    ... I recommend stored procedures for data access, as it adds a security layer. ... The middle tier can either be wrapped DataSets ... > I want to build system for about 200 users which will be connected in one> moment to database. ...
    (microsoft.public.dotnet.framework)
  • Re: Looking for a decent data access architecture to implement
    ... > application so that there is a clean separation between the data access ... > layer, the business layer and the GUI layer. ... > the actual database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Looking for a decent data access architecture to implement
    ... application so that there is a clean separation between the data access ... layer, the business layer and the GUI layer. ... the actual database. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: "Business Objects" and the DAL
    ... layer talks to the layer next to it. ... business entity returned that up to the UI for binding to a grid. ... If a database table column names ... Each could be considered a "pattern", ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Size matters to some
    ... The underlying remote database connection ... physical layer is actually managing it all, the logical layer is forced to ... constraints as specified by developers. ... want to validate the information getting written. ...
    (comp.databases.pick)
Loading