locked
Data Access Techniques RRS feed

  • Question

  • User1564338223 posted

    Hello friends

    I want to develop Web based ERP application in asp.net.
    Can anyone tell me which is the best data access technique for this application?
    I am using Oracle 8i as back end.

    My form's web controls will be created at runtime only by reading the parameters from a table in database.

    I have gone through data technique tutorials for xml, Dataset and Custom Business Entity. Out of which I came to conclusion that Dataset will be more suitable for my application. 

    Now I want to design software architecture using Data Access Layer, Business Logic Layer and Presentation Layer. Please guide me how i should design my architecture. Any other suggestions from your side will also be taken in consideration.

    Thanks

    Regards

    Vipul



    Monday, February 15, 2010 11:45 PM

Answers

All replies

  • User960609757 posted

    Hi,

    check the following urls,

    Data Access Tutorials
    http://www.asp.net/(S(pdfrohu0ajmwt445fanvj2r3))/learn/data-access/


    .NET Data Access Performance Comparison
    http://msdn.microsoft.com/en-us/library/ms978388.aspx
    http://aspalliance.com/626_NET_Data_Access_Performance_Comparison.all
    http://www.developerfusion.com/article/5385/highperformance-net-application-development-architecture/11/
    http://weblogs.asp.net/scottgu/archive/2006/01/15/435498.aspx

    Tuesday, February 16, 2010 1:07 AM
  • User1564338223 posted

    Thanks gopalanmani for your support

    I have gone through all these tutorials but all them had explained sample program with Typed Dataset.

    I want guidelines for ERP application. How to Define connection Class, Where I should declare my Dataset, How

    to call DAL from my BLL etc.

    My application cannot use typed Dataset as columns are decided at run time. 

    Regards

    Vipul

     

    Tuesday, February 16, 2010 2:16 AM
  • User2115139740 posted

    I want guidelines for ERP application. How to Define connection Class, Where I should declare my Dataset, How

    to call DAL from my BLL etc.

    My application cannot use typed Dataset as columns are decided at run time. 

    Regards

    Vipul


    this will give u overview idea how to use, I doubt whether u will get exact EPR data application framework

    Creating a Data Access Framework
    http://geekswithblogs.net/dotNETvinz/archive/2008/02/01/creating-a-data-access-framework-again.aspx


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, February 16, 2010 2:24 AM
  • User1564338223 posted

    Thanks To All Of You Friends For Your Support


    Regards

    Vipul

    Wednesday, February 17, 2010 12:47 AM
  • User1237590199 posted

    hi,

    Book is available to develop web based ERP software using ASP.Net and C#.

    Check this url :

    http://www.vkinfotek.com

     

    Tuesday, May 4, 2010 4:21 AM