Class BaseDataProvider

Namespace: Tool.SqlCore
Assembly: Tool.Net.dll

数据库访问底层父类，继承皆可实现高效开发访问

public abstract class BaseDataProvider

Inheritance

object ← BaseDataProvider

Inherited Members

object.Equals(object?), object.Equals(object?, object?), object.GetHashCode(), object.GetType(), object.MemberwiseClone(), object.ReferenceEquals(object?, object?), object.ToString()

Extension Methods

ObjectExtension.Add<T>(object, object, object), ObjectExtension.CopyEntity(object, object, params string[]), ObjectExtension.EntityToJson(object), ObjectExtension.EntityToJson(object, bool), ObjectExtension.EntityToJson(object, bool, string), DictionaryExtension.GetDictionary(object), TypeExtension.GetFieldKey(object, string, out bool), TypeExtension.GetFieldKey<T>(object, string, out bool), TypeExtension.GetFieldKey(object, Type, string, out bool), ObjectExtension.GetIntPtr(object), ObjectExtension.GetIntPtrInt(object), TypeExtension.GetPropertieFind(object, string, bool), TypeExtension.GetProperties(object), TypeExtension.GetPropertyKey(object, string, out bool), TypeExtension.GetPropertyKey<T>(object, string, out bool), TypeExtension.GetPropertyKey(object, Type, string, out bool), TypeExtension.GetValue(object, PropertyDescriptor), TypeExtension.GetValue(object, string, bool), TypeExtension.GetValue(object, string), ObjectExtension.Read<T>(object, object, int, int), ObjectExtension.Read<T>(object, int, object, int, int), DictionaryExtension.SetDictionary(object, IDictionary<string, object>), TypeExtension.SetFieldKey(object, string, object), TypeExtension.SetFieldKey<T>(object, string, object), TypeExtension.SetFieldKey(object, Type, string, object), TypeExtension.SetPropertyKey(object, string, object), TypeExtension.SetPropertyKey<T>(object, string, object), TypeExtension.SetPropertyKey(object, Type, string, object), TypeExtension.SetValue(object, PropertyDescriptor, object), TypeExtension.SetValue(object, string, object, bool), TypeExtension.SetValue(object, string, object), ObjectExtension.ToBase64String(object), ObjectExtension.ToBytes(object), ObjectExtension.ToBytes(object, out Type), DictionaryExtension.ToDictionary(object), DictionaryExtension.ToDictionary<T>(object), DictionaryExtension.ToIDictionary(object), DictionaryExtension.ToIDictionary<T>(object), ObjectExtension.ToJson(object), ObjectExtension.ToJson(object, JsonSerializerOptions), ObjectExtension.ToJsonWeb(object), ObjectExtension.ToJsonWeb(object, Action<JsonSerializerOptions>), ObjectExtension.ToTryVar<T>(object, T), ObjectExtension.ToVar<T>(object), ObjectExtension.ToVar(object, Type, bool), ObjectExtension.ToVar(object, string), ObjectExtension.ToXml(object)

Remarks

代码由逆血提供支持

Constructors

BaseDataProvider(string, string, IDbProvider)

初始化 底层 默认为SqlServer 数据库的访问

protected BaseDataProvider(string connectionString, string dbProviderName, IDbProvider dbProvider)

Parameters

connectionString string

连接字符串

dbProviderName string

数据库类型定义名称

dbProvider IDbProvider

实现SQL对象类，具有高扩展性

BaseDataProvider(string, DbProviderType, IDbProvider)

初始化 底层

protected BaseDataProvider(string connectionString, DbProviderType dbProviderType, IDbProvider dbProvider)

Parameters

connectionString string

连接字符串

dbProviderType DbProviderType

数据库类型

dbProvider IDbProvider

实现SQL对象类，具有高扩展性

BaseDataProvider(string, string, IDbProvider, ILogger)

初始化 底层 默认为SqlServer 数据库的访问

protected BaseDataProvider(string connectionString, string dbProviderName, IDbProvider dbProvider, ILogger logger)

Parameters

connectionString string

连接字符串

dbProviderName string

数据库类型定义名称

dbProvider IDbProvider

实现SQL对象类，具有高扩展性

logger ILogger

用于打印程序日志，可以为null

BaseDataProvider(string, DbProviderType, IDbProvider, ILogger)

初始化 底层

protected BaseDataProvider(string connectionString, DbProviderType dbProviderType, IDbProvider dbProvider, ILogger logger)

Parameters

connectionString string

连接字符串

dbProviderType DbProviderType

数据库类型

dbProvider IDbProvider

实现SQL对象类，具有高扩展性

logger ILogger

用于打印程序日志，可以为null

BaseDataProvider(DbHelper)

初始化 底层

protected BaseDataProvider(DbHelper database)

Parameters

database DbHelper

操作对象

Properties

ConnectionString

链接字符串

protected string ConnectionString { get; }

Property Value

string

Database

数据底层类

protected DbHelper Database { get; }

Property Value

DbHelper

DbProviderName

获取当前访问的数据库类型

protected string DbProviderName { get; }

Property Value

string

DbProviderType

获取当前访问的数据库类型

protected DbProviderType DbProviderType { get; }

Property Value

DbProviderType

IsSqlLog

是否启动SQL日志打印

protected bool IsSqlLog { get; set; }

Property Value

bool

Methods

GetPagerSet(PagerParameters)

分页，用于SQL对象的分页

protected virtual PagerSet GetPagerSet(PagerParameters prams)

Parameters

prams PagerParameters

Returns

PagerSet

GetPagerSetAsync(PagerParameters)

分页，用于SQL对象的分页

protected virtual Task<PagerSet> GetPagerSetAsync(PagerParameters prams)

Parameters

prams PagerParameters

Returns

Task<PagerSet>

GetTableProvider(string)

表信息对象，用于对单张表的处理

protected virtual ITableProvider GetTableProvider(string tableName)

Parameters

tableName string

表名

Returns

ITableProvider

GetTableProvider<T>(string)

表信息对象，用于对单张表的处理，可以通过自己实现接口来完成效果。

protected virtual ITableProvider GetTableProvider<T>(string tableName) where T : ITableProvider, new()

Parameters

tableName string

表名

Returns

ITableProvider

Type Parameters

T

自己实现的单表操作类