Data Access Techniques

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

Answer 1

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

Answer 2

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

 

Answer 3

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

Answer 4

User1564338223 posted

Thanks To All Of You Friends For Your Support

Regards

Vipul

Answer 5

User1237590199 posted

hi,

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

Check this url :

http://www.vkinfotek.com