namespace: Serenity.Data assembly: Serenity.Net.Data
SqlQuery interface.
public interface ISqlQuery : IChainable, IQueryWithParams| 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 |
- interface IQueryWithParams
- interface IChainable
- Source: ISqlQuery.cs