Data Access Layer

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

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.


> 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/e n-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"

Re: Data Access Layer

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

Many thanks,

Jono

"Bob Barrows [MVP]" wrote:

> 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.
>
>
> > 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/e n-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"
>
>
>