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
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.
Experience with fundamental C# programming Experience with ASP.NET preferably MVC Basic T-SQL querying