ModelSqlBuilder Class

.NET Standard 2.x

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Provides a series of methods and properties for getting the ISqlBuilder object or SQL statement according to the definition in a model class.

Syntax

public class ModelSqlBuilder

Property

Name	Return Type	Description
DeleteBuilder	ISqlDeleteBuilder	Gets a newly created ISqlDeleteBuilder object based on the definition in the model class.
DeleteSql	String	Gets a SQL DELETE statement based on the definition in the model class and the data context.
QueryBuilder	string	Gets a newly created ISqlQueryBuilder object based on the definition in the model class.
QuerySql	ISqlQueryBuilder	Gets a SQL SELECT statement based on the definition in the model class and the data context.

Method

Name	Return Type	Description
GetBuilder<TModel>(DataContext context))	ModelSqlBuilder	Creates a ModelSqlBuilder object with the specified model class and data context.
GetQueryBuilder(string selectName)	ISqlQueryBuilder	Gets a newly created ISqlQueryBuilder object based on the definition in the model class and the specified select list.
GetQuerySql(string selectName)	string	Gets the SQL SELECT statement based on the definition in the model class, the specified select list, and the data context.