Remote Binding KendoGrid Using WEB API 2 ODATA v3 And Entity Framework

1. It is an open data protocol to exchange the data between client and server.
2. The odata uses a REST architecture to send particular types of message over HTTP.
3. OData standardizes the request/response formats in JSON and AtomXml on how the data and its metadata is structured.
4. OData also specifies a very rich query language to enable consumers query your services for precise information they are looking for with the help of $filter, $orderby, $skip, $top, $expand.

Figure 1

Figure 2

Right-click on the model folder and create a class. In my case I named it Product.

Write the following code in the Product.cs model class.

Here I am using Entity Framework Code first technique so we need to create the context class.

Right-click on the model folder and create one more class. In my case I named it ProductContext.

Write the following code in ProductContext class.

Figure 3

Figure 4

Before implementing the service in the Kendo UI once check the service request/response in Postman / Fiddler.

Figure 5

From the above figure 5 you can observe the service response from server where it consist of metadata and no objects are listed because it is a new database which is created from Entity framework code first technique.

Let us insert some values in table using HTTP POST request as in the following figure 6:

Figure 6