• Length:
    4 Weeks
  • Effort:
    2–4 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $99 USD

  • Institution
  • Subject:
  • Level:
    Intermediate
  • Language:
    English
  • Video Transcript:
    English

Prerequisites

Experience with fundamental C# programming Experience with ASP.NET preferably MVC Basic T-SQL querying

About this course

Want to build on your professional database or developer skills? ADO.NET and Entity Framework sit at the intersection of database and developer tools, and they’re key to creating client applications that read, write, and modify data. This self-paced course offers a deep dive into these fundamental technologies.

The course starts by accessing relational databases with ADO.NET, which is used by applications to retrieve, handle, and update data. You will get an overview of the technology, explore its history, and then look at the specifics of data providers, access, and queries. In the hands-on lab, build a simple console application to access SQL data.

You will also learn about building data client apps with Entity Framework Core, which eliminates the need for most of the data-access code that developers usually need to write. We will review Entity Framework versions, models, queries, and operations, and then build a desktop app. Advanced data access using Entity Framework will also be discussed as you learn about change tracking, and explore testing. Plus, build a web app to access SQL Data.

At the end of the course, you will learn how to build a scalable web service that accesses data and implement a functional cloud service using Entity Framework as the data layer and an OData feed using Web API. You wil test your service, and then implement basic sorting and filtering of your data service.

Bring your basic web programming and C# experience, along with your knowledge of querying relational data and data storage. Take the labs, assessments, and final exam, and add to your professional developer skillset as you learn to build various kinds of client applications that access and work with data.

What you'll learn

  • Access relational databases with ADO.NET
  • Build cross-platform data client applications with Entity Framework Core
  • Advanced data access techniques with Entity Framework
  • Build REST APIs with Entity Framework and Web API

Meet your instructors

Pete Harris
Senior Content Developer
Microsoft’s Learning Experiences
Sidney Andrews
Microsoft Certified Trainer, Cloud Applications Consultant
SeeSharpRun.NET

Pursue a Verified Certificate to highlight the knowledge and skills you gain $99.00

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally