public string GetSqlJoin(SqlJoins c) { string sql = null; if (sqlJoinsLookup.TryGetValue(c, out sql) == false) { return(string.Empty); } return(sql); }
/// <summary> /// Adds a joined table to the SQL with joining this table to the base table /// on a common field name. BaseTable.FieldA => NewTable.FieldA /// </summary> /// <param name="tableName">The new table name being added to the SQL.</param> /// <param name="joinType">Join method (LEFT, RIGHT, INNER).</param> /// <param name="joinFieldNameA">Joining field name in the new table.</param> /// <param name="joiningTableName">Existing table to be joined to.</param> /// <param name="joinFieldNameB">Joining field name in the existing table.</param> public void AddTable(string tableName, SqlJoins joinType, string joinFieldNameA, string joiningTableName, string joinFieldNameB, bool doNotBracket = false) { foreach (SqlTable table in Tables) { if (table.Name == tableName) { return; } } SqlTable newtable = new SqlTable(); newtable.Name = tableName; newtable.JoinType = GetSqlJoin(joinType); newtable.JoinFieldNameA = joinFieldNameA; newtable.JoinFieldNameB = joinFieldNameB; newtable.JoiningTable = joiningTableName; newtable.DoNotBracket = doNotBracket; Tables.Add(newtable); }
/// <summary> /// Adds a joined table to the SQL with joining this table to the base table /// on a common field name. BaseTable.FieldA => NewTable.FieldA /// </summary> /// <param name="tableName">The new table name being added to the SQL.</param> /// <param name="joinType">Join method (LEFT, RIGHT, INNER).</param> /// <param name="joinFieldName">Joining field name in both tables.</param> public void AddTable(string tableName, SqlJoins joinType, string joinFieldName, bool doNotBracket = false) { AddTable(tableName, joinType, joinFieldName, BaseTable, joinFieldName, doNotBracket); }