ISqlQuery interface

namespace: Serenity.Data assembly: Serenity.Net.Services

SqlQuery interface.

public interface ISqlQuery : IChainable, IQueryWithParams

Members

name	description
Columns { get; }	Gets the columns.
CountRecords { get; }	Gets if to count records.
Distinct { get; }	Gets if distinct query.
ForJson { get; }	Gets FOR JSON part if any.
ForXml { get; }	Gets FOR XML part if any.
From { get; }	Gets access to FROM part if any.
GroupBy { get; }	Gets access to GROUP BY part if any.
Having { get; }	Gets access to HAVING part if any.
OmitParens { get; }	Where to omit params while converting to string.
OrderBy { get; }	Gets order by list.
Parent { get; }	Gets access to parent query if any.
Skip { get; }	Gets skip number.
Take { get; }	Gets take number.
UnionQuery { get; }	Gets access to internal union query if any.
UnionType { get; }	Gets access to internal union type if any.
Where { get; }	Gets access to WHERE part if any.