public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
    if (env.IsDevelopment())
    {
        app.UseDeveloperExceptionPage();
    }

    app.UseDefaultFiles();
    app.UseStaticFiles();
}

show create table table_name;

// toolset of entity framework
dotnet tool install --global dotnet-ef
dotnet tool update --global dotnet-ef

// install package
Pomelo.EntityFrameWorkCore.MySql
Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.Design

// dotnet command reference https://docs.microsoft.com/en-us/ef/core/cli/dotnet
// change to project folder that contains .csproj file, not sln file's folder， output files will be present in models folder
dotnet ef dbcontext scaffold "Server=192.168.0.129;User=root;Password=lanbe123;Database=monitor" "Pomelo.EntityFrameworkCore.MySql" -o ./models

// 在生成的文件夹里面找到 monitorContext.cs 里面有生成的工具类

// Startup.cs
 public void ConfigureServices(IServiceCollection services)
{
    // Replace with your connection string.

    services.AddDbContext<monitorContext>(
        dbContextOptions => dbContextOptions
            .UseMySql(Configuration["ConnectionStrings:ConnMySql"], new MySqlServerVersion(new Version(5, 7, 19)))
            // The following three options help with debugging, but should
            // be changed or removed for production.
            .LogTo(Console.WriteLine, LogLevel.Information)
            .EnableSensitiveDataLogging()
            .EnableDetailedErrors()
    );

    services.AddControllers();
}

//Querying with Object Services and Entity SQL
string sqlString = "SELECT VALUE st FROM SchoolDBEntities.Students " +
                    "AS st WHERE st.StudentName == 'Bill'";
    
var objctx = (ctx as IObjectContextAdapter).ObjectContext;
                
ObjectQuery<Student> student = objctx.CreateQuery<Student>(sqlString);
Student newStudent = student.First<Student>();

using (var ctx = new SchoolDBEntities())
{
    var studentName = ctx.Students.SqlQuery("Select studentid, studentname, standardId from Student where studentname='Bill'").FirstOrDefault<Student>();
}    

var us = db.user.FirstOrDefault(x => x.uid == uid);

db.user.Attach(us); 
db.user.Remove(us);

appsettings.json

  "AllowedHosts": "*",
  "Serilog": {
    "Using": [ "Serilog.Sinks.File", "Serilog.Sinks.Async" ],
    "MinimumLevel": {
      "Default": "Information"
    },
    "Override": {
      "Microsoft": "Warning",
      "System": "Warning",
      "Microsoft.AspNetCore": "Warning"
    },
    "WriteTo": [
      {
        "Name": "AsyncFile",
        "Args": {
          "configure": [
            {
              "Name": "File",
              "Args": {
                "path": "Logs/serilogDemo_.log",
                "rollingInterval": "Day"
              }
            }
          ]
        }
      }
    ],
    "Enrich": [ "FromLogContext", "WithMachineName", "WithThreadId" ],
    "Properties": {
      "Application": "KVMServerApi"
    }
  },

public class Program
    {
        public static IConfiguration Configuration { get; } = new ConfigurationBuilder()
               .SetBasePath(Directory.GetCurrentDirectory())
               .AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
               .AddJsonFile($"appsettings.{Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT") ?? "Production"}.json", optional: true)
               .AddJsonFile($"appsettings.{Environment.MachineName}.json", optional: true)
               .AddEnvironmentVariables()
               .Build();

        public static void Main(string[] args)
        {
            Log.Logger = new LoggerConfiguration()
            .ReadFrom.Configuration(Configuration)
            .CreateLogger();

            try
            {
                Log.Information("Starting up");
                CreateHostBuilder(args).Build().Run();
            }
            catch (Exception ex)
            {
                Log.Fatal(ex, "Application start-up failed");
            }
            finally
            {
                Log.CloseAndFlush();
            }

            //CreateHostBuilder(args).Build().Run();
        }

        public static IHostBuilder CreateHostBuilder(string[] args) =>
            Host.CreateDefaultBuilder(args)
                .UseSerilog()
                .ConfigureWebHostDefaults(webBuilder =>
                {
                    webBuilder.UseStartup<Startup>();
                });
    }

public class MsgController : BaseController
{
    private readonly ILogger<MsgController> _logger;

    public MsgController(IRegInfoService ri, IRedisCacheClient redisCacheClient , ILogger<MsgController> logger) : base(ri,redisCacheClient)
    {
        _logger = logger;
    }
    ...
    _logger.LogInformation("GetSystem executing...");
}

using MySql.Data.MySqlClient;

MySql.Data
MySql.Data.EntityFrameworkCore


String connetStr = "server=192.168.0.129;port=3306;user=root;password=lanbe123; database=monitor;";
MySqlConnection con = new MySqlConnection(connetStr);

con.Open();
Console.WriteLine("数据库连接成功");

MySqlCommand cmd = new MySqlCommand("select * from module", con);
IDataReader read = cmd.ExecuteReader();
while (read.Read())
{
    Console.WriteLine(read[0].ToString());
    Console.WriteLine(read[1].ToString());
    Console.WriteLine(read[2].ToString());
}
con.Close();

//默认读取配置文件：ConnectionStrings:Redis
services.AddRedisCacheManager();

//指定链接字符串
services.AddRedisCacheManager("server=127.0.0.1:6379;password=xxx;db=4");



private readonly ILogger<Worker> _logger;
private readonly IRedisCacheManager _redisCacheManager;

public Worker(ILogger<Worker> logger, IRedisCacheManager redisCacheManager)
{
    _logger = logger;
    this._redisCacheManager = redisCacheManager;

    var data = _redisCacheManager.Get<string>("test");
}

public void ConfigureServices(IServiceCollection services)
{
    services.AddSingleton<IConfiguration>(Configuration);
}

// 使用
public class ValuesController : Controller
{
    IConfiguration configuration;

    public ValuesController(IConfiguration configuration)
    {
        this.configuration = configuration;
    }
}