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

ColumnExistsAsync(string, string, Guid?, CancellationToken)

public override Task<bool> ColumnExistsAsync(string tableName, string columnName, Guid? connectionId = null, CancellationToken cancellationToken = default)

Parameters

tableName string

columnName string

connectionId Guid?

cancellationToken CancellationToken

Returns

Task<bool>

DropStoredProcedureAsync(string, Guid?)

public override Task DropStoredProcedureAsync(string procedureName, Guid? connectionId = null)

Parameters

procedureName string

connectionId Guid?

Returns

Task

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

GetStoredProcedureDefinitionAsync(string, Guid?)

public override Task<string?> GetStoredProcedureDefinitionAsync(string procedureName, Guid? connectionId = null)

Parameters

procedureName string

connectionId Guid?

Returns

Task<string>

GetStoredProcedureListAsync(Guid?)

public override Task<List<string>> GetStoredProcedureListAsync(Guid? connectionId = null)

Parameters

connectionId Guid?

Returns

Task<List<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

TableExists(string, Guid?)

Check if table exists in the database

public override bool TableExists(string tableName, Guid? connectionId = null)

Parameters

tableName string

connectionId Guid?

Returns

bool

TableExistsAsync(string, Guid?, CancellationToken)

Check if table exists in the database

public override Task<bool> TableExistsAsync(string tableName, Guid? connectionId = null, CancellationToken cancellationToken = default)

Parameters

tableName string

connectionId Guid?

cancellationToken CancellationToken

Returns

Task<bool>