public IEnumerable <ListData> listDatas() { using (var cmd = _databaseFactory.CreateCommand()) { //SearchBorrowing searchBorrowing = new SearchBorrowing(); SqlParameter[] parameters = new SqlParameter[0]; using (var reader = SqlHelper.GetDataReader((SqlConnection)cmd.Connection, "USP_GetAllStatus", (SqlCommand)cmd, CommandType.StoredProcedure, parameters.Cast <SqlParameter>().ToList())) { return(MappingTodoList(reader).ToList()); } } }
public ApplicationClass(DatabaseFactory factory) // ctor { databaseFactory = factory; connection = factory.CreateConnection(); command = factory.CreateCommand(); }