Data Access Research And Application Base On Three-Tier Architecture

With the developing rapidly of Internet, WWW has got the very big development. The traditional database access technique can't satisfy little by little the demand of high speed access, the data access on broken connection and Complete support of XML, etc. The study of database access technique based on Internet has become one of main direction of database research.This paper investigates throughly the performance optimize of ADO.NET, and comparison, choice and performance optimize of .NET data providers, and optimize of stored procedure, data consistency etc. In addition, it puts forward that how to develop efficiently database access application of facing to the Internet on .NET environment.Based on the above studies of Web database access technique, according to actual need of Management of postgraduate, discussing a Information system of B/S mode has been designed and realized. That system on .NET platform is the implementation with C# language by adoption ADO.NET data access technique and related performance optimize technique. The Web server of the system uses AD0.NET technique (such as SQL Server .NET data providers, stored procedures, security, data consistency) connecting and accessing database. Such things enhance consumedly data access efficiency and performance of application program.