Minimal API - .NET & EF Core

Create a Clean Project

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();

var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();

app.Run();

Add a Model

public class ToDo
{
    public int Id { get; set; }
    public string Title { get; set; }
    public bool IsCompleted { get; set; }
}

Add Connection String

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost; Database=DemoDatabase; Trusted_Connection=false; TrustServerCertificate=True; User Id=sa; Password=password1;"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*"
}

Add Data Access Layer

public class ApplicationDbContext : DbContext
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
    {

    }
}

public DbSet<ToDo> ToDos { get; set; }

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<ToDo>().HasData(
        new ToDo() { Id = 1, Title = "Do Homework", IsCompleted = true},
        new ToDo() { Id = 2, Title = "London", IsCompleted = false}
    );
}

using Microsoft.EntityFrameworkCore;
using MinimalAPI_test.Models;

namespace MinimalAPI_test.Data;

public class ApplicationDbContext : DbContext
{
    public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
    {

    }

    public DbSet<AddressBook> Coupons { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<AddressBook>().HasData(
            new AddressBook { Id = 1, FirstName = "James", Surname = "Bond", Age = 38, Address = "London"},
            new AddressBook { Id = 2, FirstName = "Sherlock", Surname = "Holmes", Age = 45, Address = "London"}
        );
    }
}

builder.Services.AddDbContext<ApplicationDbContext>(option =>
    option.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

Create the Database

Note:: If you receive an error regarding 'Only the invariant culture is supported in globalization-invariant mode', you can resolve this by editing the csprog file, by selecting the file, right-clicking and selecting the edit menu, then selecting Edit 'Filename.csprog' (Or on Mac you can just select the project file and press command + down).
Then set the value of the following line to false -
<InvariantGlobalization>false</InvariantGlobalization>

Create a Repository

public interface IToDoRepository
{

}

public interface IToDoRepository
{
    Task<IResult> GetAllAsync();
    Task CreateAsync(ToDo toDo);
    Task UpdateAsync(ToDo toDo);
    Task RemoveAsync(ToDo toDo);
    Task SaveAsync();
}

public class ToDoRepository : IToDoRepository
{

}

public class AddressBookRepository : IAddressBookRepository
{
    private readonly ApplicationDbContext _db;

    public ToDoRepository(ApplicationDbContext db)
    {
        _db = db;
    }
}

public class ToDoRepository : IToDoRepository
{
    private readonly ApplicationDbContext _db;

    public ToDoRepository(ApplicationDbContext db)
    {
        _db = db;
    }

    public async Task<IResult> GetAllAsync()
    {
        throw new NotImplementedException();
    }

    public Task CreateAsync(ToDo toDo)
    {
        throw new NotImplementedException();
    }

    public Task UpdateAsync(ToDo toDo)
    {
        throw new NotImplementedException();
    }

    public Task RemoveAsync(ToDo toDo)
    {
        throw new NotImplementedException();
    }

    public Task SaveAsync()
    {
        throw new NotImplementedException();
    }
}

public async Task<IResult> GetAllAsync()
{
    var todos = await _db.ToDos.ToListAsync();
    return Results.Ok(todos);
}

builder.Services.AddScoped<IToDoRepository, ToDoRepository>();

Add Endpoints

Move Endpoints to a Separate File

public static class ToDoEndpoints
{
    public static void ConfigureToDoEndpoints(this WebApplication app)
    {
    }
}

app.ConfigureToDoEndpoints();

Add an Endpoint

public static class ToDoEndpoints
{
    public static void ConfigureToDoEndpoints(this WebApplication app)
    {
        app.MapGet("/api/todo", GetAllToDos);
    }
}

namespace MinimalAPI_test.Endpoints;

public static class AddressBookEndpoints
{
    public static void ConfigureAddressBookEndpoints(this WebApplication app)
    {
        app.MapGet("/api/addressbook", GetAllAddressBook);
    }

    private static Task GetAllAddressBook(HttpContext context)
    {
        throw new NotImplementedException();
    }
}

public static class ToDoEndpoints
{
    public static void ConfigureToDoEndpoints(this WebApplication app)
    {
        app.MapGet("/api/todo", GetAllToDos);
    }

    private static Task<IResult> GetAllToDos(IToDoRepository repo)
    {
        return await repo.GetAllAsync();
    }
}

Add an HTTP Response Code

private static async Task<IResult> GetAllAddressBook(IAddressBookRepository _repo)
{
    return Results.Ok(await _repo.GetAllAsync());
}

Minimal API - .NET & EF Core﻿

Create a Clean Project﻿

Modal, DAL & Database - Entity Framework﻿

Install Necessary Libraries﻿

Add a Model﻿

Add Connection String﻿

Add Data Access Layer﻿

Create the Database﻿

Create a Repository﻿

Add Endpoints﻿

Move Endpoints to a Separate File﻿

Add an Endpoint﻿