Class SqlDataProvider

Namespace

Dynamicweb.Data.DataProviders

Assembly

Dynamicweb.Core.dll

Provides data from a sql database

public sealed class SqlDataProvider : SqlDataProviderBase, IParameterOptions

Inheritance

object

ConfigurableAddIn

DataProvider

SqlDataProviderBase

SqlDataProvider

Implements

IParameterOptions

Inherited Members

SqlDataProviderBase.ConvertToDataItem(IDictionary<string, object>)

SqlDataProviderBase.ConvertToDataItem(IDictionary<string, object>, params string[])

SqlDataProviderBase.GetData(CommandBuilder)

SqlDataProviderBase.GetData<T>(string, IEnumerable<string>, string, T)

SqlDataProviderBase.GetKeyValueData<T>(string, string, string, string, T)

ConfigurableAddIn.UpdateFromPost(NameValueCollection)

ConfigurableAddIn.GetIdSuitableString(string)

ConfigurableAddIn.LoadParametersFromXml(string)

ConfigurableAddIn.GetParametersToXml()

ConfigurableAddIn.GetParametersToXml(bool)

ConfigurableAddIn.SetValue(string, object)

ConfigurableAddIn.GetInstanceFromParameterXml<T>(string)

ConfigurableAddIn.RenderAdditionalContent(TextWriter)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

TableColumnNames

Gets or sets the table column names.

[AddInParameter("TableColumnNames")]
[AddInParameterEditor(typeof(DropDownParameterEditor), "multiple=true;")]
public string TableColumnNames { get; set; }

Property Value

string

The table column names.

TableName

Gets or sets the name of the table.

[AddInParameter("TableName")]
[AddInParameterEditor(typeof(DropDownParameterEditor), "refreshParameters=true;SortBy=Value;")]
public string TableName { get; set; }

Property Value

string

The name of the table.

TableUserIdColumnName

Gets or sets the name of the table user identifier column.

[AddInParameter("TableUserIdColumnName")]
[AddInParameterEditor(typeof(DropDownParameterEditor), "SortBy=Value;")]
public string TableUserIdColumnName { get; set; }

Property Value

string

The name of the table user identifier column.

Methods

GetDataByUser(User)

Gets data related to a given user.

public override IEnumerable<DataItem> GetDataByUser(User user)

Parameters

user User

The user to retrieve data for.

Returns

IEnumerable<DataItem>

A collection of data items found for the given user.

See Also

DataProvider

IParameterOptions