Hi how are you? I continue from where we left off in the previous post. what we'll do is We will add Entity Framework migration and update the database then we will read the data from the Database. So what are we doing? We check our version and then we need to install the Entity framework tool. ```javascript dotnet tool list -g ``` onurtaskiran

```javascript dotnet tool install --global dotnet-ef --version 5.0.6 ``` You'll probably see this blank if you've never installed this tool before. Now it's okay if this tool is ahead of your entity framework version, but if your entity framework version is ahead of the tool then you will get an error and need to update the tool itself. ```javascript dotnet tool update --global dotnet-ef --version 5.0.6 ``` And install this package as well. onurtaskiran

we need to add the initial migration to create the database. ```javascript dotnet ef migrations add InitialCreate -o Data/Migrations ``` onurtaskiran

we can see we have a new folder called migrations. Here is our migrations file ```javascript using Microsoft.EntityFrameworkCore.Migrations; namespace API.Data.Migrations { public partial class InitialCreate : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "Products", columns: table => new { Id = table.Column(type: "INTEGER", nullable: false) .Annotation("Sqlite:Autoincrement", true), Name = table.Column(type: "TEXT", nullable: true) }, constraints: table => { table.PrimaryKey("PK_Products", x => x.Id); }); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "Products"); } } } ``` We are updating our database. ```javascript dotnet ef database update ``` onurtaskiran

inside our API folder is that we now have the database that was created, onurnet.db onurtaskiran

what we can do now is go and take a look at that database. onurtaskiran

Click on the table the products table and say new query insert. onurtaskiran

what we actually want to do is actually add a small amount of data to our products table. ```javascript -- SQLite INSERT INTO Products (Id, Name) VALUES (1, 'Product small'), (2, 'Product middle'), (3, 'Product big'); ``` just say run query onurtaskiran

if we just go ahead and show table for the products again and click on the table, we can now see that we have these three records onurtaskiran

We create a class called ProductController in our Controllers folder. ```javascript using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using API.Data; using API.Entities; using Microsoft.AspNetCore.Mvc; using Microsoft.EntityFrameworkCore; namespace API.Controllers { [ApiController] [Route("api/[controller]")] public class ProductsController : ControllerBase { private readonly StoreContext _context; public ProductsController(StoreContext context) { _context = context; } [HttpGet] public async Task>> GetProducts() { var products = await _context.Products.ToListAsync(); return Ok(products); } [HttpGet("{id}")] public async Task> GetProduct(int id) { return await _context.Products.FindAsync(id); } } } ``` Let's see the result in postman. All products onurtaskiran

Single product onurtaskiran