Developing Azure & Web Services: Entity Framework
Visual Studio
| Expert
- 22 videos | 1h 56m 43s
- Includes Assessment
- Earns a Badge
Entity Framework is an object relational mapper (ORM) and uses an object-oriented representation for data. Explore Entity and the operations it provides to make working with data easier.
WHAT YOU WILL LEARN
-
Describe the need for object relational mappers and the development approaches including database first, model first, and code first
Create and configure a dbcontext and query the database using the dbcontext class
Use data annotations to manually map classes to database schema objects
Describe the entity methods for mapping an oop environment to database tables
Use the fluent api to map classes to tables
Work with data model schema definition languages to model data
Define linq and how it interacts with sql and entity
Use linq to entities to query a database
Perform a query against a database using entity sql
Build a query that uses deferred execution
Implement lazy loading and eager loading -
Creating and running compiled queries
Execute sql statements directly using entity and return objects or scalar values
Perform create, read, update, and delete operations using entity
Use change tracking with entity to monitor if an object has changed
Use transactions and the transactionscope class to group operations
Log and track queries and commands sent to a database
Implement entity framework using mysql
Implement entity framework using sqlite
Designing strategy to target multiple databases
Handling on duplicate key
Manipulate data and data models using the entity framework
IN THIS COURSE
-
3m 43sUpon completion of this video, you will be able to describe the need for object relational mappers and the development approaches including database first, model first, and code first. FREE ACCESS
-
4m 2sLearn how to create and configure a DBContext and query the database using the DBContext class. FREE ACCESS
-
3. Using Entity Data Annotations3m 38sIn this video, learn how to use Data Annotations to map classes to database schema objects manually. FREE ACCESS
-
4. Describing Entity Type Inheritance3m 42sAfter completing this video, you will be able to describe the Entity methods for mapping an OOP environment to database tables. FREE ACCESS
-
5. Using Type Inheritance4m 57sIn this video, learn how to map classes to tables using the Fluent API. FREE ACCESS
-
6. Working with Data Modeling3m 7sFind out how to work with data model schema definition languages to create models of data. FREE ACCESS
-
7. Define Language Integrated Query (LINQ)4m 12sIn this video, you will learn about LINQ and how it interacts with SQL and Entity. FREE ACCESS
-
8. Using LINQ to Entities to Query a Database5m 45sIn this video, you will learn how to use LINQ to Entities to query a database. FREE ACCESS
-
9. Performing Queries Using Entity SQL3m 33sIn this video, find out how to query a database using Entity SQL. FREE ACCESS
-
10. Building Queries That Use Deferred Execution2m 52sIn this video, find out how to build a query that uses lazy evaluation. FREE ACCESS
-
11. Implementing Lazy Loading and Eager Loading10m 29sFind out how to implement lazy loading and eager loading. FREE ACCESS
-
12. Creating and Running Compiled Queries6m 31sIn this video, find out how to create and run compiled queries. FREE ACCESS
-
13. Executing SQL Queries Directly4m 22sLearn how to execute SQL statements directly using Entity and return either objects or scalar values. FREE ACCESS
-
14. Performing CRUD Operations Using Entity3m 49sDuring this video, you will learn how to perform Create, Read, Update, and Delete operations using Entity Framework. FREE ACCESS
-
15. Using Change Tracking with Entity4m 20sTo find out how to use Change Tracking with Entity, look for a tutorial or article that explains the process. FREE ACCESS
-
16. Using Transactions with Entity3m 19sFind out how to use Transactions and the TransactionScope class to group operations. FREE ACCESS
-
17. Logging Queries and DB Commands4m 39sLearn how to log and track queries and commands sent to a database. FREE ACCESS
-
18. Implementing Entity Framework Using MySQL17m 32sFind out how to implement Entity Framework using MySQL. FREE ACCESS
-
19. Implementing Entity Framework Using SQLite10m 53sIn this video, learn how to use Entity Framework with SQLite. FREE ACCESS
-
20. Designing Strategy to Target Multiple Databases3m 11sDuring this video, you will learn how to design a strategy to target multiple databases. FREE ACCESS
-
21. Handling ON DUPLICATE KEY3m 18sLearn how to handle ON DUPLICATE KEY. FREE ACCESS
-
22. Exercise: Model Data with Entity4m 50sIn this video, you will learn how to manipulate data and data models using the Entity Framework. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
