Create
Object Insert<T>(T obj) where T : class, new()
Object InsertByComplexPk<T>(T obj) where T : class, new()
Boolean BulkInsert<T>(IList<T> list) where T : class, new()
Retrieve
IQuery<T> GetQuery<T>() where T : class, new()
IList<T> GetAll<T>() where T : class, new()
IList<T> SelectListOfSingleField<T>(String sql)
IList<T> SelectList<T>(String sql) where T : class, new()
IList<T> SelectList<T>(IQuery query) where T : class, new()
IList<T> SelectListByAdapter<T>(String sql) where T : class, new()
IList<T> SelectListByAdapter<T>(IQuery query) where T : class, new()
IList<T> ExecListBySp<T>(String procName, StatementParameterCollection parameters) where T : class, new()
T GetByKey<T>(Object key) where T : class, new()
T SelectFirst<T>(String sql) where T : class, new()
T SelectFirst<T>(IQuery query) where T : class, new()
T VisitDataReader<T>(String sql, Func<IDataReader, T> callback)
T VisitDataReaderBySp<T>(String procName, StatementParameterCollection parameters, Func<IDataReader, T> callback)
DataTable SelectDataTable(String sql)
DataTable ExecDataTableBySp(String procName, StatementParameterCollection parameters)
DataSet SelectDataSet(String sql)
DataSet SelectDataSet<T>(IQuery query) where T : class, new()
DataSet ExecDataSetBySp(String procName, StatementParameterCollection parameters)
IDataReader SelectDataReader(String sql)
IDataReader ExecDataReaderBySp(String procName, StatementParameterCollection parameters)
Object ExecScalar(String sql)
Object ExecScalarBySp(String procName, StatementParameterCollection parameters)
Update
Int32 Update<T>(T obj) where T : class, new()
IUpdatePartial<T> GetUpdatePartially<T>() where T : class, new()
Int32 UpdatePartially<T>(IUpdatePartial<T> partially, T obj) where T : class, new()
Int32 ExecNonQuery(String sql)
void ExecSp(String procName, StatementParameterCollection parameters)
Delete
Int32 Delete<T>(T obj) where T : class, new()
*****************************************************
* No matter how far you go, looking back is also necessary. *
*****************************************************