Database Access Options in .Net Framework

Only available on StudyMode
  • Topic: .NET Framework, ADO.NET, Microsoft Visual Studio
  • Pages : 4 (1420 words )
  • Download(s) : 449
  • Published : March 5, 2011
Open Document
Text Preview
Running head: analysis of data access technologies in .NET Framework

ADO.NET, LINQ, Entity Framework, NHibernate

ADO.NET, LINQ, Entity Framework, NHibernate
The database management systems (DBMSs) are the essential part of the information technology. Nowadays, programmers use relational databases produced by a majority of manufacturers for data handling. Even each database management system uses its own proprietary format it is still a challenge for software developers to find appropriate approach to access data from multiple sources. Most of the new tools available to developers, including Microsoft’s Visual Studio, attempt to handle data from multiple locations (servers) and data stored in different formats (Bradley & Millspaugh, 2008). The following discusses several options the .NET Framework uses to access data. These topics include ADO.NET, LINQ, Entity Framework, and NHibernate. ADO.NET

The ADO.NET presents programmers with a package of components and to access data and data services. ADO.NET originally spawned from ActiveX Data Objects (ADO) technology, but it went through many major changes until today. ADO.NET is also a relatively new product. According to the website, “ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers” (, 2005). ADO.NET is unique in regards to the data access and data manipulation. ADO.NET separates to into discrete components and uses both separately or in conjunction with other applications. Furthermore, ADO.NET includes data providers for data connectivity, command executions as well as retrieving processed results directly or by ADO.NET DataSet...
tracking img