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); } }