private async Task <bool> CheckTableExists(ExecutionContext executionContext, Guid providerDefinitionId, string name)
{
try
{
var config = await base.GetAuthenticationDetails(executionContext, providerDefinitionId);
var tables = await _client.GetTables(config.Authentication, name);
return(tables.Rows.Count > 0);
}
catch (Exception e)
{
var message = $"Error checking Container '{name}' exists for Connector {providerDefinitionId}";
_logger.LogError(e, message);
//throw new ConnectionException(message);
return(await Task.FromResult(false));
}
}
public override async Task <IEnumerable <IConnectorContainer> > GetContainers(ExecutionContext executionContext, Guid providerDefinitionId)
{
try
{
var config = await base.GetAuthenticationDetails(executionContext, providerDefinitionId);
var tables = await _client.GetTables(config.Authentication);
var result = from DataRow row in tables.Rows
select row["TABLE_NAME"] as string into tableName
select new SqlServerConnectorContainer {
Id = tableName, Name = tableName
};
return(result.ToList());
}
catch (Exception e)
{
var message = $"Could not get Containers for Connector {providerDefinitionId}";
_logger.LogError(e, message);
throw new GetContainersException(message);
}
}