Table of Contents

Class SqlValueProviders

Namespace
Tripous.Data
Assembly
Tripous.Data.dll

Provides values to Sql statements by replacing placeholders, such as AppData and AppUserName, with actual values.

Provides values to DataRows when they have DataColumns named such as AppData and AppUserName.

public static class SqlValueProviders
Inheritance
SqlValueProviders
Inherited Members

Methods

Add(ISqlValueProvider)

Registers a provider

public static void Add(ISqlValueProvider Store)

Parameters

Store ISqlValueProvider

Process(DataRow, DataColumn, string, SqlStore)

Set the value to a Column of a Row of a Table, based on a Keyword which may have values such as AppData or AppUserName.

public static void Process(DataRow Row, DataColumn Column, string Keyword, SqlStore Store = null)

Parameters

Row DataRow
Column DataColumn
Keyword string
Store SqlStore

Process(DataRow, SqlStore)

Sets values to Row for columns with names such as AppData or AppUserName.

public static void Process(DataRow Row, SqlStore Store = null)

Parameters

Row DataRow
Store SqlStore

Process(DataTable, SqlStore)

Sets values to all rows of the Table, for columns with names such as AppData or AppUserName.

public static void Process(DataTable Table, SqlStore Store = null)

Parameters

Table DataTable
Store SqlStore

Process(ref string, SqlStore)

Replaces certain placeholders in SqlText with actual values.

public static void Process(ref string SqlText, SqlStore Store = null)

Parameters

SqlText string
Store SqlStore

Remove(ISqlValueProvider)

Unregisters a provider

public static void Remove(ISqlValueProvider Store)

Parameters

Store ISqlValueProvider