|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Reflection;
using System.ComponentModel;
using Harlinn.Common;
using Harlinn.DBTool.DataSources.Oracle.DB;
namespace Harlinn.DBTool.DataSources.Oracle
{
public class DBOracleTableForeignKey : DBOracleTableConstraintBase, IDBForeignKey
{
private List<DBOracleField> fields;
public DBOracleTableForeignKey()
{
}
public DBOracleTableForeignKey(DBOracleTableForeignKeys parent, ConstraintsReader reader)
: base(parent, reader)
{
}
public override DBOracleElementType ElementType
{
get
{
return DBOracleElementType.UserTableForeignKey;
}
}
[Browsable(false)]
public DBOracleTableForeignKeyColumns Columns
{
get
{
DBOracleTableForeignKeyColumns result = GetChildByName<DBOracleTableForeignKeyColumns>("Columns");
return result;
}
}
public List<DBOracleField> GetFields()
{
if (fields == null)
{
fields = new List<DBOracleField>();
DBOracleFields dbFields = Table.Fields;
DBOracleTableForeignKeyColumns columns = Columns;
foreach (DBOracleTableForeignKeyColumn column in columns.Children)
{
DBOracleField field = dbFields[column.ColumnName];
if (field != null)
{
fields.Add(field);
}
}
}
return fields;
}
public DataSources.IDBTabular Tabular
{
get
{
return Table;
}
}
public DataSources.IDBTabular References
{
get
{
DBOracleTableConstraint referencedConstraint = GetReferencedConstraint();
return referencedConstraint.Table;
}
}
IDBForeignKeyColumns IDBForeignKey.Columns
{
get
{
return Columns;
}
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
Chief Architect - Sea Surveillance AS.
Specializing in integrated operations and high performance computing solutions.
I’ve been fooling around with computers since the early eighties, I’ve even done work on CP/M and MP/M.
Wrote my first “real” program on a BBC micro model B based on a series in a magazine at that time. It was fun and I got hooked on this thing called programming ...
A few Highlights:
- High performance application server development
- Model Driven Architecture and Code generators
- Real-Time Distributed Solutions
- C, C++, C#, Java, TSQL, PL/SQL, Delphi, ActionScript, Perl, Rexx
- Microsoft SQL Server, Oracle RDBMS, IBM DB2, PostGreSQL
- AMQP, Apache qpid, RabbitMQ, Microsoft Message Queuing, IBM WebSphereMQ, Oracle TuxidoMQ
- Oracle WebLogic, IBM WebSphere
- Corba, COM, DCE, WCF
- AspenTech InfoPlus.21(IP21), OsiSoft PI
More information about what I do for a living can be found at:
harlinn.com or
LinkedIn
You can contact me at
espen@harlinn.no