db = new ORM.myProviderDataContext();
            var result = (from p in db.Products
                         join img in db.Photos on p.ProductID equals img.ProductID
                         where img.IsProfil == '1'
                         orderby p.RegisterDate descending
                         select new
                         {
                             p.ProductID,
                             p.ProductName,
                             p.UnitPrice,
                             img.Path
                         }).Take(10); //Son 10 ürünü listeler
            rptNewProducts.DataSource = result;
            rptNewProducts.DataBind();