private List <T> ExecuteReader <T>(string cmdText,
CommandType commandType, Func <SqlDataReader, T> itemCreator, params SqlParameter[] sqlParameters)
{
return(SqlDBUtils.ExecuteReader(_connectionString, cmdText, commandType, itemCreator, sqlParameters));
}
private int ExecuteNonQuery(string cmdText,
CommandType commandType, params SqlParameter[] sqlParameters)
{
return(SqlDBUtils.ExecuteNonQuery(_connectionString, cmdText, commandType, sqlParameters));
}
//public IList<IAlbum> GetNonEmptyAlbums()
//{
// string cmdText = "GetNonEmptyAlbums";
// return ExecuteReader<IAlbum>(
// cmdText,
// CommandType.StoredProcedure,
// (r) => CreateAlbum((int)r["AlbumID"], 0, "", false));
//}
#endregion
private object ExecuteScalar(string cmdText, CommandType commandType, params SqlParameter[] sqlParameters)
{
return(SqlDBUtils.ExecuteScalar(_connectionString, cmdText, commandType, sqlParameters));
}