Referral program

Data Access in C# and .NET Core

Rp500,000 Rp99,000

SKU: MS1052800125 Categories: , , ,
Product price
Additional options total:
Order total:
  • Description
  • Unit Outline
  • Instructor
  • Additional information
  • Certificate
  • Reviews (0)


About this course

This course demonstrates the use of Microsoft data access technologies using C# and .Net Core. Students will learn everything they need to know to develop a data layer for their applications. This course provides instruction in both text and video in order to provide the student with relevant learning opportunities.

Labs will help students add to an existing database, and build out parts of a functional data layer. Real world examples will be used to keep the instruction relevant for the students.

What you’ll learn

  • Introduction to Entity Framework
  • Introduction to Object Relational Model (ORM).
  • Creating Asynchronous Methods.
  • Scaffold entity objects from an existing database.
  • Basic data operations.
  • How to query data.
  • LINQ basics.
  • Lambda basics.
  • Migrations.
  • Entities relationships.
  • Eager and lazy loading.
  • Transactions.
  • Seeding databases.
  • Performance optimizations.

Estimate Time : 16 hours

Module 1 Introduction to Entity Framework

  • Intro to ORM
  • Intro to Entity Framework
  • Importing schema from an existing database
  • Code First Approach
  • Basic data operations

Module 2 Querying Data

  • Sorting and Paging
  • LINQ and LAMBDA Expressions
  • Migrations
  • Keys
  • Indexes

Module 3 Related Entities

  • Types of Data Relationships
  • Querying all types of relationships
  • Lazy and Eager loading

Module 4 Advance Topics

  • Transactions
  • Performance optimizations
  • Updating disconnected entities
  • Executing
  • Seeding the database

Matt Dixon

Matt is owner and founder of Front Range Systems, a software consulting company focusing on custom software solutions for its clients. Matt loves solving complex problems with simple software solutions. He has helped organizations through mentorship and training and specializes in professional and enterprise solutions with various technologies including HTML5, AngularJS, ASP.Net, WPF and C#.

Marwa Hussein

Marwa Hussein is a Content Developer at Microsoft. Marwa has worked in Microsoft as a software developer for about 4 years before she switched her focuses to the education track at Microsoft. Before Microsoft, Marwa worked for 7 years on creating and teaching computer science courses for undergraduate students. Marwa is passionate about teaching and believes that learning is a continuous journey for a person to grow and flourish.

Daren May

Daren May is the President and founder of CustomMayd— a company that specializes in designing and building developer training and next-level digital experiences. Daren is a Windows Development MVP and has written and presented many training courses including Microsoft Virtual Academy videos.


Additional information

Author / Publisher







When you enrolled into this course you will automatically get a Certificate of Achievement for completing the course. An example is provided below.


There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You've just added this product to the cart:

Invite & Earn

Signup to start sharing your link

Available Coupon