public IEnumerable <LogCategory> LoadCategories() { LogCategoryCollection list = new LogCategoryCollection(); var sql = @"SELECT [Category],[OperationType] FROM [SC].[OperationLog] GROUP BY Category,OperationType"; using (var context = DbHelper.GetDBContext(this.GetConnectionName())) { Database db = DatabaseFactory.Create(context); var cmd = db.GetSqlStringCommand(sql); using (var dr = db.ExecuteReader(cmd)) { ORMapping.DataReaderToCollection(list, dr); } } return(list); }
public IEnumerable<LogCategory> LoadCategories() { LogCategoryCollection list = new LogCategoryCollection(); var sql = @"SELECT [Category],[OperationType] FROM [SC].[OperationLog] GROUP BY Category,OperationType"; using (var context = DbHelper.GetDBContext(this.GetConnectionName())) { Database db = DatabaseFactory.Create(context); var cmd = db.GetSqlStringCommand(sql); using (var dr = db.ExecuteReader(cmd)) { ORMapping.DataReaderToCollection(list, dr); } } return list; }