ORM Framework Petapoco API

Petapoco Database api#region idisposablepublic void Dispose () #endregion #regionConstructorsPublic database () public database (IDbConnection connection) public database (string connectionString, String ProviderName = null) public database (string connectionString, DbProviderFactory Factory) public Database (string connectionStringName) public Database (String connectionString, Iprovider provider, imapper defaultmapper = null) public Database (idatabasebuildconfiguration configuration) #endregion #regionConnection Managementpublic bool Keepconnectionalive;public void Opensharedconnection ();p ublic void Closesharedconnection ();p ublic IDbConnection Connection; #endregion #regionTransactionmanagement//Helper to create a transaction scopepublic ITransaction gettransaction () public virtual void Onbegintransacti On () public virtual void onendtransaction () public void BeginTransaction () private void cleanuptransaction () public void Aborttransaction () public void completetransaction () #endregion #regionCommand Managementprivate void AddParam (IDbCommand cmd, object value, PropertyInfo pi)//Create a commandprivate static Regex Rxparamsprefix = new Regex (@ "(? <[email protected]) @\w+", regexoptions.compiled);p ublic IDbCommand CreateCommand (idbconnection connection, String sql, params object[] args) #endregion #regionException Reporting and LoggingPublic virtual bool Onexception (Exception x) public virtual IDbConnection onconnectionopened (IDbConnection conn) public virtual void onconnectionclosing (IDbConnection conn) public virtual void Onexecutingcommand (IDbCommand cmd) public virtual void Onexecutedcommand (IDbCommand cmd) #endregion #region operation:Executepublic int execute (String sql, params object[] args) public int execute (SQL SQL) #endregion #region operation:ExecuteScalarPublic T-executescalar<t> (String sql, params object[] args) public T executescalar<t> (SQL SQL) #endregion # Region operation:FetchPublic list<t> fetch<t> (String sql, params object[] args) public list<t> fetch<t> (SQL SQL) # Endregion#region Operation:PagePublic page<t> page<t> (Long Page, long itemsperpage, String sqlcount, object[] Countargs, String sqlpage, Object[] Pageargs)Public page<t> page<t> (long Page, long itemsperpage, String sql, params object[] args) public page<t> Pag E<t> (Long page, long itemsperpage, SQL SQL)Public page<t> page<t> (Long Page, long itemsperpage, SQL SqlCount, SQL Sqlpage)#endregion #region Operation:Fetch (page)Public list<t> fetch<t> (Long page, long itemsperpage, String sql, params object[] args) public list<t> Fe Tch<t> (Long page, long itemsperpage, SQL SQL) #endregion #region operation:SkiptakePublic list<t> skiptake<t> (long skip, long take, String sql, params object[] args) public list<t> Skiptak E<t> (long skip, long take, SQL SQL) #endregion #region operation:QueryPublic ienumerable<t> query<t> (String sql, params object[] args) public ienumerable<t> query<t> (SQL SQL) #endregion #region operation:Existspublic bool Exists<t> (string sqlcondition, params object[] args) public bool Exists<t> (object PrimaryKey) # Endregion#region operation:linq Style (Exists, single, Singleordefaultetc ...) Public T-single<t> (object PrimaryKey) public T singleordefault<t> (object PrimaryKey) public T single<t > (String sql, params object[] args) public T singleordefault<t> (String sql, params object[] args) public T first&lt ; T> (String sql, params object[] args) public T firstordefault<t> (String sql, params object[] args) public T SINGLE&L T t> (SQL SQL) public t singleordefault<t> (SQL SQL) public t first<t> (SQL SQL) public T firstordefault<t > (SQL SQL) #endregion #region operation:Insertpublic object Insert (string TableName, Object poco) public object Insert (String tableName, String primarykeyname, Object Po CO) public Object Insert (String tableName, String primarykeyname, bool AutoIncrement, object Poco) public object Insert (obj ECT poco) Private Object Executeinsert (String tableName, String primarykeyname, bool AutoIncrement, Object Poco) # Endregion#region Operation:Updatepublic int Update (string tableName, String Primarykeyname, Object Poco, Object primarykeyvalue) public int update (String ta Blename, String Primarykeyname, Object Poco, Object Primarykeyvalue, ienumerable<string> columns) public int Update (String tableName, String Primarykeyname, Object poco) public int Update (string tableName, String primarykeyname, Object Po Co, ienumerable<string> columns) public int Update (object poco, ienumerable<string> columns) public int Update (object poco) public int Update (object Poco, Object primarykeyvalue) public int Update (object Poco, Object PrimaryKey Value, ienumerable<string> columns) public int update<t> (String sql, params object[] args) public int update& Lt t> (SQL SQL) private int executeupdate (string tableName, String Primarykeyname, Object Poco, Object Primarykeyvalue, IEn umerable<string> columns) #endregion #region operation:Deletepublic int Delete (string tableName, String Primarykeyname, Object poco) public int Delete (string tableName, String Primaryk Eyname, Object Poco, Object primarykeyvalue) public int Delete (object poco) public int delete<t> (object Pocoorprimarykey) public int delete<t> (String sql, params object[] args) public int delete<t> (SQL SQL) # Endregion#region Operation:isnewpublic bool IsNew (string Primarykeyname, Object poco) protected virtual bool IsNew (string primarykeyname, Pocodata PD, Obje CT poco) public bool IsNew (object poco) #endregion #region operation:Savepublic void Save (string tableName, String Primarykeyname, object poco) public void Save (object poco) #endregion
#region Operation:multi-pocoQuery/fetchPublic list<tret> fetch<t1, T2, tret> (Func<t1, T2, tret> cb, String sql, params object[] args) public Lis T<tret> fetch<t1, T2, T3, tret> (Func<t1, T2, T3, tret> cb, String sql, params object[] args) public list& Lt Tret> fetch<t1, T2, T3, T4, tret> (Func<t1, T2, T3, T4, tret> cb, String sql, params object[] args) public IE Numerable<tret> query<t1, T2, tret> (Func<t1, T2, tret> cb, String sql, params object[] args) public ienum Erable<tret> query<t1, T2, T3, tret> (Func<t1, T2, T3, tret> cb, String sql, params object[] args) public  Ienumerable<tret> query<t1, T2, T3, T4, tret> (Func<t1, T2, T3, T4, tret> cb, String sql, params object[] args) public list<tret> fetch<t1, T2, tret> (Func<t1, T2, tret> CB, SQL SQL) public list<tret> Fetch <t1, T2, T3, tret> (Func<t1, T2, T3, tret> CB, SQL SQL) public list<tret> fetch<t1, T2, T3, T4, Tret&gt ;(func<t1, T2, T3, T4, tret> CB, SQL SQL) public ienumerable<tret> query<t1, T2, tret> (Func<t1, T2, tret> CB, SQL SQL) PU Blic ienumerable<tret> query<t1, T2, T3, tret> (Func<t1, T2, T3, tret> CB, SQL SQL) public ienumerable<  Tret> query<t1, T2, T3, T4, tret> (Func<t1, T2, T3, T4, tret> CB, SQL SQL) public list<t1> fetch<t1, T2> (String sql, params object[] args) public list<t1> fetch<t1, T2, t3> (String sql, params object[] args) pu Blic list<t1> fetch<t1, T2, T3, t4> (String sql, params object[] args) public ienumerable<t1> query<t1  , t2> (String sql, params object[] args) public ienumerable<t1> query<t1, T2, t3> (String sql, params object[] args) public ienumerable<t1> query<t1, T2, T3, t4> (String sql, params object[] args) public list<t1> fetc H&LT;T1, t2> (SQL SQL) public list<t1> fetch<t1, T2, t3> (SQL SQL) public list<t1> fetch<t1, T2, T3, T 4> (SQL SQL) public IenuMerable<t1> query<t1, t2> (SQL SQL) public ienumerable<t1> query<t1, T2, t3> (SQL SQL) public Ienumerable<t1> query<t1, T2, T3, t4> (SQL SQL) public ienumerable<tret> query<tret> (Type[]  Types, Object cb, String sql, params object[] args) #endregion #regionLast Commandpublic string Lastsqlpublic object[] Lastargspublic string lastcommand#endregion#regionFormatcommandpublic string Formatcommand (IDbCommand cmd) public string Formatcommand (String sql, object[] args) #endregion #region PublicPropertiesPublic Imapper defaultmapperpublic BOOL enableautoselect;public bool Enablenamedparams;public int commandtimeout; public int onetimecommandtimeout;public Iprovider providerpublic string connectionstringpublic isolationlevel? Isolationlevel#endregion#region Member FieldsMember variablesprivate imapper _defaultmapper;private string _connectionstring;private iprovider _provider;private IDbConnection _sharedconnection;private idbtransaction _transaction;private int _sharedconnectiondepth;private int _ transactiondepth;private bool _transactioncancelled;private string _lastsql;private object[] _lastArgs;private string _paramprefix;private dbproviderfactory _factory;private IsolationLevel? _isolationlevel; #endregion #region Internal operationsinternal void Executenonqueryhelper (IDbCommand cmd); Internal Object Executescalarhelper (IDbCommand cmd); internal void Dopreexecute (IDbCommand cmd); #endregion

　　

ORM Framework Petapoco API