public static List <LocalPropertyLookup> Load()
        {
            List <LocalPropertyLookup> items = new List <LocalPropertyLookup>();

            using (DataTransactionBase dt = new OracleDataTransaction(Configuration.StacksConnectionString))
            {
                LocalPropertyGateway gateway = new LocalPropertyGateway(dt.Transaction);
                gateway.Load(items);
            }

            return(items);
        }
        public void LoadLocalProperties_Test()
        {
            ICollection <LocalPropertyLookup> items = new List <LocalPropertyLookup>();

            using (DataTransactionBase dt = new OracleDataTransaction(Configuration.StacksConnectionString))
            {
                LocalPropertyGateway gateway = new LocalPropertyGateway(dt.Transaction);
                gateway.Load(items);
            }

            Assert.IsNotNull(items);
            Assert.IsTrue(items.Count > 0);
            Debug.WriteLine("local properties:{0}", items.Count);

            Assert.AreEqual(items.Count, items.Count((item) => item.IsLoaded));
        }