Performance of ADO.NET

  • Thread starter Thread starter Manish Pansiniya
  • Start date Start date
M

Manish Pansiniya

Hello All,

We are currently in feasibility study and high level design phase. We need
to choose application design according to performance and maintainance.
Means our main criteria is Performance and easy Maintainance.

We have created one template for just study purpose.

1) Layer That uses Typed DataSet and Stored Procedure
In this template, we used Typed Dataset. But somewhere i read that it is
maintainable but not giving good performance.
Our structure is :
Presentation Layer > BAL > DAL > Type Dataset
Layer > DL

I want information whether this is a good architecture or not.

Can anybody suggest me a good architecture with following criteria.
Use of Stored Procedure everywhere
Performance should be high
DAL and BAL Should be there
Easy to maintain and programmer friendly :)
Give me answers ASAP.

Best Regards, and Thank You in Advance.
Manish
 
Hi Manish,

The only performance issue with datasets in general is that they can't be
binary serialized thus you always transfer xml text between layers (if your
layer are separated between different machines).
Otherwise, I see no performance hit using datasets/sp - infact this
combination is used on my big solution :)
 
Back
Top