设置uuid

namespace EF6SQLiteTutorial.Models
{

    public class People
    {
        public int Id { get; set; }
        // 设置uuid
        public Guid Uuid { get; set; } = Guid.NewGuid();
        public string Name { get; set; } = string.Empty;
        public int age { get; set; } = 18;
        public string sex { get; set; } = "male";

    }

}

创建前检查

using EF6SQLiteTutorial.Data;
using EF6SQLiteTutorial.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;

namespace EF6SQLiteTutorial.Controllers
{

   [Route("api/[controller]")]  // https://localhost:7115/api/RpgCharacter
    [ApiController]
    public class RpgCharacterController : ControllerBase
    {
        private readonly DataContext _context;

        public RpgCharacterController(DataContext context)
        {
            _context = context;
        }

        [HttpPost]
        public async Task<ActionResult<List<RpgCharacter>>> AddCharacter(RpgCharacter character)
        {
            var existingRPG = await _context.RpgCharacters.FirstOrDefaultAsync(c => c.Name == character.Name);
            if (existingRPG != null)
            {
                // 如果存在，则返回一个错误消息
                return BadRequest("A rpg with the same name already exists.");
            }
            _context.RpgCharacters.Add(character);
            await _context.SaveChangesAsync();
        
            return Ok(await _context.RpgCharacters.ToListAsync());
        }

       
    }
}

unique约束

using Microsoft.EntityFrameworkCore;
using EF6SQLiteTutorial.Models;



namespace EF6SQLiteTutorial.Data
{
    public class DataContext : DbContext
    {
        public DataContext(DbContextOptions<DataContext> options) : base(options)
        {

        }

        public DbSet<RpgCharacter> RpgCharacters => Set<RpgCharacter>();
        public DbSet<People> Peoples => Set<People>();

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {

            // 设置RPG角色的name唯一,unique约束
            modelBuilder.Entity<RpgCharacter>()
                   .HasIndex(c => c.Name)
                   .IsUnique();
        }

    }




}