Ejemplos de LogCategoryCollection en C# (CSharp)

Ejemplo n.º 1

Archivo: LogCategoryAdapter.cs Proyecto: ounata/AK47-2016Source

        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);
        }

Ejemplo n.º 2

Archivo: LogCategoryAdapter.cs Proyecto: jerryshi2007/AK47Source

		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;
		}