Please enable JavaScript.
Coggle requires JavaScript to display documents.
ADO.Net -ActiveX data object, Entity Framework - Coggle Diagram
ADO.Net -ActiveX data object
provides access to data sources
Multiple providers for different databases
Root class : System.Data
Connected architecture
Classes
Connection
Command
DataReader
ExecuteReader()
ExecuteNonQuery
DataAdapter
Disconnected architecture
Storage and management of data without connecting
Data stored in client's m/c
DataAdapter
UI
Business layer
DataAccess layer
SQL connection types
SQL connection
OleDbconnection
Odbc connection
Entity Framework
Classes
Context - Database
Entity - table
Scalar
Navigation
Business entities
Business model
business objects
class diagram
relationships and classes
ORM (object relational mapper)
Domain objects (classes)
Relational db objects (tables,views etc)
Dbcontext
Dbset
Automates CRUD operations
Enhancement of .Net
Using System.DataEntity
Separation of concerns