ASP.NET CORE API with Entity Framework

Table of Content

Introduction

The ASP.NET Core is a free open-source and cross-platform framework for creating cloud-based applications, such as web applications, IoT applications and mobile backends. ASP.NET Core MVC is a middleware that provides a framework for creating APIs and web applications using MVC.

HTTP is not just for serving web pages. It is also a powerful platform for creating APIs that reveal services and data. HTTP is simple, flexible and ubiquitous. Most of the platform you can think of has an HTTP library, so HTTP services can reach a wide range of customers, including browsers, mobile devices and traditional desktop applications.

ASP .NET Core has built-in support for MVC Building Web API. Integrating the two frameworks makes it easier to create applications that include both UI (HTML) and API, as they now share the same code base and pipeline.

Overview

Here is the API you created:

The following figure shows the basic design of the application.

The client is whatever consumes the web API (browser, mobile application and so on). We are not writing clients in this tutorial.

The model is an object that represents data in your application. In this case, the only model has to do item. Model are represented as Simple C # Class (POCO).

A controller is an object that handles HTTP requests and generates HTTP responses. This application will have a single controller.

Tooling

1. Visual Studio 2017
2. Postman

Create an ASP.NET core application

Open Visual Studio, select File -> New -> Project, ASP.NET Core Web Application Template and click OK.

Select an API template as shown in the figure below.

Then click OK, it will create a new ASP .NET core project with some predefined configuration files and controller.

The program.cs class which contains the main method with a method called CreatWebhostBuilder () is responsible for running and configuring the application. The host for the application is set with the Startup type as a Startup class.

The Startup.cs class includes two important methods,

ConfigureServices() - Used to create dependency injection containers and add services to configure those services.

Configure () - Used to configure how the ASP.NET core application responds to an individual HTTP request.

Configure the Entity Framework Core

Create a folder called Entities to organize entity model classes. Let's create an entity model class.

Author.cs

namespace API_Demo.Entities
{
    [Table("Author",Schema ="dbo")]
    public class Author
    {
        [Key]
        
        public Guid AuthorId { get; set; }

        [Required]
        [MaxLength(50)]
        public string FirstName { get; set; }
        [Required]
        [MaxLength(50)]
        public string LastName { get; set; }

        [Required]
        [MaxLength(50)]
        public string Genre { get; set; }

        public ICollection Books { get; set; } = new List();
    }
}

namespace API_Demo.Entities
{
    [Table("Book", Schema = "dbo")]
    public class Book
    {
        [Key]
        
        public  Guid BookId { get; set; }
        [Required]
        [MaxLength(150)]
        public string Title { get; set; }
        [MaxLength(200)]
        public string Description { get; set; }

        [ForeignKey("AuthorId")]
        public Author Author { get; set; }

        public Guid AuthorId { get; set; }

    }
}

namespace API_Demo.Entities
{
    public class LibraryContext:DbContext
    {
        public LibraryContext(DbContextOptions options):base(options)
        {
            Database.Migrate();
        }
        public DbSet Authors { get; set; }
        public DbSet Books { get; set; }
    }
}

namespace API_Demo{
    public class Startup
    {
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        public IConfiguration Configuration { get; }

      .
        public void ConfigureServices(IServiceCollection services)
        {
            services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);
            services.AddDbContext(op => op.UseSqlServer(Configuration["ConnectionString:BookStoreDB"]));
            services.AddScoped, LibraryRepository>();
 }

namespace API_Demo.Entities
{
    public class LibraryContext:DbContext
    {
        public LibraryContext(DbContextOptions options):base(options)
        {
            Database.Migrate();
        }
        public DbSet Authors { get; set; }
        public DbSet Books { get; set; }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity().HasData(new Author
            {
             
                AuthorId= Guid.NewGuid(),
                FirstName = "nik",
                LastName = "rathod",
                Genre = "Drama"

            }, new Author
            {
                AuthorId=Guid.NewGuid(),
                FirstName = "vivek",
                LastName = "rathod",
                Genre = "Fantasy"
            });
        }
     }
}

namespace API_Demo.Repository.Contract
{
    public interface ILibraryRepository
    {
        IEnumerable GetAllAuthor();
     }
}

namespace API_Demo.Repository.Implementation
{
    public class LibraryRepository: ILibraryRepository
    {
        readonly LibraryContext _libraryContext;

        public LibraryRepository(LibraryContext context)
        {
            _libraryContext = context;
        }

        public IEnumerable GetAllAuthor()
        {
            return _libraryContext.Authors.ToList();
        }
   }
}

services.AddScoped, LibraryRepository>();

namespace API_Demo.Controllers
{
    [Route("api/Libraries")]
    [ApiController]
    public class LibrariesController : ControllerBase
    {
        private readonly ILibraryRepository _libraryRepository;
       

     
        public LibrariesController(ILibraryRepository libraryRepository)
        {
            _libraryRepository = libraryRepository;
        }

        // GET: api/Libraries/GetAllAuthor
        [HttpGet]
        [Route("GetAllAuthor")]
        public IActionResult GetAllAuthor()
        {
            IEnumerable authors = _libraryRepository.GetAllAuthor();
            return Ok(authors);
        }
    }
}