C# programming Archives - Online Code Generator

If you are trying to determine the country code (“IE”) from a string like “Dublin, Ireland”, then generally the best approach is to use a Geolocation API, such as Google Geocode, or Here maps, or the plethora of others. However, if speed is more important than accuracy, or the volume of data would be too costly to run through a paid API, then here is a simple script in C# to determine the country code from a string

https://github.com/infiniteloopltd/CountryISOFromString/

The code reads from an embedded resource, which is a CSV of country names. Some of the countries are repeated to allow for variations in spelling, such as “USA” and “United States”. The list is in English only, and feel free to submit a PR, if you have more variations to add to this.

It’s called quite simply as follows;

var country = Country.FromString(“Tampere, Pirkanmaa, Finland”);
Console.WriteLine(country.code);

This post is about implementing integration testing in ASP.NET Core Minimal APIs. Usually when I talk about Minimal APIs, one of the question I used to get is how to implement integration testing and I saw some questions related to this in Stack Overflow as well. In this blog post I am trying to cover implementing ASP.NET Core integration testing with NUnit Framework. This code is can be used in XUnit as well.

First, we need to create web api project, remove controllers folder and add the following code in the program.cs – it is a simple API project with CRUD operations – I omitted Update and Delete operations. I am using Sqlite for this project as the database.

using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);
builder.Services.AddDbContext<NotesDbContext>(options => options.UseSqlite(“Data Source=notes.db”));
builder.Services.AddControllers();

builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();

var app = builder.Build();

if (app.Environment.IsDevelopment())
{
app.UseSwagger();
app.UseSwaggerUI();
}

app.MapFallback(() => Results.Redirect(“/swagger”));
app.UseHttpsRedirection();

app.MapGet(“/notes”, async (NotesDbContext notesDbContext) => await notesDbContext.Notes.ToListAsync());

app.MapGet(“/notes/{id}”, async (NotesDbContext notesDbContext, int id) =>
{
return await notesDbContext.Notes.FindAsync(id) is Note note ? Results.Ok(note) : Results.NotFound();
});

app.MapPost(“/notes”, async (NotesDbContext notesDbContext, Note note) =>
{
await notesDbContext.Notes.AddAsync(note);
await notesDbContext.SaveChangesAsync();
return Results.Created($”/notes/{note.Id}“, note);
});

app.Run();

public class Note
{
public int Id { get; set; }
public string? Title { get; set; }
public string? Content { get; set; }
public DateTime CreatedOn { get; set; }
}

public class NotesDbContext : DbContext
{
public NotesDbContext(DbContextOptions options)
: base(options)
{
}

public DbSet<Note>? Notes { get; set; }
}

To get started we need to modify the API project file with the InternalsVisibleTo attribute, like this with your test project name.

Next we need to create NUnit project we can use the command dotnet new nunit -o Notes.Api.Tests. In this project, we need to first add the reference of web api project, we can use the dotnet add reference command for this.

For integration testing we need to create instance of WebApplicationFactory class – so we need to install the nuget package Microsoft.AspNetCore.Mvc.Testing. And for mocking the database context we need the Microsoft.EntityFrameworkCore.InMemory nuget package as well. Here is my updated project file.

<PropertyGroup>
<TargetFramework>net6.0</TargetFramework>
<Nullable>enable</Nullable>

<IsPackable>false</IsPackable>
</PropertyGroup>

</Project>

Now we can implement the WebApplicationFactory class like this.

class NotesApiApplication : WebApplicationFactory<Program>
{
protected override IHost CreateHost(IHostBuilder builder)
{
var root = new InMemoryDatabaseRoot();

builder.ConfigureServices(services =>
{
services.RemoveAll(typeof(DbContextOptions<NotesDbContext>));
services.AddDbContext<NotesDbContext>(options =>
options.UseInMemoryDatabase(“Testing”, root));
});

return base.CreateHost(builder);
}
}

In the code, I am removing the existing DbContext and using EFCore In Memory database. And you can write a test like this.

await using var application = new NotesApiApplication();

var client = application.CreateClient();
var notes = await client.GetFromJsonAsync<List<Note>>(“/notes”);

Assert.IsNotNull(notes);
Assert.IsTrue(notes.Count == 0);

In this example, I am checking the Notes which will return zero notes because the in memory database is empty. To use the data, you need to access the database context and can insert data like this.

await using var application = new NotesApiApplication();
using (var scope = application.Services.CreateScope())
{
var provider = scope.ServiceProvider;
using (var notesDbContext = provider.GetRequiredService<NotesDbContext>())
{
await notesDbContext.Database.EnsureCreatedAsync();

await notesDbContext.Notes.AddAsync(new Note { Title = “First Note”, Content = “First Note Content” });
await notesDbContext.Notes.AddAsync(new Note { Title = “Second Note”, Content = “Second Note Content” });
await notesDbContext.SaveChangesAsync();
}
}

var client = application.CreateClient();
var notes = await client.GetFromJsonAsync<List<Note>>(“/notes”);

Assert.IsNotNull(notes);
Assert.IsTrue(notes.Count == 2);

And we can write test case for creating note like this.

await using var application = new NotesApiApplication();
var note = new Note { Title = “First Note”, Content = “First Note Content” };
var client = application.CreateClient();
var response = await client.PostAsJsonAsync<Note>(“/notes”, note);
var result = await response.Content.ReadFromJsonAsync<Note>();
Assert.IsTrue(response.IsSuccessStatusCode);
Assert.IsNotNull(result);

Here is the screen shot when I am running the dotnet test command.

The tests show how you can write integration tests for the Minimal API. You can implement the same code for Razor apps as well. Here are few resources to learn more about Minimal APIs.

Tutorial: Create a minimal web API with ASP.NET Core
Minimal APIs overview
Minimal API testing

Happy Programming 🙂

Tag: C# programming

Determine the country code from country name in C#

Integration Testing ASP.NET Core 6 Minimal APIs