Example #1
0
        public void Collection_AddCustomPropertiesToList() {
            List<Product> result = new Select().From(Product.Schema).OrderAsc(Product.Columns.ProductID).ExecuteTypedList<Product>();

            SubSonic.SqlQuery q = new
                Select(Product.ProductIDColumn, Category.CategoryNameColumn)
                .From(Product.Schema)
                .InnerJoin<Category>();

            q.AddAsCustomProperties<Product>(result);

            Assert.AreEqual("Beverages", result[0].CategoryName);
            Assert.AreEqual(1, result[0].ProductID);
        }
Example #2
0
        public void Collection_AddCustomProperties() {
            ProductCollection result = new ProductCollection().OrderByAsc(Product.Columns.ProductID).Load();

            SubSonic.SqlQuery q = new
                Select(Product.ProductIDColumn, Category.CategoryNameColumn)
                .From(Product.Schema)
                .InnerJoin<Category>();

            q.AddAsCustomProperties<Product, ProductCollection>(result);

            Assert.AreEqual("Beverages", result[0].CategoryName);
            Assert.AreEqual(1, result[0].ProductID);
        }