Bruce,
What you did not bother to tell the poor guy is that it is using
stronly typed datasets.
If he does that and the location of the data changes, he gets to
recreate his entire "data layer."
That is just one of the reasons that I do not consider strongly typed
dataset as a REAL data layer.
You should not have to recreate the entire thing if the location of you
data source changes.
So why not do it correctly the first time instead of doing it over and
over again?
Do stored procedures in the SQL database for CRUD (CREATE, READ,
UPDATE, DELETE). (I am assuming that he is using a real database at
this point.)
Use the enterprise library to get the methods you need to execute the
stored procedures and get the data into either a dataset or datareader.
Write a class that encapsulates this functionality that the business
layer can call WITHOUT knowing anything about the database.
Now, you have a real data layer and not a hack job. Now you also see
why I consider the enterprise library to only be 1/3 of the data layer.
Robert
P.S.
There are also video presentations of what you gave to him, and more,
on the Microsoft site with code examples in both VB and C#.
Bruce W. Darby wrote:
> Dhananjay,
>
> Take a look here. There is a complete set of tutorials discussing your
> issue.
>
> http://msdn.microsoft.com/library/de...sslayer_vb.asp
>
> The tutorial is written for VB, but most of it should simply be syntax
> changes.
>
> "Dhananjay" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > hello everyone
> > i have got a problem i want to design business layer, data access layer
> > , presentation layer for asp.net using C#.net , can anyone help me to
> > solve this problem. i want some resources to complete this. i am trying
> > very hard. Do you have any idea about website or any links where i can
> > find some examples based on this concept.can you plz provide me , its
> > urgent
> > i want this solution with an example, if u have plz provide me.
> >
> > Thanks in advance
> > Dhananjay
> >