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 , 21 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.

21 comments:

  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~

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

    ReplyDelete
  3. Anonymous11:53 PM

    This comment has been removed by a blog administrator.

    ReplyDelete