public Locator(TableName tname)
: this(tname.GetTableSchema().PrimaryKeys)
{
}
public SqlTemplate(TableName tableName)
{
this.formalName = tableName.FormalName;
}
//used for PersistentTable
internal RowAdapter(DataFieldCollection fields, ColumnAdapterCollection columns, TableName tname, Locator locator)
: base(tname, locator)
{
this.columns = columns;
this.fields = fields;
}
public TableSchema(TableName tname)
{
this.tableName = tname;
}
public TableClause(ITableSchema schema)
{
this.schema = schema;
this.tableName = schema.TableName;
this.template = new SqlTemplate(tableName);
}
public RowAdapter(TableName tname, Locator locator, DataRow dataRow)
: base(tname, locator)
{
this.dataRow = dataRow;
//UpdateColumnValue(dataRow); //columns.Count == 0 in this moment
}
/// <summary> /// Get definition of stored procedure and function /// </summary> /// <param name="pname"></param> /// <returns></returns> public abstract string GetProcedure(TableName pname);
public abstract DataTable GetTableSchema(TableName tname);
/// <summary>
/// read records by filter
/// </summary>
/// <param name="tableName"></param>
/// <param name="where"></param>
public TableReader(TableName tableName, SqlExpr where)
: this(tableName, new SqlBuilder().SELECT().COLUMNS().FROM(tableName).WHERE(where).Clause)
{
}
public TableReader(TableName tableName, Locator locator)
: this(tableName, locator.Path.Inject())
{
}
public TableReader(TableName tableName, int top)
: this(tableName, top > 0 ? $"SELECT TOP {top} * FROM {tableName}" : $"SELECT * FROM {tableName}")
{
}
/// <summary>
/// read all records in the table defined
/// </summary>
/// <param name="tableName"></param>
public TableReader(TableName tableName)
: this(tableName, $"SELECT * FROM {tableName}")
{
}
internal TableReader(TableName tableName, string sql)
{
this.sql = sql;
this.tableName = tableName;
this.cmd = new SqlCmd(tableName.Provider, sql);
}
public string GetProcedure(TableName pname)
{
return(Provider.Schema.GetProcedure(pname));
}
private string getDataFileName(TableName tname) => string.Format("{0}\\{1}.{2}", getPath(tname.DatabaseName), tname.ShortName, EXT);
