ISqlQuery interface

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

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