CRUD Operation in ASP.NET Web API with Entity Framework

CRUD Operation in ASP.NET Web API with Entity Framework

In this article we are going to discuss CRUD Operation in ASP.NET Web API with Entity framework. we will learn how to perform CRUD operations with ASP.NET Web API and Entity Framework. We’ll go step by step in the form of a tutorial to set up a basic Web API project and we’ll use the code-first approach of Entity Framework to generate the database and perform CRUD operations and this ASP .NET Web API CRUD operation is to be test in Postman tool.

What is ASP .NET Web API ?

ASP.NET Web API is a framework that makes it easy to build HTTP services that reach a broad range of clients, including browsers and mobile devices. ASP.NET Web API is an ideal platform for building RESTful applications on the . NET Framework.

“HTTP is not just for serving up web pages. HTTP is also a powerful platform for building APIs that expose services and data. HTTP is simple, flexible, and ubiquitous. Almost any platform that you can think of has an HTTP library, so HTTP services can reach a broad range of clients, including browsers, mobile devices, and traditional desktop applications.ASP.NET Web API is a framework for building web APIs on top of the .NET Framework.”

The above reference was taken from Microsoft Documents.

What is Entity Framework ?

Microsoft Entity Framework is an ORM (Object-relational mapping). The definition from Wikipedia is very straightforward for ORM and petty much self-explanatory,

“Object-relational mapping (ORM, O/RM, and O/R mapping tool) in computer science is a programming technique for converting data between incompatible type systems using object-oriented programming languages. This creates, in effect, a “virtual object database” that can be used from within the programming language.”

Create ASP .NET Web API Project

We do the project form scratch and Use Visual studio 2017 with .NET Version 4.6.1

ASP .NET Web API CRUD-Create Project
Choose ASP .NET Web Aplication
ASP .NET Web API CRUD-choose empty project
Choose Project template as Empty then choose Web API

After click the OK button it create the empty API project like below.

Customer API Project
Customer API Project
Create the Model Class

Here we create the model class that treated as entity of customer object that should be done database operations. Right click on the Models folder and add the class named as Customer with following properties.

  • Here we create the Customer Model with above properties.
  • [Table(“Customer”)] is belong to System.ComponentModel.DataAnnotations.Schema namespace. Here Customer is the table name that we want to create dynamically using EF code first.
  • CustId is the primary key of our entity table so we added as [Key]

After creating the Models class must rebuild the applications. To rebuild the project right click on Project and then click Rebuild.

Adding the API Controller

To do database operations to create, update,read and delete over model class we need to create the controller that should do the CRUD operations for us. To create the Controller right click on the Controllers folder and add a new Controller and in the prompt choose as Web API2 controller with actions, using Entity framework like below. Here we can use in-built entity framework scaffold technique to create CRUD query for us.

ASP .NET Web API CRUD-API2 Controller
Choose Web API2 Controller with actions using EF

After click the Add button a prompt will open to scaffold the model to create CRUD operations and choose Web API2 controller with actions, using Entity Framework.

ASP .NET Web API CRUD-Context class
Model Scaffold to create Web API Controller
  • In the Model Class choose the Model, in our case it is customer model class.
  • In the Data Context class, add + symbol and add the CustomerAPI Context.
  • Controller name in our case is CustomerController

After create the scaffold controller automatically it create the CRUD ( Create, Read, Update, Delete ) operations using Customer Model class and CustomerAPI Context class like below.

API Context Class

After adding the scaffold controller the API context class is also created inside the Model folder like below, that should contains the context of database schema. Here you can see CustomerAPIContext class implement the DbContext and base(“name=CustomerAPIContext”) is the name of the connection string to communicate with DB.

aspnet crud webapi-API Context
API Context
Entity Framework Code First Migrations

Code first migrations here help you to update the existing database with your newly added model classes and your existing database remains intact with the existing data.

  • Open Package manager console of the API project and type the command Enable-Migrations and hit enter.
Enable Migration

After adding this command a Migrations folder is generated like blow with crating the Configuration.cs class. This class is derived from DbMigrationsConfiguration class. This class contains a Seed method having the parameter as the context class that we got generated in the Models Seed is an overridden method that means it contains a virtual method in a base class and a class driven from DbMigrationsConfiguration can override that and add custom functionality.

ASP .NET Web API CRUD-Migrations
Migrations
  • The next step is to execute the command named “Add-Migrations”. In the package manager console. The command would be Add-Migrations Initial “Initial” is the parameter we have use, you may be use any other text as per your choice.
asnet web api crud-Add migration initial
Add migration initial

After executing the command it adds a new file with the name “Initial” prefixed with the date time stamp. It prefixes the date time stamp so that it could track the various migrations added during development and segregate between those. Open the file and we see the class named “Initial” deriving from DbMigration class. This class contains two methods that are overridden from DbMigration class i.e. the base class. The method names are Up() and Down().

