Class SqlStatementProcessor

Sql statement processor

Inheritance
System.Object
SqlStatementProcessor
Namespace: Simplic.Framework.DBUI
Assembly: Simplic.Framework.DBUI.dll
Syntax
public class SqlStatementProcessor : object

Constructors

| Improve this Doc View Source

SqlStatementProcessor()

Initialize new processor

Declaration
public SqlStatementProcessor()

Methods

| Improve this Doc View Source

GetTenantFilterTemplate(Int32, String)

Get the filter-template for the current user-id

Declaration
public string GetTenantFilterTemplate(int userId, string tenantColumnAlias)
Parameters
Type Name Description
System.Int32 userId
System.String tenantColumnAlias

Alias which is used for the tenant column
Returns
Type Description
System.String
| Improve this Doc View Source

Process(String, IDictionary<String, String>)

Process given sql statements

Declaration
public string Process(string sql, IDictionary<string, string> sqlPlaceholder = null)
Parameters
Type Name Description
System.String sql

Sql text
IDictionary<System.String, System.String> sqlPlaceholder

Placeholder to replace
Returns
Type Description
System.String

Prepared sql statement