public AnagramsRepositorySQL(IAppConfig appConfig) { _appConfig = appConfig; _connection = new SqlConnection { ConnectionString = _appConfig.GetConnectionString() }; }
public UserLogRepository(IAppConfig appConfig) { _appConfig = appConfig; _connection = new SqlConnection { ConnectionString = _appConfig.GetConnectionString() }; }
/// <summary> /// Gets the live connection string. /// </summary> /// <returns> /// Returns SQL connecting string for live site. /// </returns> /// <exception cref="System.Exception">Connection string 'live' was empty or not found in the web.config file.</exception> public string GetLiveConnectionString() { var connectionString = _appConfig.GetConnectionString("live"); if (string.IsNullOrEmpty(connectionString)) { throw new Exception("Connection string 'live' was empty or not found in the web.config file."); } return(connectionString); }
private void BulkCopyToDB(DataTable table) { using (SqlConnection sourceConnection = new SqlConnection(_appConfig.GetConnectionString())) { sourceConnection.Open(); using (SqlBulkCopy bulkCopy = new SqlBulkCopy(_appConfig.GetConnectionString())) { bulkCopy.DestinationTableName = "dbo.Words"; try { bulkCopy.WriteToServer(table); } catch (Exception ex) { Console.WriteLine(ex.Message); } } } }