Skip to main content

Data Access in C# and .NET Core

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.

Prerequisites

  • Basics of the C# Programming Language
  • Object Oriented Programming

Meet the instructors

Daren May

Daren May

President and founder of CustomMayd
CustomMayd

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.

Matt Dixon

Matt Dixon

Owner and Founder
Front Range Systems

Matt is owner and founder of Front Range Systems, a software consulting company focusing on custom software solutions for its clients. Matt has over 16 years of professional development experience, and loves solving complex problems with simple 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

Content Developer
Microsoft Corporation

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.

Classes Start
Classes End
Estimated Effort
Total 8 to 16 hours
Enroll