Hello guys, welcome to quick session on the VBA tutorials Do you know we are trying to retrieve the data from the list. Now we are trying to retrieve the data from the database in your registration. For these we need to create the database already created a script which was available to you copy and open studio manager run it here is our table which contains the f5 field product ID name, quantity box size and the price I am already included here some dummy data for That return will be helpful to us. Switching to visit studio and creating the new project of the ASP. NET web application with the title GET request and select the VPI. Okay.
Here is our project folder trimming the data from the database. I'm going to use the Entity Framework for that. Do we need to do another Close it select here, class library, assign the name, product and do it. Okay. We does not need to class one.cs. So I'm going to right click and add new data and a do entity model and use the abroad model name.
We need to create the entity model from the database so select the first option and click on Next. Assembly z a new connection Write the server name. Select the database, click next and for success you can also change the name of your entity. Click on Next I'm going to use Entity Framework 6.0 and select a table that you want to use for the entity. Change the name for that model. Thankfully companies or entities created it creates all the property which are exiting the Our table we need to add the reference should that project in the our API project, select the project and select the entity.
Okay. Now we need to add the new controller. Right click on the controller folder, select the controller. I'm going to use the empty controller. controller name would be a product controller. First of all we need to add the our entity namespace that is a product entity.
Then we need to create the metaphor, crushing data. We are going to create the toolkit My third one will fit in the ienumerable of the prototype and the another return the instance of the product. First of all we will refer to the all of the data. For that I'm going to write the public I enumerable of product of my time which does not require the any parameters using corporate entities at the core to know can TV Return door products door to list the product class was not created by us it was created by the product entity itself. If I click and go to definition here is its definition which contain the product ID name, quantity, book size and the price which was exist in the our product table. And we were reviewing the all of the products from the entity as written as the least.
Now going to build your solution Opening the API is less controller name that is the product who can see that it will generate the exception. No connection string name product entity could be pounding The our application configuration file. For that, we need to open the app dot config file of the our entity project and copy that connection string straight into the dot config. next section we need to rebuild our solution and reload that page. You can see that it returned the adoptee a product, which can then be a multiple product elements which are accessing the database with the all of the items including the product ID, quantity, price, name, and more. says those are sorted by the name.
So box Id come the flesh instead of the product ID. Those all properties are sorted. That's why the book says first instead of the product ID going to write to get metadata shoot a specific item which will return the product and take the ID as a parameter. Again we need to use the using statement. corporate entities, entity or equal to new product entity Create the instance up here product name and put your form and today's product. First of all before x, such that dot product ID equal equality, IQ and Id we need to return the product insurance can be the solution.
I'm going to open the postman plugin Copy the URL, state and write the API slash Florida which will return all of your products. And now we're going to write here assuming the product of ID three, which is a pain and you can see that it returned the pain. But what happened when we are using the ID which does not really exist? In that case, it is returning DNA with the status code 200 that is okay. But in the IRS full services we need to return the 404 not found status code. So we need to modify it open the original studio.
For that instead of returning the product instance we need to return the TTP response message. And we need to check that if product is no then we need to return the request nor create a response for that with the database status code. Model phone that is for To sit and do a message that is product with you on ID does not exist otherwise we need to return request dot create response with the status code, okay and as to order object itself and click on the period resend the request. Here is we are receiving the message product with Diego and it does not exist at 404 more phone status. Now trying to send the request for the ID which exist. That's it.
It's written in the order detail with the status code 200. In this reality in this lesson we are learn about the HTTP response message. A TTP response method is a way to returning the message or the data from the our action that is a method. request or create response or request dot create error response metadata used to create the UDP response message is the two parameter. Firstly is HTTP status code which will set the status code for the our ITP response and the type T. It is the object that we are really want to return. Here is a core for returning the all of the element from the entity.
Can here is a code for returning the data for the specific ID. Thanks for watching.