Explore ASP.NET Core by delving into MVC design, JSON web APIs, repository patterns, and adding authentication. Gain insights to confidently develop full-stack or backend applications.

asp.tar.gz

ASP.NET

MVC in ASP.NET Core - Models in ASP.NET

MVC in ASP.NET Core - Models in ASP.NET-copy

This course is for you if you’re looking to start your journey in either full-stack MVC or backend development with ASP.NET Core.

In the first half of the course, you’ll learn about the Model-View-Controller design pattern and how you can use it to organize and develop your web application. You’ll then dive into JSON web APIs which allow communication between your back-end ASP.NET application and front-end web/mobile application.

In the latter half, you’ll learn about the repository pattern, how relationships work, and how to add authentication and authorization to your application.

By the end of this course, you will have the confidence to develop your own applications in ASP.NET Core.

Developing Applications with ASP.NET Core

# Introduction
Entity Framework has a reasonable number of built-in functions that help you in accessing your database tables. However, those functions cannot do everything that raw SQL queries can do. Similarly, if you switch your object relations model (ORM) from Entity Framework to something else, you will lose access to its functions.

To overcome this limitation, <t>ASP.NET</t> Core allows you to type in your custom SQL queries.

Examine two simple examples to understand how it works.

# Get all users

First, you will update your controller's `Index()` method. The SQL query that fetches all records from the user's table is:

```C#
select * from TableName
```
Implement this into your action method.

Learn to create and utilize custom "SQL queries" to access your database tables.

Introduction

Getting Started

MVC in ASP.NET Core

JSON Web APIs in ASP.NET Core

Working with Repositories

Relationships

Authentication and Authorization

Appendix

Conclusion

Custom SQL Queries

Introduction