Describe benefit of ORM over ADO Net.

An Object Relational Mappers (ORM)/The benefit of ORM over ADO Net. 

  • ADO.Net provides consistent access to the data sources and as SQL Server and  XML to retrieve, handle and update the data that is present in the database BUT, it also separates data access from data manipulation into discrete components that can be used separately. ADO. Net includes, .Net framework data providers for connecting to a database, executing commands and connecting commands, and retrieving results. 
  • On the other hand, ORM is a programming technique for converting data between incompatible type systems in OOPs languages. This creates "a virtual object database that can be used from within the programming language.
  • Entity Framework (EF) and NHibernates and the ORM. It Means, you do not operate by SQL connections, commands rather ORM tools does it all for you and also allow you to map your database structure in an OOP manner.
  • You (we) can add, read, update, delete records. in your DB-using objects in C#. Generally, DB with. ORM is faster but we have to provide some more lines of code.

Comments

Popular posts from this blog

Suppose that a data warehouse consists of the four dimensions; date, spectator, location, and game, and the two measures, count and charge, where charge is the fee that a spectator pays when watching a game on a given date. Spectators may be students, adults, or seniors, with each category having its own charge rate. a) Draw a star schema diagram for the data b) Starting with the base cuboid [date; spectator; location; game], what specific OLAP operations should perform in order to list the total charge paid by student spectators at GM Place in 2004?

Define Business ethics . Explain its significance.

Short Note on Security Architecture of E-governance