private string SystemPropertiesValues(TableSystemProperty systemProperties)
{
if (systemProperties == TableSystemProperty.nil)
{
return("");
}
return(systemProperties.ToString().Replace(" ", "")); // remove spaces from string
}
public bool NoScript = false; // When a value of `true` is supplied, the execution of registered scripts is suppressed.
// NB: To suppress script execution, you must also supply the service master key with the "X-ZUMO-MASTER" header.
// For more info and security note refer to: https://msdn.microsoft.com/en-us/library/azure/jj677199.aspx
public TableQuery(string filterPredicate = "", uint top = 0, uint skip = 0, string selectColumns = null, TableSystemProperty systemProperties = TableSystemProperty.nil, bool includeDeleted = false, params OrderBy[] orderBy)
{
// supports the following subset of the query option parameters defined by the Open Data Protocol (OData)
this.Filter = filterPredicate; // return only rows that satisfy the specified filter predicate
this.OrderBy = orderBy; // sort column by one or more columns: order can be specified in 'desc' or 'asc' order ('asc' is default)
this.Select = selectColumns; // defines new projection of data by specifying the columns
this.Skip = skip; // the n of records to skip (used for paging results)
this.Top = top; // return the top n entities for any query
this.IncludeDeleted = includeDeleted; // if table has soft delete enabled then deleted records will be included in the results
this.SystemProperties = systemProperties; // list of system properties to be included in the response
}
