代码拉取完成,页面将自动刷新
DbProviderFactory Factory libary for .NET Core.
Supported netstandard1.3 and netstandard2.0.
See here.
You can add to any json file,and then add this file.
Parameters format like below.
{
"DbConnectionStrings": [
{
"name": "mssql",
"connectionString": "Data Source=localhost;Initial Catalog=Master;User Id=sa;Password=1234;",
"providerName": "System.Data.SqlClient"
},
{
"name": "mysql",
"connectionString": "Data Source=localhost;Initial Catalog=user;User Id=root;Password=1234;",
"providerName": "Pomelo.Data.MySql"
},
{
"name": "sqlite",
"connectionString": "Data Source=data.db",
"providerName": "Microsoft.Data.Sqlite"
},
{
"name": "pgsql",
"connectionString": "Host=localhost;Database=postgres;Username=postgres;Password=1234;",
"providerName": "Npgsql"
}
],
"DbProviderFactories": [
{
"name": "SqlClient Data Provider",
"invariant": "System.Data.SqlClient",
"description": ".Net Framework Data Provider for SqlServer",
"type": "System.Data.SqlClient.SqlClientFactory, System.Data.SqlClient"
},
{
"name": "MySQL Data Provider by Pomelo",
"invariant": "Pomelo.Data.MySql",
"description": ".Net Framework Data Provider for MySql",
"type": "Pomelo.Data.MySql.MySqlClientFactory, Pomelo.Data.MySql"
},
{
"name": "SQLite Data Provider",
"invariant": "Microsoft.Data.Sqlite",
"description": ".Net Framework Data Provider for SQLite",
"type": "Microsoft.Data.Sqlite.SqliteFactory, Microsoft.Data.Sqlite"
},
{
"name": "Npgsql Data Provider",
"invariant": "Npgsql",
"description": ".Net Framework Data Provider for PostgreSql",
"type": "Npgsql.NpgsqlFactory, Npgsql"
}
]
}
Tips:DbConnectionStrings
section is not required,but I strongly recommend you add this.
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
// add json file
.AddJsonFile("db.provider.json");
var config = builder.Build();
// Load DbProviders and DbConnectionStrings
DbProviderManager.LoadConfiguration(config);
DbConnectionStringSetting conn = DbConnectionStringManager.ConnectionStrings["sqlite"];
DbProviderFactory factory = DbProviderFactories.GetFactory(conn.ProviderName);
DbProviderFactory
create IDbConnection
and other.Create IDbConnection
IDbConnection db = factory.CreateConnection();
Use IDbConnection
.
db.ConnectionString = conn.ConnectionString;
db.Open();
var cmd = db.CreateCommand();
cmd.CommandText = "select datetime('now');";
var dt = cmd.ExecuteScalar();
System.Console.WriteLine(dt);
db.Close();
You can see the full code in test.
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。
1. 开源生态
2. 协作、人、软件
3. 评估模型