public IEnumerable <ISQLTableColumn> GetTableData(ISQLTable SQLTable) { var Result = new List <SQLTableColumn>( ); DataTable Schema = ConnectionManager.GetSchema(SQLTable.ConnectionCredentials, EMSSQLSchemaType.TColumns, new ColumnSchemaRestrictions( ) { Table = SQLTable.Name }); foreach (String ColumnName in Schema.GetColumnNameValues("COLUMN_NAME")) { ISQLTableColumnKey ISQLTableColumnKey = new SQLTableColumnKey(ColumnName); Result.Add(new SQLTableColumn(ColumnName, SQLTable)); } foreach (String[] SQLResultRow in ExecuteSQL(SQLTable.ConnectionCredentials, $"SELECT * FROM {SQLTable.Name}")) { for (int i = 0; i < SQLResultRow.Length; i++) { Result[i].AddValue(SQLResultRow[i]); } } return(Result.AsReadOnly( )); }
public AttributeQuery(IAttributeQueryView view) { this._sqlTable = SQLTable.CallMe; this._views = new List<IAttributeQueryView>(); if (view != null) { this._views.Add(view); } }
public QueryThua(IQueryThuaView view) { _views = new List<IQueryThuaView>(); _views.Add(view); _sqlTable = SQLTable.CallMe; this._bwk = new BackgroundWorker(); this._bwk.DoWork += new DoWorkEventHandler(_bwk_DoWork); this._config = CurrentConfig.CallMe(); }
public SQLTableColumn(String Name, ISQLTableColumnKey ColumnKey, ISQLTable Table) : this(Name, Table) { if (Table == null) { throw new ArgumentOutOfRangeException("SQL Table Column ColumnKey Cannot Be Null."); } this.ColumnKey = ColumnKey; }
public SQLTableColumn(String Name, ISQLTable Table) { if (String.IsNullOrWhiteSpace(Name)) { throw new ArgumentOutOfRangeException("SQL Table Column Name Cannot Be Null Or Whitespace."); } if (Table == null) { throw new ArgumentOutOfRangeException("SQL Table Column Table Cannot Be Null."); } this.Name = Name; this.Table = Table; }
private TnRoles() { users = new DataSet(); sqlTable=SQLTable.CallMe; _lstCurUsers = new List<string>(); }
public IEnumerable <ISQLTableColumn> GetData(ISQLTable ISQLTable) { return(_ISQLServerInterop.GetTableData(ISQLTable)); }