麻雀虽小，五脏俱全。基于Asp.net core + Sqlite 5分钟快速上手一个小项目

    //歌曲信息
    public classMusic
    {
        //歌曲ID与名称
        public int Id { get; set; }
        public string Title { get; set; }

        //歌曲的流派ID与所属流派
        public int GenreId { get; set; }
        public Genre Context { get; set; }

        //歌曲的歌手ID以及歌手
        public int SingerId { get; set; }
        public Singer Owner { get; set; }
    }

    //流派信息
    public classGenre
    {
        //歌曲流派Id及流派名
        public int Id { get; set; }
        public string Name { get; set; }

        //该流派的歌曲集合
        public IEnumerable<Music> Musics { get; set; }
    }

    //歌手信息
    public classSinger
    {
        //歌手id
        public int Id { get; set; }
        //歌手名字
        public string Name { get; set; }
        //歌手生日
        public int BirthYear { get; set; }
    }

usingMicrosoft.EntityFrameworkCore;
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Threading.Tasks;

namespacetest.Models
{
    public classMyContext: DbContext
    {
        public MyContext(DbContextOptions<MyContext> options) : base(options)
        {

        }

        public DbSet<Music> Musics { get; set; }

        public DbSet<Genre> Genres { get; set; }

        public DbSet<Singer> Singers { get; set; }
    }
}

            string connecttext = "Filename=F:\core5\mymusicwakawaka\mymusicwakawaka\mymusic.DB";
            services.AddDbContext<MyContext>(options => options.UseSqlite(connecttext));