Is ADO .NET is ORM if not then what is this ? is it a .NET framework which helps to intract with database and part of .NET ?
Loading
Is ADO .NET is ORM if not then what is this ? is it a .NET framework which helps to intract with database and part of .NET ?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sachin SinghPosted Mar 2, 2022, 2:15 PM
Gajendra JangidPosted Mar 27, 2022, 2:46 AM
ADO.NET provides consistent access to data sources such as SQL Server and XML, and to data sources exposed through OLE DB and ODBC. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, handle, and update the data that they contain.
ADO.NET separates data access from data manipulation into discrete components that can be used separately or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. Those results are either processed directly, placed in an ADO.NET DataSet object in order to be exposed to the user in an ad hoc manner, combined with data from multiple sources, or passed between tiers. The DataSet object can also be used independently of a .NET Framework data provider to manage data local to the application or sourced from XML.
Ashwani ChaudharyPosted Mar 2, 2022, 5:54 PM
Can i call it as framework which made up of many classes which specially helps to connect to database and if we talk about Entty framework ....is it kind of a wrapper in ADO.NET ? where we do not need to write any commands like
SqlConnection con = new SqlConnection("data source=.; database=Sample; integrated security=SSPI");
SqlCommand cmd = new SqlCommand("Select * from tblEmplpoyee", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
GridView1.DataSource = rdr;
GridView1.DataBind();
con.Close();
and DBContect class takes all above code responsiblities.
I have one more question regarding DBContext class and DBContextOptions class
what is use of DBContextOptions and what we are doing with DBContextOptions
Public Class ApplicationContext : DBContect
{
ApplicationContext(DBContextOptions _options) : base (_option)
{
}
}
Mahesh ChandPosted Mar 2, 2022, 1:58 PM