Class SqlServerProvider

Namespace

JJMasterData.Commons.Data.Entity.Providers

Assembly

JJMasterData.Commons.dll

public class SqlServerProvider : IEntityProvider

Inheritance

object

SqlServerProvider

Implements

IEntityProvider

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Constructors

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

public SqlServerProvider(IConnectionRepository connectionRepository, SqlServerScripts sqlServerScripts, IMemoryCache memoryCache, IOptionsSnapshot<MasterDataCommonsOptions> options)

Parameters

connectionRepository IConnectionRepository

sqlServerScripts SqlServerScripts

memoryCache IMemoryCache

options IOptionsSnapshot<MasterDataCommonsOptions>

Properties

VariablePrefix

public string VariablePrefix { get; }

Property Value

string

Methods

ColumnExistsAsync(string, string, Guid?, CancellationToken)

public 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 Task DropStoredProcedureAsync(string procedureName, Guid? connectionId = null)

Parameters

procedureName string

connectionId Guid?

Returns

Task

GetAlterTableScript(Element, IEnumerable<ElementField>)

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

Parameters

element Element

fields IEnumerable<ElementField>

Returns

string

GetCreateTableScript(Element, List<RelationshipReference>?)

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

Parameters

element Element

relationships List<RelationshipReference>

Returns

string

GetDeleteCommand(Element, Dictionary<string, object>)

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

Parameters

element Element

filters Dictionary<string, object>

Returns

DataAccessCommand

GetElementFromTableAsync(string, Guid?)

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

Parameters

tableName string

connectionId Guid?

Returns

Task<Element>

GetElementFromTableAsync(string, string, Guid?)

public Task<Element> GetElementFromTableAsync(string schemaName, string tableName, Guid? connectionId)

Parameters

schemaName string

tableName string

connectionId Guid?

Returns

Task<Element>

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

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

Parameters

element Element

values Dictionary<string, object>

Returns

DataAccessCommand

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

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

Parameters

element Element

values Dictionary<string, object>

Returns

DataAccessCommand

GetReadCommand(Element, EntityParameters, DataAccessParameter)

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

Parameters

element Element

parameters EntityParameters

totalOfRecordsParameter DataAccessParameter

Returns

DataAccessCommand

GetReadProcedureScript(Element)

public string GetReadProcedureScript(Element element)

Parameters

element Element

Returns

string

GetStoredProcedureDefinitionAsync(string, Guid?)

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

Parameters

procedureName string

connectionId Guid?

Returns

Task<string>

GetStoredProcedureListAsync(Guid?)

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

Parameters

connectionId Guid?

Returns

Task<List<string>>

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

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

Parameters

element Element

values Dictionary<string, object>

Returns

DataAccessCommand

GetWriteProcedureScript(Element)

public string GetWriteProcedureScript(Element element)

Parameters

element Element

Returns

string

TableExists(string, Guid?)

Check if table exists in the database

public 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 Task<bool> TableExistsAsync(string tableName, Guid? connectionId = null, CancellationToken cancellationToken = default)

Parameters

tableName string

connectionId Guid?

cancellationToken CancellationToken

Returns

Task<bool>

TableExistsAsync(string, string, Guid?, CancellationToken)

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

Parameters

schema string

tableName string

connectionId Guid?

cancellationToken CancellationToken

Returns

Task<bool>