Click or drag to resize
MySql Class
MySql 数据操作类
Inheritance Hierarchy

Namespace: Adf.Db
Assembly: Adf (in Adf.dll) Version: 4.1.5549.27750
Syntax
public class MySql : DbFactory

The MySql type exposes the following members.

Constructors
  NameDescription
Public methodMySql
初始化操作类型
Top
Methods
  NameDescription
Public methodBegin
开始一个事务执行,当多个事务并行时,以最外层有效
(Inherited from DbFactory.)
Public methodCommit
提交一个事务执行,并行事务时非最外层则跳过
(Inherited from DbFactory.)
Public methodCommit(Boolean)
提交一个事务执行
(Inherited from DbFactory.)
Public methodCreateCommand
根据指定数据返回Command对象,所有的数据操作均应执行此方法来获取Command对象
(Inherited from DbFactory.)
Protected methodCreateParameter(DbEntity)
根据对象创建参数列表,使用ParameterChar所指定的参数前缀
(Inherited from DbFactory.)
Public methodCreateParameter(String, Object, Int32)
创建一个参数
(Inherited from DbFactory.)
Public methodCreateParameter(String, Object, DbType, Int32)
创建一个参数
(Inherited from DbFactory.)
Public methodDelete
执行数据对象删除处理
(Inherited from DbFactory.)
Public methodDispose
释放所占用的资源
(Inherited from DbFactory.)
Public methodEquals
确定指定的 Object 是否等于当前的 Object
(Inherited from Object.)
Public methodExecute(String)
执行一个语句或过程
(Inherited from DbFactory.)
Public methodExecute(DbEntity, String)
执行一个语句或过程
(Inherited from DbFactory.)
Public methodExecute(String, Boolean, IDbDataParameter)
执行一个语句或过程
(Inherited from DbFactory.)
Protected methodFinalize
允许 Object 在“垃圾回收”回收 Object 之前尝试释放资源并执行其他清理操作。
(Inherited from Object.)
Public methodGetCount(String)
获取指定语句第一行第一例的Int类型数据
(Inherited from DbFactory.)
Public methodGetCount(DbEntity)
获取指定对象的记录数
(Inherited from DbFactory.)
Public methodGetCount(String, Boolean)
获取指定语句第一行第一例的Int类型数据
(Inherited from DbFactory.)
Public methodGetCount(String, String)
根据表与条件返回一个COUNT值
(Inherited from DbFactory.)
Public methodGetCount(DbEntity, String)
获取指定对象的记录数
(Inherited from DbFactory.)
Public methodGetDataSet(String)
返回一个数据集
(Inherited from DbFactory.)
Public methodGetDataSet(DbEntity)
返回一个数据集
(Inherited from DbFactory.)
Public methodGetDataSet(DbEntity, String)
返回一个数据集
(Inherited from DbFactory.)
Public methodGetDataSet(String, Boolean, IDbDataParameter)
返回一个数据集
(Inherited from DbFactory.)
Public methodGetDataTable(String)
返回一个数据表
(Inherited from DbFactory.)
Public methodGetDataTable(DbEntity)
返回一个数据表
(Inherited from DbFactory.)
Public methodGetDataTable(DbEntity, String)
返回一个数据表
(Inherited from DbFactory.)
Public methodGetDataTable(String, Boolean, IDbDataParameter)
返回一个数据表
(Inherited from DbFactory.)
Public methodGetHashCode
用作特定类型的哈希函数。
(Inherited from Object.)
Public methodGetIdentityT
获取上一执行语句所产生的自增值(此功能不一定支持所有数据库服务器),如果有误,返回为结果类型初始值
(Overrides DbFactoryGetIdentityT.)
Public methodGetListT(String)
返回一个数据对象集
(Inherited from DbFactory.)
Public methodGetListT(DbEntity)
返回一个数据对象集
(Inherited from DbFactory.)
Public methodGetListT(DbEntity, String)
返回一个数据对象集
(Inherited from DbFactory.)
Public methodGetListT(String, Boolean, IDbDataParameter)
返回一个数据对象集
(Inherited from DbFactory.)
Public methodGetListsT(String)
返回一个数据对象集
(Inherited from DbFactory.)
Public methodGetListsT(DbEntity)
返回一个数据对象集
(Inherited from DbFactory.)
Public methodGetListsT(DbEntity, String)
返回一个数据对象集
(Inherited from DbFactory.)
Public methodGetListsT(String, Boolean, IDbDataParameter)
返回一个数据对象集
(Inherited from DbFactory.)
Public methodGetRowT(String)
返回一个数据对象
(Inherited from DbFactory.)
Public methodGetRowT(DbEntity)
返回一个数据对象
(Inherited from DbFactory.)
Public methodGetRowT(DbEntity, String)
返回一个数据对象
(Inherited from DbFactory.)
Public methodGetRowT(String, Boolean, IDbDataParameter)
返回一个数据对象
(Inherited from DbFactory.)
Public methodGetScalar(String)
获取第一行第一列的数据
(Inherited from DbFactory.)
Public methodGetScalar(DbEntity)
获取第一行第一列的数据
(Inherited from DbFactory.)
Public methodGetScalar(DbEntity, String)
获取第一行第一列的数据
(Inherited from DbFactory.)
Public methodGetScalar(String, Boolean, IDbDataParameter)
获取第一行第一列的数据
(Inherited from DbFactory.)
Public methodGetType
获取当前实例的 Type
(Inherited from Object.)
Public methodInjectReplace
SQL注入过滤
(Inherited from DbFactory.)
Public methodInsert
执行数据对象插入请求
(Inherited from DbFactory.)
Protected methodLogBuilder
日志添加
(Inherited from DbFactory.)
Protected methodLogManagerInitialize
日志管理器初始
(Inherited from DbFactory.)
Protected methodMemberwiseClone
创建当前 Object 的浅表副本。
(Inherited from Object.)
Public methodPageSqlT
返回一个分页列表对象
(Inherited from DbFactory.)
Public methodRollback
回滚事务,当并行事务已回滚时则跳过
(Inherited from DbFactory.)
Public methodToSafeString(Object)
根据数据类型返回一个可以直接应用于SQL语句的安全字符串
(Inherited from DbFactory.)
Public methodToSafeString(Object, Type)
根据数据类型返回一个可以直接应用于SQL语句的安全字符串
(Inherited from DbFactory.)
Public methodToString
返回表示当前 ObjectString
(Inherited from Object.)
Public methodUpdate
执行数据对象修改
(Inherited from DbFactory.)
Top
Properties
  NameDescription
