EF EntityFrameworkCore 各版本连接数据库字符串

KingCruel

已于 2025-01-13 14:37:08 修改

阅读量494

点赞数 3

CC 4.0 BY-SA版权

分类专栏： .NET Core 文章标签：数据库

于 2024-12-21 22:28:32 首次发布

本文链接：https://blog.csdn.net/KingCruel/article/details/144637087

数据库类型
public enum DataType
{
MySql = 0,
SqlServer = 1,
PostgreSQL = 2,
Oracle = 3,
Sqlite = 4,
OdbcOracle = 5,
OdbcSqlServer = 6,
OdbcMySql = 7,
OdbcPostgreSQL = 8,
Odbc = 9,
MsAccess = 11,
Dameng = 12,
ShenTong = 14,
KingbaseES = 15,
Firebird = 16,
Custom = 17,
ClickHouse = 18,
GBase = 19,
QuestDb = 20,
Xugu = 21,
CustomOracle = 22,
CustomSqlServer = 23,
CustomMySql = 24,
CustomPostgreSQL = 25,
DuckDB = 26,
TDengine = 27
}
连接数据库字符串 ConnectionStrings

DataType.MySql	Data Source=127.0.0.1;Port=3306;User ID=root;Password=root; Initial Catalog=cccddd;Charset=utf8; SslMode=none;Min pool size=1
DataType.PostgreSQL	Host=192.168.164.10;Port=5432;Username=postgres;Password=123456; Database=tedb;ArrayNullabilityMode=Always;Pooling=true;Minimum Pool Size=1
DataType.SqlServer	Data Source=.;User Id=sa;Password=123456;Initial Catalog=freesqlTest;Encrypt=True;TrustServerCertificate=True;Pooling=true;Min Pool Size=1
DataType.Oracle	user id=user1;password=123456; data source=//127.0.0.1:1521/XE;Pooling=true;Min Pool Size=1
DataType.Sqlite	Data Source=\|DataDir