Welcome to MG Infosoft

Entity Framework

Software Information
Entity Framework is an object-relational mapper (O/RM) that enables .NET developers to work with a database using .NET objects. It eliminates the need for most of the data-access code that developers usually need to write.

Entity Framework is an object-relational mapper (O/RM) that enables .NET developers to work with a database using .NET objects. It eliminates the need for most of the data-access code that developers usually need to write.

Prior to .NET 3.5, we (developers) often used to write ADO.NET code or Enterprise Data Access Block to save or retrieve application data from the underlying database. We used to open a connection to the database, create a DataSet to fetch or submit the data to the database, convert data from the DataSet to .NET objects or vice-versa to apply business rules. This was a cumbersome and error prone process. Microsoft has provided a framework called "Entity Framework" to automate all these database related activities for your application.

Entity Framework is an open-source ORM framework for .NET applications supported by Microsoft. It enables developers to work with data using objects of domain specific classes without focusing on the underlying database tables and columns where this data is stored. With the Entity Framework, developers can work at a higher level of abstraction when they deal with data, and can create and maintain data-oriented applications with less code compared with traditional applications.

Entity Framework is an object-relational mapper (O/RM) that enables .NET developers to work with a database using .NET objects. It eliminates the need for most of the data-access code that developers usually need to write.

Cross-platform: EF Core is a cross-platform framework which can run on Windows, Linux and Mac.

Modelling: EF (Entity Framework) creates an EDM (Entity Data Model) based on POCO (Plain Old CLR Object) entities with get/set properties of different data types. It uses this model when querying or saving entity data to the underlying database.

Course Content

  • Introduction
  • Entity Framework Backend
  • Entity Framework Features
  • The EDM in the Designer Window
  • Code Generation from EDM to Classes
  • CSDL : Conceptual Schema Definition Language
  • SSDL : Store Schema Definition Language
  • Querying the Model
  • Linq to Entities Queries
  • Entity SQL Queries
  • Entity Client Queries
  • Translation of Queries to Database Queries
  • CRUD Operation
  • How ObjectContext Manages Entities
  • Adding New Entities
  • Updating Entities
  • Deleting Entities
  • Stored Procedure with EDM
  •  Adding Stored Procedure to the Model
  • Working with Functions
  • Implementing Functions
  • Mapping Table
  • Table Per Type Inheritance
  • Table Per Hierarchy Inheritance
  • Table Per Concrete Type Inheritance
  • Conditional Mapping
  • Creating Complex Type
  • Relationship
  • One to One
  • One to Many
  • Many to One
  • Many to Many
  • Db First Approach
  • Code First Approach
  • Transaction Management

When everything seems to be going against you, remember that the airplane takes off against the wind, not with it.

Henry Ford
1

FILM PRODUCED

45000

HOURS TRAINING

5000

STUDENTS ENROLLED

4

CERTIFIED TEACHERS

choose your course