/// <summary>
/// Binds the select query option to the SqlBuilder.
/// </summary>
/// <param name="selectQueryOption">The select query option.</param>
/// <param name="objectInfo">The IObjectInfo for the type to bind the select list for.</param>
/// <returns>The SqlBuilder after the select and from clauses have been added.</returns>
public static IWhereOrOrderBy BindSelect(SelectQueryOption selectQueryOption, IObjectInfo objectInfo)
{
if (objectInfo == null)
{
throw new ArgumentNullException("objectInfo");
}
if (selectQueryOption == null || (selectQueryOption.Properties.Count == 1 && selectQueryOption.Properties[0] == "*"))
{
return SqlBuilder.Select("*").From(objectInfo.ForType);
}
var columnNames = new string[selectQueryOption.Properties.Count];
int columnCount = 0;
for (int i = 0; i < selectQueryOption.Properties.Count; i++)
{
var property = selectQueryOption.Properties[i];
var column = objectInfo.TableInfo.GetColumnInfoForProperty(property);
if (column == null)
{
throw new ODataException(string.Format(CultureInfo.InvariantCulture, Messages.InvalidPropertyName, objectInfo.ForType.Name, property));
}
columnNames[columnCount++] = column.ColumnName;
}
return SqlBuilder.Select(columnNames).From(objectInfo.ForType);
}
public WhenConstructedWithAValidValue()
{
this.rawValue = "$select=Name,Age,Joined";
this.option = new SelectQueryOption(this.rawValue);
}