Class SQLiteProvider

Namespace

JJMasterData.Commons.Data.Entity.Providers

Assembly

JJMasterData.Commons.dll

public class SQLiteProvider : IEntityProvider

Inheritance

object

SQLiteProvider

Implements

IEntityProvider

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

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 connectionId, Guid? guid)

Parameters

schemaName string

connectionId string

guid 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 entityParameters, DataAccessParameter totalOfRecordsParameter)

Parameters

element Element

entityParameters 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?)

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

Parameters

tableName string

connectionId Guid?

Returns

bool

TableExistsAsync(string, Guid?, CancellationToken)

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>