Advanced Rest Api's with .Net Core , MSSQL & MongoDB

Create a new Web API project in Visual Studio, target .NET 6 preview, enable automatic API documentation, remove default weather forecast files, and prepare to add custom models and controllers.

Create a user model in a models folder and define properties id as a Guid, name, address, phone, and blood group as strings, establishing a primary key in the database.

Create a public user interface in an Interfaces folder with async methods for get all users, get user by id, add, update, and delete, enabling dependency injection to wire services.

Install the Entity Framework Core and SQL Server NuGet packages in the web app project to enable database integration with MSSQL DB.

Implement a code-first DbContext in EF Core, configure it with DbContextOptions, and expose a users DbSet to map to the database.

Add the SQL Server connection string in the service configuration, register the DbContext, specify the server name and initial catalog, and prepare for migrations.

Install the migration tools package, add migrations with the appropriate command, then run update-database to create the database and tables in SQL Server Object Explorer.

Add and implement a user service, injecting the deep context, and build async crud methods (get all, get by id, add, update, delete) with save changes.

Apply dependency injection in the Gore project by using interfaces and the built-in IOC container to resolve dependencies, then register the interface and service with add scope for constructor injection.

Create an api controller, ensure the name ends with 'Controller', inject the service interface via the constructor using IoC container, and implement get, post, put, and delete actions with async methods.

Learn to run and test a dotnet core api project using swagger. Execute post, get, put, and delete operations on a user resource, and verify updates and deletions in browser.

Explore error handling and status codes in rest api design using a service layer and dependency injection, returning success indicators, data, and error messages for get, update, and delete operations.

Refine the user service by implementing get all and get by id methods returning a triplet of success flag, user list, and error message, with null checks.

Develop add, update, and delete methods in the service class, validate the user object via the interface, and return success status or error messages to support robust rest operations.

Update the controller class to return status codes with data using a result object; implement get, post, put, and delete methods with appropriate 200, 201, or 204 responses.

Apply and verify rest api operations in a .net core project by sending post, get, put, and delete requests, observing 201 created, 200 ok, and 204 no content status codes.

Explore data transfer objects and how they mirror model properties to safely send data from the api in enterprise applications, avoiding exposure of model classes in api responses.

Create a user dto and map its properties to the user model, so the user interface and contracts use the dto instead of direct database access, reducing manual mapping.

Install and register the automapper nuget package, define a mapping profile with reverse mapping, and map between dtos and models in the .net core rest api.

Implement auto mapper in the user service to map user detail to the user entity, replacing manual mapping and ensuring data flows to and from the database.

Learn about OData, an open source protocol that enables search, pagination, and ordering with a single endpoint, reducing payload and avoiding over-fetching in REST APIs.

Configure auditor services in a REST API and enable OData querying with select, filter, and order by to fetch names and phone numbers from the users controller.

Explore rate limiting in restful APIs, showing why it protects endpoints from abuse with five requests in two minutes example; install a package to implement it.

Register an in-memory rate limit store and configure the IP rate limiting middleware to enforce a rule of ten requests per three minutes across all endpoints.

Understand what MongoDB is and why we need a non-relational database for document and collection storage. Compare relational and non-relational databases, where collections replace tables and documents replace rows.

Set up MongoDB by downloading the MongoDB community server and MongoDB Compass, connect to localhost, create a database and collection, and insert documents with fields like phone and address.

Install the Modiba Newgate package in the NDP project and add a named connection string to the configuration for localhost MongoDB, preparing for the memory client in the next lesson.

Remove the SQL context and switch to a MongoDB client, configure the connection string via app settings, and initialize the users collection with the database and collection names.

Master MongoDB CRUD operations in a .NET Core RESTful API by learning to retrieve data with find and firstOrDefaultAsync, insert, replace, and delete using lambda expressions.

Deploy Azure Cosmos DB API for MongoDB in the Azure portal and create a serverless account with a database and collection using unsharded 20 GB capacity.

Connects an Azure MongoDB instance to a Rest API, updates the service with the database and collection names, and validates data via the data explorer in the Azure portal.

Create a web app in Azure, using the same resource group as the Azure Cosmos TV API for Modiba, name the app, choose the runtime stack version, and deploy.

Publish the Asia web application to Microsoft Azure using the Azure published profile, then configure Swagger to expose API documentation and verify the API endpoints, including the MongoDB API.