public SqlDataServiceTargetViewModel(SqlDataServiceTarget model = null) { if (model != null) { Id = model.Id; DataSource = model.DataSource; DatabaseName = model.DatabaseName; TableName = model.TableName; Username = model.Username; } else { Id = IdGenerator.FromGuid(); } }
public SqlDataService(SqlDataServiceTarget target) { if (target.DataSource != "dkhoeinnsql01") { throw new ArgumentOutOfRangeException(nameof(target.DataSource), $"SQL data source '{target.DataSource}' is currently not supported"); } if (target.DatabaseName != "PowerBiData") { throw new ArgumentOutOfRangeException(nameof(target.DatabaseName), $"SQL database '{target.DatabaseName}' on {target.DataSource} is currently not supported"); } this.target = target; tablePath = GetTablePath(target); var sqlConnectionString = new SqlConnectionStringBuilder { DataSource = target.DataSource, InitialCatalog = target.DatabaseName, IntegratedSecurity = false, UserID = target.Username, Password = Secrets.Get($"DataService_Sql_Password_{target.Username.ToLowerInvariant()}") }.ConnectionString; sqlMigration = new SqlMigration(sqlConnectionString); keyValuePairExtractor = new KeyValuePairExtractor(); }
private static string GetTablePath(SqlDataServiceTarget target) { return($"[{target.DatabaseName}].[{target.Username}].[{target.TableName}]"); }