\n
![\"What](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/image-15.png\")
\nKey features of API <\/strong><\/p>\n
- \n
- Supports HTTP verbs like GET, POST, PUT, DELETE, etc., which allows clients to perform different actions on the data <\/li>\n
- Supports default responses such as XML and JSON, standard formats which help exchange data between the client and the server.<\/li>\n
- API can define custom data which allows you to tailor the data as per client requirements<\/li>\n
- APIs are either self-hosted or hosted by third parties, which means you have flexibility in using them.<\/li>\n
- It allows easy authorization and authentication, which helps control access to API crud operations and protects your data.<\/li>\n
- API is an ideal platform for building RESTful services for designing web services that are scalable, flexible, and easily maintained.<\/li>\n<\/ul>\n
Why do we need Web API?<\/h2>\n
People nowadays use multiple devices such as smartphones, tablets, and iPhones; therefore, more than a web-based application is needed to reach out to all users. We need an API to expose all these service data to all the different device apps and browsers. Adding a web API project makes it easier to bridge the two ends, making it easier to manage and update.<\/p>\n
In this case, we need a Web API to manage the database interactions and business logic between a website, an Android app, and an iOS app.<\/p>\n
All three applications can communicate with the database through the Web API project, which handles all database interactions and ensures that the database is not directly accessible through the websites or applications. <\/p>\n
By using a Web API, we can ensure secure and efficient communication between the different applications and devices, making it an essential tool in modern application development.<\/p>\n
What’s new in .NET 6?<\/h2>\n
Let us have a look at some of the major highlights.<\/p>\n
- \n
- Hot Reloading<\/strong> allows developers to modify the user interface while the application is still running. Changes are reflected in real-time without rebuilding or starting the app.<\/li>\n
- Minimal APIs<\/strong> for developers to build lightweight services without needing templates or controllers, using extension methods of \u201cEndpointConcentionBuilder\u201d in the Startup or Program class.<\/li>\n
- The HTTP logging middleware<\/strong> can log HTTP request and response information like headers, body, and properties to enhance debugging and monitoring<\/li>\n
- The Blazor<\/strong> web framework used for building interactive web applications with c# has improved performance, event binding, and support for pre-rendering components.<\/li>\n
- ASP.NET Core program and Startup classes are merged to simplify the code structure.<\/li>\n
- Support for cloud-native development<\/strong> through integration with Kubernetes and other cloud platforms.<\/li>\n
- Enhanced JSON support<\/strong> through the introduction of a new source generator<\/li>\n
- .NET Core has now improved support for gRPC and GraphQL APIs.<\/strong>
\nThe use of OpenSSL 3 and support for runtime defense-in-depth mitigations enhance the security of the .NET core.<\/li>\n- Support for Single-file applications without extraction<\/strong> on Windows, macOS, and Linux.<\/li>\n
- The re-written FileStream improves performance for I\/O operations, especially for file I\/O.<\/li>\n
- Improved source code generation<\/strong> with a new source generator framework.<\/li>\n
- Improved .NET MAUI (Multi-platform App UI)<\/strong> support for building cross-platform mobile and desktop apps.<\/li>\n
- Improvements to the .NET runtime<\/strong> include enhanced garbage collection, improved ARM-based platforms performance, and hardware intrinsics support.<\/li>\n
- Entity Framework Core<\/strong> has improved support for Cosmos DB and a new LINQ syntax for querying nested JSON data.<\/li>\n
- Visual Studio tooling<\/strong> has improved with new project templates and integration with GitHub.<\/li>\n<\/ul>\n
Prerequisites: Web API in .NET 6.0<\/h2>\n
- \n
- Visual Studio 2022.<\/li>\n
- .NET SDK 6.0.<\/li>\n
- Sql-Server.<\/li>\n
- \n
- Microsoft.EntityFrameworkCore.Tools<\/li>\n
- Microsoft.EntityFrameworkCore.SqlServer<\/li>\n
- \n
Follow the below instructions to install NuGet packages.<\/strong> <\/p>\n
Right-click on Dependencies and select Manage NuGet Packages.<\/strong><\/p>\n
![\"Add](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/5-min.png\")
<\/p>\nMicrosoft.EntityFrameworkCore.Tools<\/strong><\/p>\n
Select the Browse<\/strong> tab and search for Microsoft.EntityFrameworkCore.Tools<\/strong> and install its latest stable version.<\/p>\n
![\"Add](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/6-min.png\")
<\/p>\nMicrosoft.EntityFrameworkCore.SqlServer<\/strong><\/p>\n
Once the above package is installed, Search for Microsoft.EntityFrameworkCore.SqlServer<\/strong> and install its latest stable version.<\/p>\n
![\"Add](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/7-min.png\")
<\/p>\nCreate SQL Database and Table.<\/h2>\n
Moving to the next section of the Web API in .NET 6.0 Tutorial, create New Database ProductDB<\/strong> in SQL, and execute the below script to create a Product<\/strong> table.<\/p>\n
USE [ProductDB]\r\nGO\r\n\r\nSET ANSI_NULLS ON\r\nGO\r\n\r\nSET QUOTED_IDENTIFIER ON\r\nGO\r\n\r\nCREATE TABLE [dbo].[Products](\r\n\t[Id] [int] IDENTITY(1,1) NOT NULL,\r\n\t[Name] [varchar](50) NOT NULL,\r\n\t[Description] [varchar](250) NULL,\r\n\t[Price] [decimal](18, 2) NOT NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[Id] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO<\/pre>\n
Create DB Context and Model <\/h2>\n
Now, let’s move on to the next step of our web API tutorial, where we will create the DBContext and Model.<\/p>\n
We are using the database first approach of entity framework.
\nWe have created a database table, and using the Scaffold-DbContext command of the entity framework; we will create the required class in the C# project.<\/p>\nOpen Package Manager Consol<\/strong> (Tool => Package Manager => Package Manager Consol) and run below command:<\/p>\n
Scaffold-DbContext \"Server=SERVERNAME;Database=ProductDB;Integrated Security=True\" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models<\/pre>\n
Replace SERVERNAME<\/strong><\/mark> with your database server name.<\/p>\n
![\"Create](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/8-min.png\")
<\/p>\nOnce this command is executed, the Model folder is created in the project solution. Model folder contains two files, ProductDBContext.cs<\/strong> and Product.cs. <\/strong><\/p>\n
![\"Create](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/9-min.png\")
<\/p>\nProductDBContext.cs <\/strong>is responsible for database interaction, and Product.cs<\/strong> is a model of the Products table.<\/p>\n
Remove OnConfiguring()<\/strong> method from ProductDBContext.cs; it contains a database connection string and is not a good practice. We will add the connection string in the appsettings.json file. <\/p>\n
Also remove ProductDBContext()<\/strong> constructor from this file. <\/p>\n
Build a .NET application is easier and hustle-free with Bacancy!<\/span>
\nHire NET developer<\/a> who will help you meet your project requirements efficiently with commendable problem-solving skills.<\/i><\/strong><\/p>\nConfigure DB Connection<\/h2>\n
Add database connection string in appsettings.json <\/strong>file.<\/p>\n
{\r\n \"Logging\": {\r\n \"LogLevel\": {\r\n \"Default\": \"Information\",\r\n \"Microsoft.AspNetCore\": \"Warning\"\r\n }\r\n },\r\n \"AllowedHosts\": \"*\",\r\n \"ConnectionStrings\": {\r\n \"ProductDB\": \"Server=SERVERNAME;Database=ProductDB;Integrated Security=True;\"\r\n }\r\n}<\/pre>\nReplace SERVERNAME<\/strong> with your database server name.<\/p>\n
As we are using the .Net 6 version, we need to make the required configuration changes in Program.cs<\/strong> file. Microsoft eliminates Startup.cs<\/strong> in .Net 6. In the previous .Net version, Startup.cs<\/strong> was used for configurations.<\/p>\n
Add below lines in Program.cs.<\/strong> Please refer to the below image for this.<\/p>\n
var connectionString = builder.Configuration.GetConnectionString(\"ProductDB\");\r\nbuilder.Services.AddDbContextPool
(option =>\r\noption.UseSqlServer(connectionString)\r\n);<\/pre>\n Also, add the below lines at the top of the Program.cs.<\/strong><\/p>\n
using Microsoft.EntityFrameworkCore;\r\nusing ProductAPI.Models;<\/pre>\n
![\"Configure](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/10-min.png\")
<\/p>\nAdd Products Controller<\/h2>\n
Add a new empty API controller ProductsController.cs<\/strong> under the controller folder.<\/p>\n
![\"Add](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/11-min.png\")
<\/p>\n![\"Add](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/12-min.png\")
<\/p>\nBacancy is not an option. Bacancy is a reliable choice!<\/span>
\nAre you looking for a leading NET development company<\/a> to develop your dream product? We are here for you! Trust your choice. Connect Now!<\/i><\/strong><\/p>\nAdd Methods in ProductsController<\/h2>\n
In ProductsController.cs,<\/strong> we will add GET, POST, PUT, and DELETE endpoints to achieve CRUD operations. <\/p>\n
Please use the below code in your ProductsController.cs.<\/strong><\/p>\n
Launch API<\/h2>\n
Finally, we are done with Web API in .NET 6.0 tutorial. Now, it\u2019s time to launch this API, press F5. As we are using Swagger UI, we can execute API directly.<\/p>\n
We can see GET, POST, PUT AND DELETE under Products. We can execute different API methods from this page itself.<\/p>\n
![\"Launch](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/13-min.png\")
<\/p>\nGithub Repository: Web API in .NET 6.0 Example<\/h2>\n
Create Project<\/h2>\n
Start Visual Studio and create a new project with the type ASP.NET Core Web API<\/strong> and click Next.<\/p>\n
![\"Create](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/1-min.png\")
<\/p>\nEnter the project name ProductCrudAPI,<\/strong> select the location where you want to save your project, and click Next.<\/strong><\/p>\n
![\"configure](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/2-min.png\")
<\/p>\nSelect .Net 6.0<\/strong> (Long-term support) as a framework. Fill in the required information as shown in the below image, and click on Create.<\/strong><\/p>\n
![\"add](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/3-min.png\")
<\/p>\nOnce you click on Create, a Web API project will be created.<\/p>\n
![\"Create](\"https:\/\/www.bacancytechnology.com\/blog\/wp-content\/uploads\/2022\/06\/4-min.png\")
<\/p>\nAdd NuGet Packages<\/h2>\n
To use the entity framework core<\/a> in our project, we need to install two NuGet packages:<\/strong><\/p>\n
- \n
- Minimal APIs<\/strong> for developers to build lightweight services without needing templates or controllers, using extension methods of \u201cEndpointConcentionBuilder\u201d in the Startup or Program class.<\/li>\n
- Hot Reloading<\/strong> allows developers to modify the user interface while the application is still running. Changes are reflected in real-time without rebuilding or starting the app.<\/li>\n