.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> .Net Framework >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Performing Database Updates with DataSets

Posted By:Shashi Ray       Posted Date: November 27, 2009    Points: 25    Category: .Net Framework    URL: http://www.dotnetspark.com  
 

 

Performing Database Updates with DataSets

The architecture for performing database updates has changed significantly with the introduction of ADO.NET. ADO.NET has been designed to better facilitate development of multitier applications that scale to large database sizes and large numbers of clients. This has had some important consequences, in particular:

  • ADO.NET applications usually segregate application logic on the client from business and data integrity computations on the middle and database tiers. In practical terms, this means that the typical application will have more of a batch or transactional nature with fewer (but larger) interactions between client application and database.
  • ADO.NET applications have more control (in comparison to ADO and its predecessors) over exactly how updates are processed.
  • ADO.NET allows applications to propagate changes by means of stored procedures that are stored in the backend database, instead of directly manipulating a row of a database table. This is a recommended practice.

 

 

Shashi Ray

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend