Using xsd or write my own data access layer?

Posted on 2008-11-12
Last Modified: 2013-11-11
Ok, i've found lots of example over the net that use "xsd" to access the database information.

Why should i use "xsd" to access my database information instead of writing my own database access inside my DAL (Data access layer, using sqlconnection)?

I'm working with "Connection Pool" and large amount of data.

Performance is really important in my application.
Time to develop custom code is not a concern.

What should i do?

Question by:jabcoco
    LVL 16

    Assisted Solution

    by:Gyanendra Singh
    LVL 22

    Accepted Solution

    >>>Why should i use "xsd" to access my database information instead of writing my own database access inside my DAL (Data access layer, using sqlconnection)?
    No one says you have to use "xsd". Of course you can write your own DAL with different means. One of the advantages of using 'xsd" is that it creates strong-typed datasets, which is recommeded than general datasets.

    >>>Time to develop custom code is not a concern.
    Then you can write your own, and it helps you understand more about multi-tiered application development.
    >>>Performance is really important in my application.
    I don't know if using 'xsd' will have lower performance than using your own DAL, it depends on lots of factors.
    There are also several tools that builds DAL and BAL for you automatically, such as Code Smith, and SubSonic. You can check them out if you are interested.
    LVL 10

    Author Comment

    After reading more article on the net I've finally decide to write my own "Business Objects".

    Prairiedog: Yes.. writing my own code will help me understand more about multi-tiered and having controls over what i'm doing.

    Ref #1
    Ref #2
    Ref #3

    Thanks guys!
    LVL 10

    Author Closing Comment

    Thanks experts! :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    User art_snob ( encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
    For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK ( for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now