Description
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.