Cheap Windows Hosting Review

How to Create a WebApi Project in .NET 9?

Posted on by Pablo Francesco

Step 1: Establish an ASP.NET Core WebApi project using the.NET 9 framework.

Step 2. Let’s define the structure by creating the following Class Library Projects.

Step 3. Set the database connection string after configuring or using an existing database.

Step 4. In the Repos and Models projects, install the NuGet package Microsoft.EntityFrameworkCore, version 9.0.4 at the time of writing this article.

Step 5. In my case, I will be using a MySQL database, which, at the time of writing, only has a preview version available, 9.0.0.

Step 6. In the Repos project, create the class DbCtx.cs:

Code

using Microsoft.EntityFrameworkCore;
namespace Repos
{
    public class DbCtx : DbContext
    {
        public DbCtx(DbContextOptions<DbCtx> options) : base(options)
        {
        }
    }
}

Step 7. In the Program.cs, initialize the database with the connection string.

Code

#region Conn config

string gamesCatalogConn = builder.Configuration.GetConnectionString("GamesCatalogConn");

builder.Services.AddDbContextFactory<DbCtx>(options =>
    options.UseMySql(gamesCatalogConn, ServerVersion.AutoDetect(gamesCatalogConn)));

#endregion

Step 8. In the Models project, create the classes DTOBase.cs and UserDTO. cs.

Code for DTOBase.cs

namespace Models
{
    public class DTOBase
    {
        public int Id { get; set; }
        public required DateTime CreatedAt { get; set; }
    }
}

Code for UserDTO.cs

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Models.DTOs
{
    [Table("User")]
    public class UserDTO : DTOBase
    {
        [MaxLength(150)]
        public required string Name { get; set; }

        [MaxLength(250)]
        public required string Email { get; set; }

        [MaxLength(350)]
        public required string Password { get; set; }
    }
}

Step 9. In the Repos project, inside DbCtx.cs, add a DbSet for UserDTO.

Code

public DbSet<UserDTO> User => Set<UserDTO>();

Step 10. Install the Microsoft package.EntityFrameworkCore.Design in both the GamesCatalogAPI and Repos projects, version 9.0.4 at the time of writing this article.

Step 11. In the Package Manager Console, select the Repos project and run the command to create the migration that will generate the users table.

Command

EntityFrameworkCore\Add-Migration
    "create User tbl"
    -Context DbCtx

After that, run the command to update the database.

EntityFrameworkCore\update-database
    -Context DbCtx

Step 12. This way, we will have our Users table created in the database.

In the next step, we will create the route for user creation.

Best ASP.NET Core 8.0.11 Hosting

The feature and reliability are the most important things when choosing a good ASP.NET Core 8.0.11 hosting. HostForLIFE is the leading provider of Windows hosting and affordable ASP.NET Core , their servers are optimized for PHP web applications such as the latest ASP.NET Core 8.0.11 version. The performance and the uptime of the ASP.NET Core  hosting service are excellent, and the features of the web hosting plan are even greater than what many hosting providers ask you to pay for. At HostForLIFEASP.NET, customers can also experience fast ASP.NET Core hosting. The company invested a lot of money to ensure the best and fastest performance of the datacenters, servers, network and other facilities. Its data centers are equipped with top equipment like cooling system, fire detection, high-speed Internet connection, and so on. That is why HostForLIFEASP.NET guarantees 99.9% uptime for ASP.NET Core . And the engineers do regular maintenance and monitoring works to assure its ASP.NET Core  hosting are security and always up.

hostforlifebanner