基于.NET的数据库访问技术的优化研究.doc

基于.Net的数据库访问技术的优化研究 伍锐锋 主页： （2005级 信息管理与信息系统） [摘要]：随着计算机和因特网的飞速发展，数据库访问技术也变得越来越丰富。随着分布式数据库技术的发展及XML WEB服务的普及，人们对断开式数据库访问技术及分层数据（特别是XML文档）处理能力的要求也越来越高。.NET作为为一个被广泛接受的开发及应用平台，其平台上的数据库访问技术也就自然成了一个重要的研究课题。现今关于.NET平台的研究文章越来越多，这们都有各自的特点和适用范围，但是在结构和应用上各有偏重，本文则尝试从数据库访问技术优化的角度对基于.NET平台的数据库访问技术进行研究，总结出基于.NET平台的数据库优化技术，以有助于.NET平台下广大开发及研究人员的学习及工作。 [关键词]：.NET；数据库访问技术；ADO.NET；数据库优化； Database Access Technology Optimization Based On .NET Wu Ruifeng (2005 Information Management and Information System) [Abstract] Along with the rapid development of computer and Internet technologies, the technologies of database access are increasingly varied and plentiful. With the development of distributed database technology and the popularity of XML WEB services, the requirements of disconnected database access technology and the ability to deal with hierarchical data (XML documents in particular) are increasingly high.. NET as a widely accepted development and application platform, the platform of the database access technology naturally becomes an important research topic. Today, the number of research papers on the. NET platform is becoming more and more, which have their own characteristics and the scope of application, but also have their own structure and emphasis on applications, this article try to do a research from a view on database access technology optimization based on.NET platform to sort out the main essence of database access technology on .NET platform, to help the vast numbers of researchers to study and work on .NET platform. [Key Words].NET; Database Access Technology;ADO.NET; Database Optimization; 目录 1.引言……………………………………………………………………1 2.基于.NET的数据库访问技术………………………………………… 2.1 .NET框架介绍……………………………………………………………… 2.2 ADO.NET体系结构概述……………………………………………………… 2.3 .NET Framework3.5下的LINQ特性介绍…………………………………… 3.基于.Net的数据库访问技术的性能优化…………………………… 3.1 优化数据访问…………………………………………………………………………… 3.1.1 DataReader和DataSet的使用…………………………………………………… 3.1.2存储过程的使用…………………………………………………………………… 3.1.3 缓存数据…………………………