c#-Entiry Framework core-依赖注入

 数据库结构

参照上一篇：c#-连接mysql数据库

运行效果

代码 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.Extensions.DependencyInjection;

namespace mySql连接数据库
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("mySql连接数据库-读取数据");
            Program p = new Program();
            p.mian();
            Console.ReadLine();
        }
        private async void mian()
        {
            TbsService tbsService = new TbsService(new MySqlERPContext());
            await tbsService.AddTbs();
            tbsService.displayData();
        }
        private void initializeServices()
        {
            //const string ConnectionsString = @"Server=localhost;database=dbxjc;uid=root;pwd=6160180;SslMode=None";

        }
    }
    public partial class MySqlERPContext : DbContext//, IERPContext
    {
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseMySQL(@"Server=localhost;database=dbxjc;uid=root;pwd=6160180;SslMode=None");
            base.OnConfiguring(optionsBuilder);
        }
        public DbSet<Tb> Tbs { set; get; }
    }
    [Table("tb")]
    public class Tb
    {
        public int Id { get; set; }
        public string Name1 { get; set; }
    }
    public class TbsService
    {
        private readonly MySqlERPContext _mySqlERPContext;
        public TbsService(MySqlERPContext context) => _mySqlERPContext = context;
        public async Task AddTbs()
        {
            var tb = new Tb();
            tb.Id = 6;
            tb.Name1 = "name6";
            await _mySqlERPContext.Tbs.AddAsync(tb);
            int recoirds = await _mySqlERPContext.SaveChangesAsync();
        }
        public async void displayData()
        {
            List<Tb> tbs = await _mySqlERPContext.Tbs.ToListAsync();
            foreach (var b in tbs)
            {
                Console.WriteLine($"id:{b.Id } name:{b.Name1 }");
            }
        }
    }
}