# รวมเนื้อหาที่เกี่ยวข้องกับ ASP.net Core

React

• https://github.com/mildronize/aspnet-core-react-template

• https://www.youtube.com/watch?v=5OtUm1BLmG0

  • https://github.com/jasontaylordev/CleanArchitecture

• Database

  If dotnet ef has not been installed, install it as a global tool:

  .NET CLICopy

    dotnet tool install --global dotnet-ef
  

  For more information on the CLI for EF Core, see EF Core tools reference for .Net CLI.

  Run the following .NET CLI commands:

  .NET CLICopy

  dotnet ef migrations add InitialCreate
  dotnet ef database update
  

  • ef migrations add InitialCreate: Generates an _Migrations/{timestamp}InitialCreate.cs migration file. The InitialCreate argument is the migration name. Any name can be used, but by convention, a name is selected that describes the migration. This is the first migration, so the generated class contains code to create the database schema. The database schema is based on the model specified in the MvcMovieContext class, in the Data/MvcMovieContext.cs file.
  • ef database update: Updates the database to the latest migration, which the previous command created. This command runs the Up method in the _Migrations/{time-stamp}InitialCreate.cs file, which creates the database.

  EF CLI

  dotnet add package Microsoft.EntityFrameworkCore.Design

  dotnet ef migrations add InitialCreate
  dotnet ef database update
  

  Your startup project 'AuthorizeServer' doesn't reference Microsoft.EntityFrameworkCore.Design. This package is required for the Entity Framework Core Tools to work. Ensure your startup project is correct, install the package, and try again.

  SQLite

  dotnet add package Microsoft.EntityFrameworkCore
  dotnet add package Microsoft.EntityFrameworkCore.Sqlite

  using Microsoft.EntityFrameworkCore;
  
  public void ConfigureServices(IServiceCollection services)
  {
      services.AddDbContext<ApplicationDbContext>(options =>
          options.UseSqlite(Configuration.GetConnectionString("DefaultConnection")));
  }

  Related Ref:

  Get started with ASP.NET Core MVC

  Tutorial: Create a web API with ASP.NET Core

  Tutorial: Create a Razor Pages web app with ASP.NET Core