SqlExecutor Class

.NET Standard 2.x

SqlExecutor is a set of database manipulation interfaces that have encapsulated the core components of ADO.NET. Using SqlExecutor you can directly run dynamic SQL statements, perform SqlBuilder functions, and do model queries.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Syntax

  public class SqlExecutor : ISqlExecutor;

Constructors

Name	Description
SqlExecutor(DataContext context)	Initializes a new instance of the SqlExecutor class.

Properties

Name	Return Type	Description
DataContext	DataContext	Gets the DataContext object.

Method

Name	Return Type	Description
Execute(string sqlText, params object[] parameters)	int	Executes the SQL statements like UPDATE, INSERT, DELETE etc.
ExecuteProcedure(string sqlText, params object[] parameters)	int	Executes a stored procedure.
Scalar<TValue>(string sqlText, params object[] parameters)	TValue	Executes the SQL SELECT statement and returns the first column of the first row in the result set.
Scalar<TValue>(ISqlQueryBuilder sqlQueryBuilder, params object[] parameters)	TValue	Executes the SQL SELECT statement created by an ISqlQueryBuilder object and returns the first column of the first row in the result set.
Select<TModel>(string sqlText, params object[] parameters)	IList<TModel>	Executes the SQL SELECT statement and returns an IList<TModel> object.
Select<TModel>(ISqlQueryBuilder queryBuilder, params object[] parameters)	IList<TModel>	Executes the SQL SELECT statement generated by an ISqlQueryBuilder object and returns an IList<TModel> object which contains the result set.
SelectLazy<TModel>(params object[] parameters)	IEnumerable<TModel>	Executes the SQL SELECT statement and returns an IEnumerable <TModel> object that can be used to load the result set lazily.
SelectLazy<TModel>(ISqlQueryBuilder queryBuilder, params object[] parameters)	IEnumerable<TModel>	Executes the SQL SELECT statement generated by an ISqlQueryBuilder object and returns an IEnumerable <TModel> object that can be used to load the result set lazily.
SelectOne<TModel>(string sqlText, params object[] parameters)	TModel	Executes the SQL SELECT statement and returns the first row in the result set.
SelectOne<TModel>(ISqlQueryBuilder queryBuilder, params object[] parameters)	TModel	Executes the SQL SELECT statement generated by an ISqlQueryBuilder object and returns the first row in the result set.
SelectProcedure<TModel>(string sqlText, params object[] parameters)	IList<TModel>	Executes a SQL stored procedure and returns an IList<TModel> object which contains the result set.

Remarks

SqlExecutor is a set of database manipulation interfaces that have encapsulated the core components of ADO.NET. Using SqlExecutor you can directly run dynamic SQL statements, perform SqlBuilder functions, and do model queries.
1. supports raw SQL as well as automatic SQL generation.
2. supports lazy loading of data to prevent unnecessary performance bottlenecks.
3. can bind result-sets to POCO or dynamic models.