安装
sc.exe create MyAPI binpath= 'c:\Publish\WebAPI.exe --cd="true"' start= auto

启动
net start 服务名称
如：net start MyAPI

停止
net stop 服务名称
net stop MyAPI

卸载
sc.exe delete 服务名称
如：sc.exe delete MyAPI

设置应用目录权限为777
sudo chmod 777 -R /var/appdata/MyAPI

创建服务定义文件
sudo vim /etc/systemd/system/MyAPI.service

[Unit]
Description=MyAPI

[Service]
WorkingDirectory=/var/appdata/MyAPI
ExecStart=/var/appdata/MyAPI/MyAPI
Restart=always
RestartSec=60
KillSignal=SIGINT
SyslogIdentifier=MyAPI
User=root

[Install]
WantedBy=multi-user.target

保存服务定义文件并启用本服务
sudo systemctl enable MyAPI.service

启用该服务，并确认它正在运行。

sudo systemctl start MyAPI.service
sudo systemctl status MyAPI.service

All
Microsoft.EntityFrameworkCore.Tool
Microsoft.EntityFrameworkCore.Relational

延迟加载
Microsoft.EntityFrameworkCore.Proxies
options.UseLazyLoadingProxies();

SQLServer
驱动：Microsoft.EntityFrameworkCore.SqlServer
数据库生成模型指令：Scaffold-DbContext "ConnectionString" Microsoft.EntityFrameworkCore.SqlServer -OutputDir WebCore -Force
字符串：Data Source=127.0.0.1;Initial Catalog=webcore;User ID=sa;Password=123456;Max Pool Size=100;Encrypt=True
EF 配置：optionsBuilder.UseSqlServer("ConnectionString", o => o.MigrationsHistoryTable("__efmigrationshistory"));

PostgreSQL
驱动：Npgsql.EntityFrameworkCore.PostgreSQL
数据库生成模型指令：Scaffold-DbContext "ConnectionString" Npgsql.EntityFrameworkCore.PostgreSQL -OutputDir webcore -Force
字符串：Host=127.0.0.1;Database=webcore;Username=postgres;Password=123456;Maximum Pool Size=30;SSL Mode=VerifyFull
EF 配置：optionsBuilder.UseNpgsql("ConnectionString", o => o.MigrationsHistoryTable("__efmigrationshistory"));


MySQL
Pomelo.EntityFrameworkCore.MySql
数据库生成模型指令：Scaffold-DbContext "ConnectionString" Pomelo.EntityFrameworkCore.MySql -OutputDir webcore -Force
字符串：server=127.0.0.1;database=webcore;user id=root;password=123456;maxpoolsize=100
EF 配置：optionsBuilder.UseMySql("ConnectionString", new MySqlServerVersion(new Version(8, 0, 29)), o => o.MigrationsHistoryTable("__efmigrationshistory"));

var keyInfo = ECDsa.Create(ECCurve.NamedCurves.nistP256);
var privateKey = Convert.ToBase64String(keyInfo.ExportECPrivateKey());
var publicKey = Convert.ToBase64String(keyInfo.ExportSubjectPublicKeyInfo());

insert into RegionArea SELECT CAST(CODE_PROV as int) AS ID, NAME_PROV AS province, '2021-04-01' AS createtime, '0' AS isdelete FROM ditu GROUP BY CODE_PROV, NAME_PROV;

insert into RegionCity SELECT CAST(CODE_CITY as int) as id,NAME_CITY as city,CAST(CODE_PROV as int) as provinceid, '2021-04-01' AS createtime, '0' AS isdelete FROM ditu GROUP BY CODE_CITY,NAME_CITY,CODE_PROV;

insert into RegionProvince SELECT CAST(CODE_COUN as int) as id,NAME_COUN as area,CAST(CODE_CITY as int) as cityid, '2021-04-01' AS createtime, '0' AS isdelete FROM ditu GROUP BY CODE_COUN,NAME_COUN,CODE_CITY;

insert into RegionTown SELECT CAST(CODE_TOWN as int) as id,NAME_TOWN as town,CAST(CODE_COUN as int) as areaid, '2021-04-01' AS createtime, '0' AS isdelete FROM ditu GROUP BY CODE_TOWN,NAME_TOWN,CODE_COUN;