yet another blog about computer, technology, programming, and internet

Tuesday, June 27, 2006

Implementing DAL with Microsoft Visual Studio.NET

Tuesday, June 27, 2006 Posted by Ismail Habib , 33 comments
DAL (Database Abstraction Layer) concept is extremely useful, especially when it comes to large applications. However, it has several drawbacks. One of them is that implementing a DAL might require a lot of time. Fortunately, there are some "tools" that allow us to cut the DAL implementation time required.

Microsoft Visual Studio.NET (VS.NET) itself gives a way to implements DAL in your application. As far as I know, VS.NET gives two way to access database. The first one is by accessing it through a SQL command, I call this direct database connection. The other way is by using ADO.NET. As ADO.NET provides several components to access databases, they are adapter and dataset. While adapter is dependent to specific database, dataset is completely transparent to any kind of database. VS.NET implements a dataset as a class that provide several methods to access database. Adapter works as an intermediate between database and dataset. Its implementation contains SQL queries relevant to actions (add, edit, delete) which are going to be invoked from dataset. Remember, this only work if you use database access with dataset manipulation and not direct database access.


  1. waaaagh,tidaaaks!ini blognya meuni gada curhatannya >.< serem oi ngomongin "begitu"an smua :))
    KK emang keren,scara adenya keren ginih juga B-) ~hidup narsis.biarin komen ganyambung juga :D~

  2. gile loe bib...
    Berat bener dah....

  3. Anonymous11:53 PM

    This comment has been removed by a blog administrator.

  4. The article is very interesting. And I also want to share articles about health, I'm sure this will be useful. Read and share it. Thank you very much :)

    Cara Mengobati Luka Bakar Melepuh
    Obat Jerawat Alami
    Obat Infeksi Ginjal di Apotik
    Obat Alami Sakit Kepala
    Obat gondok Beracun

  5. This comment has been removed by the author.

  6. TreasureBox is operated by a group of young, passionate, and ambitious people that are working diligently towards the same goal - make your every dollar count, as we believe you deserve something better.
    Check out the best
    entertainment unit
    furniture nz

  7. your content is really awesome i would share My Appliances Discount Codes with readers