DAL class methods definition

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. *

*****************************************************