Public propertyCommandCount
获取Command数,间接反应了执行了多少次数据操作
(Inherited from DbFactory.)
Public propertyConnection
获取当前数据库连接串
(Inherited from DbFactory.)
Protected propertyDbProviderFactory
获取当前数据数据处理方法集
(Inherited from DbFactory.)
Public propertyLastSql
获取最后一个查询SQL
(Inherited from DbFactory.)
Public propertyLogger
日志撰写器 若启用日志,默认的日志管理实例受FlushInterval影响,若配置该值则应在程序执行结束后进行相应的Flush操作,Factory不会进行默认缓冲刷新
(Inherited from DbFactory.)
Public propertyName
获取当前操作对象的名称描述
(Overrides DbFactoryName.)
Public propertyNestedTransaction
获取是否为并行(嵌套)事务
(Inherited from DbFactory.)
Protected propertyParameterChar
获取创建参数时,使用的前缀,默认使用@符,如果当前操作引擎不是,请重写该属性
(Overrides DbFactoryParameterChar.)
Public propertySqlBuilder
已重载,语句创建
(Overrides DbFactorySqlBuilder.)
Public propertyTransaction
获取当前正在执行的事务
(Inherited from DbFactory.)
Public propertyTransactionLayer
获取为并行(嵌套)事务时的当前事务层级
(Inherited from DbFactory.)
Top
See Also