public List <AuthorizationDatabaseTable> LoadViews() { if (_views != null) { return(_views); } using (var connection = _databaseConnectionProvider.CreateConnection(_connectionString)) { connection.Open(); using (var dr = new DatabaseReader(connection)) { dr.CommandTimeout = 60; _views = dr.AllViews().Select( v => new AuthorizationDatabaseTable() { SchemaOwner = v.SchemaOwner, Name = v.Name, Columns = v.Columns.Select(x => new AuthorizationDatabaseColumn() { DbDataType = x.DbDataType, IsPrimaryKey = x.IsPrimaryKey, Length = x.Length, Name = x.Name, Nullable = x.Nullable, Precision = x.Precision, Scale = x.Scale }) }).ToList(); var dataTupleTable = dr.Table("EducationOrganizationIdToEducationOrganizationId"); _views.Add(new AuthorizationDatabaseTable() { SchemaOwner = dataTupleTable.SchemaOwner, Name = dataTupleTable.Name, Columns = dataTupleTable.Columns.Select(x => new AuthorizationDatabaseColumn() { DbDataType = x.DbDataType, IsPrimaryKey = x.IsPrimaryKey, Length = x.Length, Name = x.Name, Nullable = x.Nullable, Precision = x.Precision, Scale = x.Scale }) }); } return(_views); } }
public List <DatabaseView> LoadViews() { if (_views != null) { return(_views); } using (var connection = _databaseConnectionProvider.CreateConnection(_connectionString)) { connection.Open(); using (var dr = new DatabaseReader(connection)) { dr.CommandTimeout = 60; _views = dr.AllViews().ToList(); } } return(_views); }