What is it ADO.NET to C#?
I'm starting to learn about C# for Web applications, and wanted to know what is the ADO.NET and what are the advantages of using it?
1 answers
Can be used with any .NET-compatible language .C# is the main one.
Has basic information in our tag. And the official page . Wikipedia .
It is the basic database access engine used by .NET. it is advantageous in this sense. Not compared to something else. It gives a functionality to the development platform.
It is a Framework with the basic infrastructure for the communication with the mechanisms that manage the databases. They also have some facilities to abstract this data in the application. But these functions are used less and less and one makes use of so-called ORMs, such as the Entity Framework (core and Official), NHibernate or the simplest ones like the Dapper .
When using an ORM, the ADO.NET becomes transparent or unnecessary. But if you want to do everything by hand and more simply, more crude, the ADO.NET it's more interesting. Not always what is "more modern" is the best solution for everything.
You can also use other mechanisms such as OleDB or ODBC, even if they are linked to ADO.NET. are considered obsolete or alternative only when the ADO.NET native of each bank can not be used for some reason.
Its basic functions are:
- open and sustain a connection
- assemble and run queries
- iterate over the data obtained