Noebe V2.0 美味的持久层 API 文档 一

Noebe V2.0 美味的持久层 API 文档

Pixysoft.Framework.Noebe 命名空间概览

 

类概览
ConnectionStringFactory	Get connection string Reference: http://www.carlprothman.net/Default.aspx?tabid=81
DatabaseUtility	database utility
NoebeAdapter	Noebe Adapter, the same as ADO.NET adapter
NoebeBase	Base class for other api
NoebeCommand	Noebe Comamnd, the same as ADO.NET command
NoebeConfiguration	noebe configuration
NoebeManager	NoebeManager Singleton pattern Init Noebe Get Other APIs
NoebePrimaryKey	Auto generate primary key
Querion	Auto Select and Manual Select
Session	Simple CRUD according to Schema
SyncSession	Distributed Simple SRUD according to Schema
SyncTransaction	Distributed Transaction according to Schema
Transaction	Simple Transaction

 

 

Pixysoft.Framework.Noebe
类 NoebeManager

总控制类

属性概览
Pixysoft.Framework.Noebe.Schema.DatabaseSchema	DatabaseSchema          get schema
Pixysoft.Framework.Noebe.NoebeManager	Instance
Pixysoft.Framework.Noebe.NoebeAdapter	NoebeAdapter          get noebe adapter
Pixysoft.Framework.Noebe.NoebeCommand	NoebeCommand          get noebe command
Pixysoft.Framework.Noebe.NoebePrimaryKey	NoebePrimaryKey          get noebeprimarykey
Pixysoft.Framework.Noebe.Querion	Querion          get querion
Pixysoft.Framework.Noebe.Session	Session          get session
Pixysoft.Framework.Noebe.SyncSession	SyncSession          get syncsession
Pixysoft.Framework.Noebe.SyncTransaction	SyncTransaction          get syncTransaction
Pixysoft.Framework.Noebe.Transaction	Transaction          get transaction

 

方法概览
void	AddBuffer(string[] tables)          add buffer of table into buffer layer
System.Data.DataSet	GetEntity()          get all tables from noebe
System.Data.DataTable	GetEntity(string tableName)          get table by tablename
void	Initialize()          Init noebe by default path
void	Initialize(string path)          nit noebe by manual path
void	Initialize(Pixysoft.Framework.Noebe.NoebeConfiguration config)          init noebe by code
void	Initialize(Pixysoft.Framework.Noebe.NoebeConfiguration config, Pixysoft.Framework.Noebe.Schema.DatabaseSchema ds)          init noebe by code

 

 

Pixysoft.Framework.Noebe
类 Querion

默认查询类

 

方法概览
bool	Select(System.Data.DataTable table)          select all
bool	Select(System.Data.DataTable table, string sql)          select by sql
bool	Select(System.Data.DataTable table, string sql, System.Collections.Generic.Dictionary<String,String> paras)
bool	SelectByPk(System.Data.DataTable table, object[] values)          select by primary key

 

 

Pixysoft.Framework.Noebe
类 Session

默认CRUD类

方法概览
bool	AutoInsert(System.Data.DataTable table)          insert without primarykey
bool	AutoInsert(System.Data.DataRow row)          insert without primarykey
bool	Delete(System.Data.DataTable table)          delete
bool	Delete(System.Data.DataRow row)          delete
bool	Insert(System.Data.DataTable table)          insert
bool	Insert(System.Data.DataRow row)          insert
bool	Update(System.Data.DataTable table)          update
bool	Update(System.Data.DataRow row)          update

 

Pixysoft.Framework.Noebe
类 Transaction

默认事务处理类

属性概览
bool	IsOpen          Gets a value that indicates if a transaction is currently open and operating.

 

方法概览
void	Begin()          Begins a transaction.
void	Commit()          Commit the transaction to the datasource.
bool	Delete(System.Data.DataTable table)
bool	Delete(System.Data.DataRow row)
bool	Insert(System.Data.DataTable table)
bool	Insert(System.Data.DataRow row)
void	Rollback()          Rollback the transaction.
bool	Update(System.Data.DataTable table)          Updates the specified _table. 同时更新缓存
bool	Update(System.Data.DataRow row)          Updates the specified _row. 同时更新缓存

 

 

Pixysoft.Framework.Noebe
类 SyncSession

支持分布式数据库同步操作的SRUD操作

方法概览
bool	Delete(System.Data.DataTable table)          delete
bool	Delete(System.Data.DataRow row)          delete
bool	Update(System.Data.DataTable table)          update
bool	Update(System.Data.DataRow row)          update

 

 

Pixysoft.Framework.Noebe
类 SyncTransaction

支持分布式数据库同步操作的事务处理类

属性概览
bool	IsOpen          查看事务是否开始

 

方法概览
void	Begin()          Begin a transaction
void	Commit()          Commit the transaction
bool	Delete(System.Data.DataTable table)          Delete from database Delete buffer
bool	Delete(System.Data.DataRow row)          Delete from database Delete buffer
bool	Insert(System.Data.DataTable table)          Insert into database Create Buffer, if needed
bool	Insert(System.Data.DataRow row)          Insert into database Create Buffer, if needed
void	Rollback()          Rollback the transaction
bool	Update(System.Data.DataTable table)          Update Database and buffer
bool	Update(System.Data.DataRow row)          Update Database and buffer

 

 

Pixysoft.Framework.Noebe
类 NoebePrimaryKey

自动添加主键类

 

属性概览
int	NumLength
string	Postfix
string	Prefix

 

方法概览
bool	FillByOracleSequence(System.Data.DataTable table, string seqname)          Fill primary key by oracle Sequence
bool	FillByOracleSequence(System.Data.DataTable table, string columnName, string seqname)          Fill primary key by oracle Sequence
bool	FillBySelectMax(System.Data.DataTable table)          General Fill Primary key by sql: Max()
bool	FillBySelectMax(System.Data.DataTable table, string columnName)          General Fill Primary key by sql: Max()
bool	FillBySelectMax(System.Data.DataRow row)          General Fill Primary key by sql: Max()
bool	FillBySelectMax(System.Data.DataRow row, string columnName)          General Fill Primary key by sql: Max()

 

 

Pixysoft.Framework.Noebe
类 NoebeAdapter

模拟ADO.NET类

方法概览
bool	Fill(System.Data.DataTable table)          Fill by Adapter fill
bool	Fill(System.Data.DataTable table, string sql)          Fill by Adapter fill
bool	Fill(System.Data.DataTable table, string sql, System.Collections.Generic.Dictionary`2[[System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] paras)
bool	Update(System.Data.DataTable table)          Update by Adapter.update()
bool	Update(System.Data.DataTable table, string sql)          Update by Adapter.update()
bool	Update(System.Data.DataTable table, string sql, System.Collections.Generic.Dictionary<String,String> paras)

 

 

Pixysoft.Framework.Noebe
类 NoebeCommand

模拟ADO.NET类

 

属性概览
string	SQL          Set command SQL

 

方法概览
bool	Execute(string[] paras)          Execute sql with string parameter
bool	Execute(System.Collections.Generic.Dictionary<String,String> paras)