目录

csharp代码配置

kentxxq 收录于类别 blog

2023-08-15 2024-02-05 约 390 字预计阅读 1 分钟

目录

简介

记录 csharp 的代码配置仅在开发过程中会用到。

配置

数据库连接字符串

Mysql

1
Server=ip或域名;Database=数据库;Uid=root;Pwd=密码;MinimumPoolSize=10;maximumpoolsize=50;

SqlServer

sql server 连接配置

1
2
3
4
5
{
    "ConnectionStrings": {
        "BloggingDatabase": "Data Source=your_server_ip;Database=your_database_name;User ID=your_username;Min Pool Size=10;Password=your_password;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"
  }
}

代码使用

1
2
3
4
5
services.AddDbContextPool<BloggingContext>(
    options =>{
options.UseSqlServer(Configuration.GetConnectionString("BloggingDatabase")); }
    ,poolSize:64
);

命令

生成 user-jwts

1
dotnet user-jwts create  --role admin --role superadmin --audience ken(一般是url地址)  --claim is_allow=true(自定义claim)

生成 model

EFCore

1
2
3
4
5
6
7
8
# Sqlite
dotnet ef dbcontext  scaffold "Data Source=test. Db" -o Models Microsoft. EntityFrameworkCore. Sqlite -c "TestDbContext" -f
# Mysql
dotnet ef dbcontext scaffold "server=localhost; port=3306; user=root; password=mypass; database=sakila" MySql. Data. EntityFrameworkCore -o sakila -f
# 或者
Scaffold-DbContext "server=localhost; port=3306; user=root; password=mypass; database=sakila" MySql. Data. EntityFrameworkCore -OutputDir Models -f
# Oracle 
Scaffold-DbContext "Data Source=(DESCRIPTION =(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST = 192.168.0.220)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl))); User ID=kentxxq; Password=mypass;" Oracle. EntityFrameworkCore -OutputDir Models

Freesql

1
FreeSql.Generator -Razor 1 -NameOptions 0,0,0,0 -NameSpace WebApplication1 -DB "MySql,data source=ip或地址;port=3306;user id=用户名;password=密码;initial catalog=库名;charset=utf8;sslmode=none;max pool size=2"