private void createTransaction(string dataConnectProviders) { Connector _connector = new Connector(dataConnectProviders); if (String.IsNullOrEmpty(_connector.ConnectionString)) { _connector.ConnectionString = "zstoreConnectionString"; } string conString = ""; if (_connector.RegistryKeyValue.ToLower() != "config" && _connector.RegistryKeyValue.ToUpper() != "CONNECTIONVAR") { conString = RegistryAccess.getRegistryKeyValue(_connector.RegistryKeyValue, _connector.ConnectionString); } else { conString = _connector.ConnectionString; } try { if (_connector.ProviderType == "PostgreSQL") { NpgsqlConnection conn = new NpgsqlConnection(_connector.ConnectionString); conn.Open(); dbConnect = conn; Npgsql.NpgsqlTransaction _trans = conn.BeginTransaction(); _transaction = _trans; _inTrans = true; } else { DbProviderFactory dbFactory = DbProviderFactories.GetFactory(_connector.ProviderType); dbConnect = dbFactory.CreateConnection(); dbConnect.ConnectionString = conString; dbConnect.Open(); _transaction = dbConnect.BeginTransaction(); //transaction = new CommittableTransaction(); //dbConnect.EnlistTransaction(transaction); _inTrans = true; } } catch (Exception ex) { this.SentEmail(conString, ex.ToString()); } }
public DataFactory(string url, string providerType, string keyValue) { if (url.ToLower() != "config" && url.ToUpper() != "CONNECTIONVAR") { this._conString = RegistryAccess.getRegistryKeyValue(url, keyValue); } else { this._conString = keyValue; } this._providerType = providerType; }
private static string getFile(string fileName) { string _path = ""; if (System.Configuration.ConfigurationSettings.AppSettings["SQLConfigFromRegistry"] != null) { string _registryKey = System.Configuration.ConfigurationSettings.AppSettings["SQLConfigFromRegistry"]; if (_registryKey.ToUpper() != "URL") { _path = RegistryAccess.getRegistryKeyValue(_registryKey, "SqlConfigPath"); } else { _path = RegistryAccess.getRegistryKeyValue(WComm.Utilities.urlPath, "SqlConfigPath"); } _path = _path + "\\" + fileName + ".Config"; } else { if (HttpContext.Current != null) { _path = "SQL\\" + fileName + ".Config"; try { _path = HttpContext.Current.Request.PhysicalApplicationPath + _path; } catch { } } else { string assemblyFilePath = Assembly.GetExecutingAssembly().Location; string assemblyDirPath = Path.GetDirectoryName(assemblyFilePath); _path = assemblyDirPath + "\\SQL\\" + fileName + ".Config"; } } return(_path); }
public DataFactory(string url, string providerType) { this._conString = RegistryAccess.getRegistryKeyValue(url, "zstoreConnectionString"); this._providerType = providerType; }