protected LiteQuery GetRefSubQuery(string refTableName, string refKeyName, string refDisplayName, string foreignTableAlias, string foreignName) { string tableAlias = string.Empty; LiteQuery query = LiteQuery.New(refTableName, tableAlias); query.AddField(tableAlias, refDisplayName); query.Filter = FilterField.New(tableAlias, refKeyName).Equal(foreignTableAlias, foreignName); return(query); }
public LiteQuery GetMMSubQuery(string innnerTableName, string leftFieldName, string rightFieldName, object rightValue) { string tableAlias = string.Empty; LiteQuery query = LiteQuery.New(innnerTableName, tableAlias); query.AddField(tableAlias, leftFieldName); query.Filter = FilterField.New(tableAlias, rightFieldName).Equal(rightValue); return(query); }