Data Access Layer

[Jono Jones]

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

[Tasos Vogiatzoglou]

Jono, check this :
http://msdn.microsoft.com/library/de...ml/distapp.asp

[Jono Jones]

Many thanks :)

"Tasos Vogiatzoglou" wrote:

Jono, check this :
http://msdn.microsoft.com/library/de...ml/distapp.asp

[key.kevin]

Have you seen the Data Access Block for .NET by Microsoft? It's a great
resource.

http://www.microsoft.com/downloads/d...displaylang=en

[prabhupr]

Google for "Microsoft Application Block" you should have the answer :)

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 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