aspnet crud weba pi migration initialal
Migration

The Up method is executed to add all the initial configuration to the database and contains the create command in LINQ format. This helps to generate tables and all the modifications done over the model. Down command is the opposite of Up command. The code in the file is self-explanatory. The Up command here is having the code that creates the Students table and setting Id as its primary key. All this information is derived from the model and its changes.

  • The final command that creates the database and respective tables out of our context and model. It executes the Initial migration that we added and then runs the seed method from the configuration class. This command is smart enough to detect which migrations to run. For example it will not run previously executed migrations and all the newly added migrations each time will be taken in to account to be executed to update the database. It maintains this track as the database firstly created contains an additional table named __MigrationHistory that keeps track of all the migrations done.
  • The command is Update-Database
aspnetcrud webapi Update-Database
Update-Database

After the command execution, it creates the database in the specified server as per your server and adds the corresponding connection string to the Web.Config file. The name of the connection string is the same as the name of our context class and that’s how the context class and connection strings are related.

<connectionStrings>
    <add name="CustomerAPIContext" connectionString="Data Source=ServerName; Initial Catalog=customers; User ID=sa;password=*****;"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

Now it automatically create the database named as “customers” with table name “customer”. Also it holds the migration history in the tables.

Exploring the Generated Database

You can see when navigate to SQL Server, find their the database is created for us.

aspnet webapi crud
ASP NET Web API CRUD Operation DB explorer

Test the CRUD operation using Postman

What is Postman ?

Postman is an API(application programming interface) development tool which helps to build, test and modify APIs. Almost any functionality that could be needed by any developer is encapsulated in this tool. It is used by over 5 million developers every month to make their API development easy and simple. It has the ability to make various types of HTTP requests(GET, POST, PUT, PATCH). It can be downloaded into the system or you can use it bu using Google chrome extension.

Web API Create method test using Postman

Open the Postman tool and run the application and here we want to create the customer data that means we push the customer information so like below we can push the data.

  • Here http://localhost:49243/api/Customers is the URL to create CRUD operation.
  • /api/Customers customers is the controller that we have created.
  • Here we want push the information to database so need to choose POST method in Postman.
  • In the Body section append the inputs in json format as formatted above.
  • Click the send button and then the data is pushed to database using post method like below;
ASP NET WEB API POST Operation
aspnet web api crud post method
Web API CRUD Post method
asp net crud web api post method insertion
Web API Post method Insertion
Web API READ method test using Postman

Her we see how to read the data using postman in GET method. In postman we can change the method type to GET and call the below mentioned Web API URL.

  • Below you can see we call the same URL http://localhost:49243/api/Customers with changing the method as GET to READ the data.
  • It call the get method and fetch the result set as JSON format in below.
ASP NET Web API GET Customers data
asp net crud web api get result
GET Method call
Web API UPDATE method test using Postman

Her we see how to update the data using postman in PUT method. In postman we can change the method type to PUT and call the below mentioned Web API URL.

  • Below you can see we call the same URL http://localhost:49243/api/Customers with changing the method as PUT to UPDATE the data by passing the Id.
  • To get the corresponding Id it can update the request.
ASP NET WEB API Update Operation Code
asp net crud web api update result
ASP NET WEB API Update Operation result
Web API DELETE method test using Postman

Her we see how to delete the data using postman in DELETE method. In postman we can change the method type to DELETE and call the below mentioned Web API URL.

  • Below you can see we call the same URL http://localhost:49243/api/Customers with changing the method as DELETE to delete the data from database.
  • To delete the request we follow the below code in controllers.
ASP NET Web API Delete Operation
ASP NET Web API Delete Result
  • On above we pass the delete item id as 2 so it delete the record and for confirmation we bind the deleted data inn response body tag.
  • When we move to database and refresh the table and find their the item is deleted for id 2.
asp net crud web api delete operation result
DELETE Operation result

Web API GET by ID method test using Postman

ASP NET Crud Operation Customer By ID
  • By passing only Id you can fetch the result of the one customer.

Video Reference

Summary

In this article we explained how to create APP .NET Web API using entity framework code first approach and how the crud operation is test using Postman tool. If have any suggestion for improvement to this article then feel to free write to us.

Export data into Excel in ASP.NET MVC
Export-data-into-Excel

In this example we learn how to export the data into MS Excel in ASP.NET MVC without using any 3rd Read more

Export data into PDF in ASP.NET MVC
Export-Data-into-PDF-SERVICE

In this example we use Dapper ORM to fetch the data from database and using the data we export into Read more

Worker Service in .NET Core
worker-service

A worker service is a .NET project built using a template which supplies a few useful features that turn a Read more