Using xsd or write my own data access layer?

Posted on 2008-11-12
Medium Priority
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
  • 2
LVL 16

Assisted Solution

by:Gyanendra Singh
Gyanendra Singh earned 400 total points
ID: 22949233
LVL 22

Accepted Solution

prairiedog earned 1600 total points
ID: 22950160
>>>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

ID: 22950730
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 http://aspnet.4guysfromrolla.com/demos/printPage.aspx?path=/articles/050405-1.aspx
Ref #2 http://richnewman.wordpress.com/2007/04/22/reasons-not-to-use-tableadapters-in-net-20/
Ref #3 http://forums.asp.net/t/1231450.aspx

Thanks guys!
LVL 10

Author Closing Comment

ID: 31516207
Thanks experts! :)

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Loops Section Overview
Suggested Courses
Course of the Month15 days, 20 hours left to enroll

850 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