public DataTable GetSampleData(SchemaNode tableOrView, RowLimitClause rowLimitClause, IdentifierQuoting identifierQuoting, out bool isError)
{
var result = InternalGetSampleData(tableOrView, rowLimitClause, identifierQuoting, out isError);
tableOrView.LoadColumnsFromSample(result);
return(result);
}
protected override DataTable InternalGetSampleData(SchemaNode tableOrView, RowLimitClause rowLimitClause, out bool isError)
{
try
{
var sql = GetSampleSql(rowLimitClause, (UseThreePartName ? tableOrView.ThreePartName : tableOrView.DisplayName), 200);
var adapter = new System.Data.OleDb.OleDbDataAdapter(sql, ProviderString);
adapter.SelectCommand.CommandTimeout = 30;
var result = new DataTable();
adapter.Fill(0, 200, result);
isError = false;
return(result);
}
catch (Exception ex)
{
ErrorTable.Rows[0][0] = ex.Message;
isError = true;
return(ErrorTable);
}
}
protected override DataTable InternalGetSampleData(SchemaNode tableOrView, RowLimitClause rowLimitClause, IdentifierQuoting identifierQuoting, out bool isError)
{
try
{
var sql = GetSampleSql(rowLimitClause, tableOrView.GetRef(identifierQuoting, false), 200);
var adapter = new System.Data.Odbc.OdbcDataAdapter(sql, ProviderString);
adapter.SelectCommand.CommandTimeout = 30;
var result = new DataTable();
adapter.Fill(0, 200, result);
isError = false;
return(result);
}
catch (Exception ex)
{
ErrorTable.Rows[0][0] = ex.Message;
isError = true;
return(ErrorTable);
}
}
protected override DataTable InternalGetSampleData(SchemaNode tableOrView, RowLimitClause rowLimitClause, IdentifierQuoting identifierQuoting, out bool isError)
{
try
{
var csb = new SC.SqlConnectionStringBuilder(ProviderString);
var adapter = new SC.SqlDataAdapter($"SELECT TOP 200 * FROM {tableOrView.GetRef(identifierQuoting, UseThreePartName)}" + (rowLimitClause == RowLimitClause.Top ? " WITH (NOLOCK)" : ""), csb.ConnectionString);
adapter.SelectCommand.CommandTimeout = 30;
var result = new DataTable();
adapter.Fill(0, 200, result);
isError = false;
return(result);
}
catch (Exception ex)
{
ErrorTable.Rows[0][0] = ex.Message;
isError = true;
return(ErrorTable);
}
}
protected override DataTable InternalGetSampleData(SchemaNode tableOrView, RowLimitClause rowLimitClause, out bool isError)
{
try
{
var csb = new System.Data.SqlClient.SqlConnectionStringBuilder(ProviderString);
var adapter = new System.Data.SqlClient.SqlDataAdapter($"SELECT TOP 200 * FROM {(UseThreePartName ? tableOrView.ThreePartName : tableOrView.DisplayName)} WITH (NOLOCK)", csb.ConnectionString);
adapter.SelectCommand.CommandTimeout = 30;
var result = new DataTable();
adapter.Fill(0, 200, result);
isError = false;
return(result);
}
catch (Exception ex)
{
ErrorTable.Rows[0][0] = ex.Message;
isError = true;
return(ErrorTable);
}
}
public abstract DataTable GetSchemaTable(SchemaNode tableOrView, IdentifierQuoting identifierQuoting);
protected abstract DataTable InternalGetSampleData(SchemaNode tableOrView, RowLimitClause rowLimitClause, IdentifierQuoting identifierQuoting, out bool isError);
public override DataTable GetSchemaTable(SchemaNode tableOrView, IdentifierQuoting identifierQuoting)
{
return(GetSchemaTable(tableOrView.GetSql(identifierQuoting)));
}
public override DataTable GetSchemaTable(SchemaNode tableOrView, IdentifierQuoting identifierQuoting)
{
throw new NotImplementedException();
}
protected override DataTable InternalGetSampleData(SchemaNode tableOrView, RowLimitClause rowLimitClause, IdentifierQuoting identifierQuoting, out bool isError)
{
throw new NotImplementedException();
}
public override DataTable GetSchemaTable(SchemaNode tableOrView, IdentifierQuoting identifierQuoting)
{
return(GetSchemaTable(tableOrView.GetSql(identifierQuoting, false, UseThreePartName)));
}
public abstract DataTable GetSchemaTable(SchemaNode tableOrView);
public override DataTable GetSchemaTable(SchemaNode tableOrView)
{
return(GetSchemaTable(tableOrView.GetSql()));
}
public override DataTable GetSchemaTable(SchemaNode tableOrView)
{
throw new NotImplementedException();
}
public override DataTable GetSchemaTable(SchemaNode tableOrView)
{
return(GetSchemaTable(tableOrView.GetSql(false, UseThreePartName)));
}
protected override DataTable InternalGetSampleData(SchemaNode tableOrView, RowLimitClause rowLimitClause, out bool isError)
{
throw new NotSupportedException();
}