View Source

Class SqlContext

Implements ISqlContext.

Inheritance

System.Object

Namespace: Umbraco.Cms.Infrastructure.Persistence

Assembly: Umbraco.Infrastructure.dll

Syntax

public class SqlContext : ISqlContext

Constructors

SqlContext(ISqlSyntaxProvider, DatabaseType, IPocoDataFactory, IMapperCollection)

Initializes a new instance of the SqlContext class.

Declaration

public SqlContext(ISqlSyntaxProvider sqlSyntax, DatabaseType databaseType, IPocoDataFactory pocoDataFactory, IMapperCollection mappers = null)

Parameters

Type	Name	Description
ISqlSyntaxProvider	sqlSyntax	The sql syntax provider.
DatabaseType	databaseType	The database type.
IPocoDataFactory	pocoDataFactory	The Poco data factory.
IMapperCollection	mappers	The mappers.

Properties

DatabaseType

Gets the database type.

Declaration

public DatabaseType DatabaseType { get; }

Property Value

Type	Description
DatabaseType

Mappers

Gets the mappers.

Declaration

public IMapperCollection Mappers { get; }

Property Value

Type	Description
IMapperCollection

PocoDataFactory

Gets the Poco data factory.

Declaration

public IPocoDataFactory PocoDataFactory { get; }

Property Value

Type	Description
IPocoDataFactory

SqlSyntax

Gets the Sql syntax provider.

Declaration

public ISqlSyntaxProvider SqlSyntax { get; }

Property Value

Type	Description
ISqlSyntaxProvider

Templates

Gets the Sql templates.

Declaration

public SqlTemplates Templates { get; }

Property Value

Type	Description
SqlTemplates

Methods

Query<T>()

Creates a new query expression.

Declaration

public IQuery<T> Query<T>()

Returns

Type	Description
IQuery<T>

Type Parameters

Name	Description
T

Sql()

Creates a new Sql expression.

Declaration

public Sql<ISqlContext> Sql()

Returns

Type	Description
Sql<ISqlContext>

Sql(String, Object[])

Creates a new Sql expression.

Declaration

public Sql<ISqlContext> Sql(string sql, params object[] args)

Parameters

Type	Name	Description
System.String	sql
System.Object[]	args

Returns

Type	Description
Sql<ISqlContext>