QueryWithParams class

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

Base class for queries with params like SqlQuery, SqlUpdate, SqlInsert.

public class QueryWithParams : IQueryWithParams

Public Members

name	description
QueryWithParams()	Initializes a new instance of the `QueryWithParams` class.
DebugText { get; }	Gets the debug text.
IsDialectOverridden { get; }	Gets a value indicating whether the dialect is overridden.
ParamCount { get; }	Gets the parameter count.
Params { get; }	Gets the parameters.
AddParam(…)	Adds the parameter.
AutoParam()	Creates an automatically named parameter.
CreateSubQuery<TQuery>()	Creates a new query that shares parameter dictionary with this query.
Dialect()	Gets the dialect (SQL server type / version) for query.
SetParam(…)	Sets the parameter.

name	description
dialect	The dialect.
dialectOverridden	Is the dialect overridden.
nextAutoParam	The next auto param counter.
parameters	The parameters.
parent	The parent query with param storage.
CloneParams(…)	Clones the parameters into a target query.