diff options
| author | mo khan <mo@mokhan.ca> | 2007-08-26 20:10:42 -0600 |
|---|---|---|
| committer | mo khan <mo@mokhan.ca> | 2007-08-26 20:10:42 -0600 |
| commit | 330be9feefb6394479553be0e078b4c4df3cbff1 (patch) | |
| tree | 55618c8af0d36583cde0ea5b4b193b98815a35aa /src/app/Cmpp298.Assignment3.DataAccess/InnerJoin.cs | |
import from svntrunk
Diffstat (limited to 'src/app/Cmpp298.Assignment3.DataAccess/InnerJoin.cs')
| -rw-r--r-- | src/app/Cmpp298.Assignment3.DataAccess/InnerJoin.cs | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/src/app/Cmpp298.Assignment3.DataAccess/InnerJoin.cs b/src/app/Cmpp298.Assignment3.DataAccess/InnerJoin.cs new file mode 100644 index 0000000..bff9fcc --- /dev/null +++ b/src/app/Cmpp298.Assignment3.DataAccess/InnerJoin.cs @@ -0,0 +1,23 @@ +namespace Cmpp298.Assignment3.DataAccess {
+ public class InnerJoin {
+ public InnerJoin( string leftTableName, string leftColumnName, string rightTableName, string rightColumnName )
+ : this( new DatabaseColumn( leftTableName, leftColumnName ), new DatabaseColumn( rightTableName, rightColumnName ) ) {}
+
+ public InnerJoin( DatabaseColumn leftColumn, DatabaseColumn rightColumn ) {
+ _leftColumn = leftColumn;
+ _rightColumn = rightColumn;
+ }
+
+ public override string ToString( ) {
+ return
+ string.Format( "INNER JOIN [{0}] ON [{0}].[{1}] = [{2}].[{3}]",
+ _leftColumn.TableName,
+ _leftColumn.ColumnName,
+ _rightColumn.TableName,
+ _rightColumn.ColumnName );
+ }
+
+ private readonly DatabaseColumn _leftColumn;
+ private readonly DatabaseColumn _rightColumn;
+ }
+}
\ No newline at end of file |