Interface ISQLWrapperProcessor

A processor used for loading and processing ISQLWrapper and ISQLWrapper records as a set from the UI across multiple views in a consistent manner

Also integrated into save routine so the system ensures the custom sql specified by the wrapper is created on the database for it to call. Any failures will prevent the whole save from succeeding

See https://web.lemonedge.com/help/sql-wrappers/ for more information

Inherited Members

IBaseDataSetProcessorWithDBSave.SaveProcessed

IBaseDataSetProcessorWithDBSave.ProcessOnDBSave()

IBaseDataSetProcessorWithDBSave.RollbackChanges()

IBaseDataSetProcessorWithDBSave.Order

IBaseDataSetProcessor.IgnoreEvents

IBaseDataSetProcessor.IsChangedItemPartOfDataSet(IBaseEntity)

IBaseDataSetProcessor.AddToDataSetToProcess(IBaseEntity, EntityOperation)

IBaseDataSetProcessor.Loaded

IBaseDataSetProcessor.Load()

IProcessor.Updater

IProcessor.Cache

IProcessor.User

IProcessor.Reporter

System.IDisposable.Dispose()

Namespace: LemonEdge.API.Processors

Assembly: API.dll

Syntax

public interface ISQLWrapperProcessor : IBaseDataSetProcessorWithDBSave, IBaseDataSetProcessor, IProcessor, IDisposable

Properties

Wrapper

The sql wrapper handled by this processor

Declaration

ISQLWrapper Wrapper { get; }

Property Value

Type	Description
ISQLWrapper

Methods

ForceRewrite()

Ensures this sql wrapper is marked as changed in order to force the processor to re-write the custom sql (or re-generate in the case of it being part of a IDataset) to the database

Declaration

void ForceRewrite()

GetWrapperTypes(SQLTypeWrapperType)

Returns a list of all the sql wrapper types for the specified type. Either a column or parameter.

Declaration

IEnumerable<ISQLTypeWrapper> GetWrapperTypes(SQLTypeWrapperType type)

Parameters

Type	Name	Description
SQLTypeWrapperType	type	The type of sql wrapper types to return, either a column or parameter.

Returns

Type	Description
System.Collections.Generic.IEnumerable<ISQLTypeWrapper>	A list of all the sql wrapper types for the specified type. Either a column or parameter.

OnAddWrapperType(ISQLTypeWrapper)

Adds the specified new sql wrapper type (either column or parameter) to this sql wrapper

Declaration

void OnAddWrapperType(ISQLTypeWrapper item)

Parameters

Type	Name	Description
ISQLTypeWrapper	item	The new sql wrapper type to add to this processor

OnDeleteWrapperType(ISQLTypeWrapper)

Removes the specified sql wrapper type (either column or parameter) from this sql wrapper

Declaration

void OnDeleteWrapperType(ISQLTypeWrapper item)

Parameters

Type	Name	Description
ISQLTypeWrapper	item	The new sql wrapper type to remove from this processor

Extension Methods

MiscExtensions.SetIfNotEqual<T, P>(T, Expression<Func<T, P>>, P)

ReflectionExtensions.ClearEventInvocations(Object, String)

StringExtensions.ToCSVFormatString(Object, Type)

SQLExtensions.ToSQLValue(Object, Boolean)

See Also

ISQLWrapper