how to create data access layer

Just create a class library and way all your database access code through it.

Dont put anything that calls database to your current application(Presentation Layer) and just expose few methods from the dll and call them to get data.

Preferably you need to create independent modules for database access. Dont mix up the presentation component (like sending Datagrid in Data layer etc) with DataAccess Layer.

Cheers.

www.abhisheksur.com

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator

I once Written Article about the Subject. Basically your DAL(Data Access Layer) in C# is Created as a Class library that get Accessed by the BLL(Business Logic Layer) and that gets Accessed by the PL(Presentation Layer)

here are the Articles

http://www.codeproject.com/KB/vb/N-Tier_Application_VB.aspx

http://www.codeproject.com/KB/cs/N-Tier22.aspx

http://www.codeproject.com/KB/cs/NTier.aspx

Thank you for posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator

Please first try to search a bit on the topic you want to ask, this would help you getting more information about it.

Below article from this website will hep you. This has source code as well so you can download and see that how it works.

http://www.dotnetfunda.com/articles/article71.aspx

http://www.dotnetfunda.com/articles/article71.aspx


Thank you.

Regards,
Raja, USA

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator

There are so many of the ways for it but better to keep the most of the methos in this class or classes under the DB layer namespace as Static so that they may be directly accessible without object.

There are so many ready made layers for DB, you may follow them either to build your own or can use them.

Best Regards,
Puneet Sharma - Infosys
Pune, India

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator

thx

Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator