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
Post a Comment