Entity Framework introduction in .NET

1
Entity Framework introduction in .NET

• www.studysection.com

2
Entity Framework introduction in .NET

• Entity Framework is described as an ORM (Object
  Relational Mapping) framework that provides an
  automatic mechanism for developers to store and
  access the information from the database.
• It is the primary source of interaction between
  .NET applications and relational databases.
  Entity Framework consists of a variety of tools
  that simplify mapping between objects in your
  software to the tables and columns of a computer
  database. ORM automatically creates classes
  supported database tables or vice-versa i.e. it
  can even automatically generate necessary SQL to
  form database tables supported classes.

3
Use of Entity Framework

• It is to extend the developers productivity by
  reducing the redundant task of persisting the
  info used in the applications.
• Entity Framework can generate the required
  database commands for reading or writing data
  within the database and execute them.
• If youre querying, youll be able to express
  your queries against your domain objects using
  LINQ to entities.
• It will execute the relevant query within the
  database to materialize results into instances of
  your domain objects for you to figure within your
  app.

4
The architecture of Framework consists of the
following

• Data Providers Data providers are
  source-specific, that abstract interfaces are
  attached to connect the database when programming
  against the conceptual schema. It translates SQL
  languages like LINQ by command tree to the native
  System Query Language expressions and then
  executes them against the particular DBMS system.
• Entity Client It is a data provider used by
  entity framework applications to access the data,
  this layer exposes the entity layer to the upper
  layer. Entity client provides the flexibility for
  developers to figure against entities within the
  style of rows and columns using entity SQL
  queries without the necessity to get classes to
  represent conceptual schema. Entity Client
  represents the core functionality layers of the
  entity framework

5
The architecture of Framework consists of the
following

• Object Service The Object Services enables to
  work with entities such as memory objects. It is
  the Object Context, that represents the session
  of interaction between the data source and
  applications.
• Article Context is used to perform different
  operations like add, delete instances of
  entities, and save lots of the changed states
  back to the database with the assistance of
  queries.
• ORM layer shows the result to the instances of
  entities.
• It allows developers to use various ORM features
  like primary key mapping, change tracking, etc.
  by writing queries using Entity SQL or LINQ.

6
Entity Data Model

• The Entity Data Model (EDM) specifies (CSDL) the
  conceptual model and an extended version
  entity-relationship model. It also refers to a
  collection of concepts that describe the data
  structure of the system, no matter its stored
  form.
• The model uses three core parts of EDM.
• Storage Schema Model The Storage Model is a
  database design which is also called SSDL
  (Storage Schema Definition Layer) which
  represents a schematic representation of backend
  data.
• Conceptual Model The Conceptual Model contains
  the model classes and is also called Conceptual
  Schema Definition Layer (CSDL) is that the real
  entity model, against which we write our queries.
• Mapping Model The mapping layer consists of
  information that is simply a mapping between the
  Conceptual model and also the Storage model.
  Mapping of logical and physical schema is
  represented as an EDM(Entity Data Model).

7
Relationships

• In RDBMS or relational databases, the relation is
  said to exist between different tables through
  the defined foreign keys. There are mainly 3
  forms of relationships between tables which also
  depend on how the related columns are being
  constructed. In the framework, these
  relationships can also be created through code.
• One-to-Many Relationship
• Many-to-Many Relationship
• One-to-One Relationship

8
Online .NET Certificate Exam

• C Sharp .NET Full Stack Developer Diploma Exam
• C Sharp .NET 4.5 Development Certification Exam
• ASP .NET 4.5 Certification Exam
• VB.NET 4.5 Certification Exam
• C .NET Programming And Code Design With UML
  Certification Exam
• VB .NET Full Stack Developer Diploma Exam

9
About StudySection

• Welcome to StudySection - the most loved online
  platform for eCertification in several subjects
  including but not limited to Software
  Development, Quality Assurance, Business
  Administration, Project Management, English,
  Aptitude and more. From more than 70 countries
  students are StudySection Certified. If you are
  not yet StudySection certified it's not late. You
  can start right now.
• Being StudySection Certified helps you take your
  education level few notches up and have an edge
  over other candidates when you need it the most.
  Globally, our students are employed in different
  organizations and are utilizing the benefit of
  being certified with us.