ISqlBuilder Interface

.NET Standard 2.x

Represents an object which can be used to build SQL.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Inherited Constructors

SnapObjects.Data.ISqlBuilderBase

Syntax

  public interface ISqlBuilder : ISqlBuilderBase, ICloneable<ISqlBuilder>;

Properties

Name	Return Type	Description
Name	string	Gets the name of the current object.
SqlType	SqlStatementType	Gets the SQL statement type of the current object.
UsedParameters	IReadOnlyDictionary<string, ISqlParameter>	Gets an IReadOnlyDictionary<string, ISqlParameter> object that contains all parameters used in the current object.

Methods

Name	Returns Type	Description
AddParameters(params ISqlParameter[] parameters)	bool	Adds the parameters which will be used in the SQL statement to the current object.
Clone	TModel	Makes a copy of the current ISqlBuilder object.
GetParameterPlacehold(string name)	string	Gets the placeholder string for a SQL parameter.
Reset()	ISqlBuilder	Clears the SQL statement and all of the SQL parameters defined in the current object.
ToReadOnly()	ISqlReadOnlyBuilder	Gets a read-only ISqlReadOnlyBuilder object generated by the clone of the current object.
ToSqlString(DataContext context)	string	Returns the raw SQL string for the corresponding database by the current object.
Validate(DataContext context, bool throwError = true)	bool	Validates the raw SQL string for the specified database generated by the current sqlbuilder.