Data Access Layer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jono Jones - 25 Nov 2005 09:58 GMT

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 to return me a list etc or the
contacts of my page. I'm coding system to log contract details. At the top I
have projects, each project can have many contracts. I want to be able to
pull back one contract's data and be bale to write back changes. Or open a
new contract to write that into the database.

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.

Jono

Reply to this Message

Bob Barrows [MVP] - 25 Nov 2005 12:41 GMT

> 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 -
[quoted text clipped - 4 lines]
>
> 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

Signature

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"

Reply to this Message

Jono Jones - 25 Nov 2005 12:50 GMT

Thank you bob. Your help is very much appreciated. I will target my future
mails to the .NET area.

Many thanks,

Jono

> > Hi there,
> >
[quoted text clipped - 30 lines]
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp

Reply to this Message

Webmaster Forum / ASP / Database Access / November 2005

Data Access Layer