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