protected override void OnSetConnectionString(ConnectionStringBuilder builder)
{
// Oracle强制关闭反向工程，禁止通过连接字符串设置
if (builder.TryGetAndRemove(_.Migration, out var value) && !value.IsNullOrEmpty())
{
//var mode = (Migration)Enum.Parse(typeof(Migration), value, true);
//DAL.WriteLog("");
}
base.OnSetConnectionString(builder);
// 修正数据源
if (builder.TryGetAndRemove("Data Source", out var str) && !str.IsNullOrEmpty())
{
if (str.Contains("://"))
{
var uri = new Uri(str);
var type = uri.Scheme.IsNullOrEmpty() ? "TCP" : uri.Scheme.ToUpper();
var port = uri.Port > 0 ? uri.Port : 1521;
var name = uri.PathAndQuery.TrimStart("/");
if (name.IsNullOrEmpty())
{
name = "ORCL";
}
str = $"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL={type})(HOST={uri.Host})(PORT={port})))(CONNECT_DATA=(SERVICE_NAME={name})))";
}
builder.TryAdd("Data Source", str);
}
}
/// <summary>设置连接字符串时允许从中取值或修改，基类用于读取拥有者Owner，子类重写时应调用基类</summary>
/// <param name="builder"></param>
protected virtual void OnSetConnectionString(ConnectionStringBuilder builder)
{
if (builder.TryGetAndRemove(nameof(Owner), out var value) && !value.IsNullOrEmpty())
{
Owner = value;
}
if (builder.TryGetAndRemove(nameof(ShowSQL), out value) && !value.IsNullOrEmpty())
{
ShowSQL = value.ToBoolean();
}
// 参数化，需要兼容写错了一年的UserParameter
if (builder.TryGetAndRemove(nameof(UseParameter), out value) && !value.IsNullOrEmpty())
{
UseParameter = value.ToBoolean();
}
if (builder.TryGetAndRemove("UserParameter", out value) && !value.IsNullOrEmpty())
{
UseParameter = value.ToBoolean();
}
if (builder.TryGetAndRemove(nameof(Migration), out value) && !value.IsNullOrEmpty())
{
Migration = (Migration)Enum.Parse(typeof(Migration), value, true);
}
if (builder.TryGetAndRemove(nameof(TablePrefix), out value) && !value.IsNullOrEmpty())
{
TablePrefix = value;
}
if (builder.TryGetAndRemove(nameof(Readonly), out value) && !value.IsNullOrEmpty())
{
Readonly = value.ToBoolean();
}
if (builder.TryGetAndRemove(nameof(DataCache), out value) && !value.IsNullOrEmpty())
{
DataCache = value.ToInt();
}
// 反向工程生成sql中表名和字段名称大小写
if (builder.TryGetAndRemove(nameof(NameFormat), out value) && !value.IsNullOrEmpty())
{
NameFormat = (NameFormats)Enum.Parse(typeof(NameFormats), value, true);
}
// 连接字符串去掉provider，可能有些数据库不支持这个属性
if (builder.TryGetAndRemove("provider", out value) && !value.IsNullOrEmpty())
{
}
// 数据库名称
var db = builder["Database"];
if (db.IsNullOrEmpty())
{
db = builder["Initial Catalog"];
}
DatabaseName = db;
}
protected override void OnSetConnectionString(ConnectionStringBuilder builder)
{
base.OnSetConnectionString(builder);
var flag = Factory.GetType().FullName.StartsWith("System.Data");
if (flag)
{
//// 正常情况下INSERT, UPDATE和DELETE语句不返回数据。 当开启count-changes，以上语句返回一行含一个整数值的数据——该语句插入，修改或删除的行数。
//if (!builder.ContainsKey("count_changes")) builder["count_changes"] = "1";
// 优化SQLite，如果原始字符串里面没有这些参数，就设置这些参数
builder.TryAdd("Pooling", "true");
//if (!builder.ContainsKey("Cache Size")) builder["Cache Size"] = "5000";
builder.TryAdd("Cache Size", (512 * 1024 * 1024 / -1024) + "");
// 加大Page Size会导致磁盘IO大大加大，性能反而有所下降
//if (!builder.ContainsKey("Page Size")) builder["Page Size"] = "32768";
// 这两个设置可以让SQLite拥有数十倍的极限性能，但同时又加大了风险，如果系统遭遇突然断电，数据库会出错，而导致系统无法自动恢复
builder.TryAdd("Synchronous", "Off");
// Journal Mode的内存设置太激进了，容易出事，关闭
//if (!builder.ContainsKey("Journal Mode")) builder["Journal Mode"] = "Memory";
// 数据库中一种高效的日志算法，对于非内存数据库而言，磁盘I/O操作是数据库效率的一大瓶颈。
// 在相同的数据量下，采用WAL日志的数据库系统在事务提交时，磁盘写操作只有传统的回滚日志的一半左右，大大提高了数据库磁盘I/O操作的效率，从而提高了数据库的性能。
builder.TryAdd("Journal Mode", "WAL");
// 绝大多数情况下，都是小型应用，发生数据损坏的几率微乎其微，而多出来的问题让人觉得很烦，所以还是采用内存设置
// 将来可以增加自动恢复数据的功能
//if (!builder.ContainsKey("Journal Mode")) builder["Journal Mode"] = "Memory";
// 自动清理数据
if (builder.TryGetAndRemove("autoVacuum", out var vac))
{
AutoVacuum = vac.ToBoolean();
}
}
else
{
SupportSchema = false;
}
// 默认超时时间
//if (!builder.ContainsKey("Default Timeout")) builder["Default Timeout"] = 5 + "";
// 繁忙超时
//var busy = Setting.Current.CommandTimeout;
//if (busy > 0)
{
// SQLite内部和.Net驱动都有Busy重试机制，多次重试仍然失败，则会出现dabase is locked。通过加大重试次数，减少高峰期出现locked的几率
// 繁忙超时时间。出现Busy时，SQLite内部会在该超时时间内多次尝试
//if (!builder.ContainsKey("BusyTimeout")) builder["BusyTimeout"] = 50 + "";
// 重试次数。SQLite.Net驱动在遇到Busy时会多次尝试，每次随机等待1~150ms
//if (!builder.ContainsKey("PrepareRetries")) builder["PrepareRetries"] = 10 + "";
}
DAL.WriteLog(builder.ToString());
}
/// <summary>设置连接字符串时允许从中取值或修改，基类用于读取拥有者Owner，子类重写时应调用基类</summary>
/// <param name="builder"></param>
protected virtual void OnSetConnectionString(ConnectionStringBuilder builder)
{
if (builder.TryGetAndRemove(nameof(Owner), out var value) && !value.IsNullOrEmpty())
{
Owner = value;
}
if (builder.TryGetAndRemove(nameof(ShowSQL), out value) && !value.IsNullOrEmpty())
{
ShowSQL = value.ToBoolean();
}
if (builder.TryGetAndRemove(nameof(UserParameter), out value) && !value.IsNullOrEmpty())
{
UserParameter = value.ToBoolean();
}
if (builder.TryGetAndRemove(nameof(Migration), out value) && !value.IsNullOrEmpty())
{
Migration = (Migration)Enum.Parse(typeof(Migration), value, true);
}
if (builder.TryGetAndRemove(nameof(TablePrefix), out value) && !value.IsNullOrEmpty())
{
TablePrefix = value;
}
}
protected override void OnSetConnectionString(ConnectionStringBuilder builder)
{
// 获取数据目录，用于反向工程创建数据库
if (builder.TryGetAndRemove("DataPath", out var str) && !str.IsNullOrEmpty())
{
DataPath = str;
}
base.OnSetConnectionString(builder);
if (builder[Application_Name] == null)
{
#if !__CORE__
var name = Runtime.IsWeb ? System.Web.Hosting.HostingEnvironment.SiteName : AppDomain.CurrentDomain.FriendlyName;
#else
var name = AppDomain.CurrentDomain.FriendlyName;
#endif
builder[Application_Name] = String.Format("XCode_{0}_{1}", name, ConnName);
}
}
/// <summary>设置连接字符串时允许从中取值或修改，基类用于读取拥有者Owner，子类重写时应调用基类</summary>
/// <param name="builder"></param>
protected virtual void OnSetConnectionString(ConnectionStringBuilder builder)
{
if (builder.TryGetAndRemove(nameof(Owner), out var value) && !value.IsNullOrEmpty())
{
Owner = value;
}
if (builder.TryGetAndRemove(nameof(ShowSQL), out value) && !value.IsNullOrEmpty())
{
ShowSQL = value.ToBoolean();
}
// 参数化，需要兼容写错了一年的UserParameter
if (builder.TryGetAndRemove(nameof(UseParameter), out value) && !value.IsNullOrEmpty())
{
UseParameter = value.ToBoolean();
}
if (builder.TryGetAndRemove("UserParameter", out value) && !value.IsNullOrEmpty())
{
UseParameter = value.ToBoolean();
}
if (builder.TryGetAndRemove(nameof(Migration), out value) && !value.IsNullOrEmpty())
{
Migration = (Migration)Enum.Parse(typeof(Migration), value, true);
}
if (builder.TryGetAndRemove(nameof(TablePrefix), out value) && !value.IsNullOrEmpty())
{
TablePrefix = value;
}
if (builder.TryGetAndRemove(nameof(Readonly), out value) && !value.IsNullOrEmpty())
{
Readonly = value.ToBoolean();
}
// 数据库名称
var db = builder["Database"];
if (db.IsNullOrEmpty())
{
db = builder["Initial Catalog"];
}
DatabaseName = db;
}
protected override void OnSetConnectionString(ConnectionStringBuilder builder)
{
base.OnSetConnectionString(builder);
// 修正数据源
if (builder.TryGetAndRemove("Data Source", out var str) && !str.IsNullOrEmpty())
{
if (str.Contains("://"))
{
var uri = new Uri(str);
var type = uri.Scheme.IsNullOrEmpty() ? "TCP" : uri.Scheme.ToUpper();
var port = uri.Port > 0 ? uri.Port : 1521;
var name = uri.PathAndQuery.TrimStart("/");
if (name.IsNullOrEmpty())
{
name = "ORCL";
}
str = $"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL={type})(HOST={uri.Host})(PORT={port})))(CONNECT_DATA=(SERVICE_NAME={name})))";
}
builder.TryAdd("Data Source", str);
}
}
