Class SqlServerProvider

Namespace

JJMasterData.Commons.Data.Entity.Providers

Assembly

JJMasterData.Commons.dll

public class SqlServerProvider : EntityProviderBase

Inheritance

object

EntityProviderBase

SqlServerProvider

Inherited Members

EntityProviderBase.Options

EntityProviderBase.InsertAsync(Element, Dictionary<string, object>)

EntityProviderBase.Insert(Element, Dictionary<string, object>)

EntityProviderBase.Update(Element, Dictionary<string, object>)

EntityProviderBase.UpdateAsync(Element, Dictionary<string, object>)

EntityProviderBase.SetValuesAsync(Element, Dictionary<string, object>)

EntityProviderBase.SetValues(Element, Dictionary<string, object>, bool)

EntityProviderBase.SetValuesAsync(Element, Dictionary<string, object>, bool)

EntityProviderBase.Delete(Element, Dictionary<string, object>)

EntityProviderBase.DeleteAsync(Element, Dictionary<string, object>)

EntityProviderBase.GetDictionaryListAsync(Element, EntityParameters, bool)

EntityProviderBase.CreateDataModel(Element, List<RelationshipReference>)

EntityProviderBase.CreateDataModelAsync(Element, List<RelationshipReference>)

EntityProviderBase.GetFieldsListAsTextAsync(Element, EntityParameters, bool, string)

EntityProviderBase.GetDictionaryList(Element, EntityParameters, bool)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Constructors

SqlServerProvider(SqlServerScripts, IMemoryCache, IOptionsSnapshot<MasterDataCommonsOptions>, ILoggerFactory)

public SqlServerProvider(SqlServerScripts sqlServerScripts, IMemoryCache memoryCache, IOptionsSnapshot<MasterDataCommonsOptions> options, ILoggerFactory loggerFactory)

Parameters

sqlServerScripts SqlServerScripts

memoryCache IMemoryCache

options IOptionsSnapshot<MasterDataCommonsOptions>

loggerFactory ILoggerFactory

Properties

VariablePrefix

public override string VariablePrefix { get; }

Property Value

string

Methods

GetAlterTableScript(Element, IEnumerable<ElementField>)

public override string? GetAlterTableScript(Element element, IEnumerable<ElementField> fields)

Parameters

element Element

fields IEnumerable<ElementField>

Returns

string

GetCreateTableScript(Element, List<RelationshipReference>?)

public override string GetCreateTableScript(Element element, List<RelationshipReference>? relationships = null)

Parameters

element Element

relationships List<RelationshipReference>

Returns

string

GetDeleteCommand(Element, Dictionary<string, object>)

public override DataAccessCommand GetDeleteCommand(Element element, Dictionary<string, object> filters)

Parameters

element Element

filters Dictionary<string, object>

Returns

DataAccessCommand

GetElementFromTableAsync(string, Guid?)

public override Task<Element> GetElementFromTableAsync(string tableName, Guid? connectionId = null)

Parameters

tableName string

connectionId Guid?

Returns

Task<Element>

GetInsertCommand(Element, Dictionary<string, object?>)

public override DataAccessCommand GetInsertCommand(Element element, Dictionary<string, object?> values)

Parameters

element Element

values Dictionary<string, object>

Returns

DataAccessCommand

GetInsertOrReplaceCommand(Element, Dictionary<string, object?>)

protected override DataAccessCommand GetInsertOrReplaceCommand(Element element, Dictionary<string, object?> values)

Parameters

element Element

values Dictionary<string, object>

Returns

DataAccessCommand

GetReadCommand(Element, EntityParameters, DataAccessParameter)

public override DataAccessCommand GetReadCommand(Element element, EntityParameters parameters, DataAccessParameter totalOfRecordsParameter)

Parameters

element Element

parameters EntityParameters

totalOfRecordsParameter DataAccessParameter

Returns

DataAccessCommand

GetReadProcedureScript(Element)

public override string GetReadProcedureScript(Element element)

Parameters

element Element

Returns

string

GetUpdateCommand(Element, Dictionary<string, object?>)

public override DataAccessCommand GetUpdateCommand(Element element, Dictionary<string, object?> values)

Parameters

element Element

values Dictionary<string, object>

Returns

DataAccessCommand

GetWriteProcedureScript(Element)

public override string GetWriteProcedureScript(Element element)

Parameters

element Element

Returns

string