Ejemplo n.º 1
0
        public void Join(string originalTableName, string joinTableName, string leftField, string rightField)
        {
            var joinString =
                $"JOIN {Adapter.Table(joinTableName)} ON {Adapter.Field(originalTableName, leftField)} = {Adapter.Field(joinTableName, rightField)}";

            TableNames.Add(joinTableName);
            JoinExpressions.Add(joinString);
            SplitColumns.Add(rightField);
        }
        public void Join(string joinTableName, string commandText, JoinType joinType)
        {
            var join       = GetJoinExpression(joinType);
            var joinString =
                $"{join} {Adapter.Table(joinTableName)} " +
                $"ON {commandText}";

            TableNames.Add(joinTableName);
            JoinExpressions.Add(joinString);
        }
        public void Join(string originalTableName, string joinTableName, string leftField, string rightField, JoinType joinType)
        {
            var join       = GetJoinExpression(joinType);
            var joinString =
                $"{join} {Adapter.Table(joinTableName)} " +
                $"ON {Adapter.Field(originalTableName, leftField)} = {Adapter.Field(joinTableName, rightField)}";

            TableNames.Add(joinTableName);
            JoinExpressions.Add(joinString);
            SplitColumns.Add(rightField);
        }