Current filter:
                                You should refresh the page.

                                OBSOLETE - How to use AgDataGrid with XPO for data browsing and editing

                                0

                                This example is obsolete. Refer to An example of a simple CRUD XPO SL application.
                                This example demonstrates the co-work of the AgDataGrid and XPO (eXpress Persistent Objects). The approach shown in this demo can be considered as the XPO alternative to Silverlight RIA Services.

                                To launch the demo:
                                * Restore NorthwindXpo.backup on your SQL Server.
                                * Check the connection string in WebApplication\XpoGate.asmx.cs (MSSqlConnectionProvider.GetConnectionString).
                                * Set WebApplication as a startup project and SilverlightModuleTestPage.html as a start page.

                                Refer to K18395 to learn how this example is created.

                                You must  log in  or  register  to leave comments
                                Select file
                                • NorthwindXpo.cs
                                • Page.xaml
                                • Page.xaml.cs
                                • XpoGate.asmx.cs
                                • XpoGateSoapClient.cs
                                Select language
                                • C#
                                • VB.NET
                                Select version
                                • v2010 vol 2.3 - v2010 vol 2.11
                                • v2010 vol 1.4 - v2010 vol 1.12
                                using System;
                                using DevExpress.Xpo;
                                using System.Collections.Generic;
                                
                                namespace NorthwindXpo {
                                
                                    public class Employee : PersistentBase {
                                        public Employee(Session session) : base(session) { }
                                
                                        [Key(true)]
                                        public int OID;
                                
                                        string fLastName;
                                        public string LastName {
                                            get { return fLastName; }
                                            set { SetPropertyValue("LastName", ref fLastName, value); }
                                        }
                                        string fFirstName;
                                        public string FirstName {
                                            get { return fFirstName; }
                                            set { SetPropertyValue("FirstName", ref fFirstName, value); }
                                        }
                                        string fTitle;
                                        public string Title {
                                            get { return fTitle; }
                                            set { SetPropertyValue("Title", ref fTitle, value); }
                                        }
                                        DateTime fBirthDate;
                                        public DateTime BirthDate {
                                            get { return fBirthDate; }
                                            set { SetPropertyValue("BirthDate", ref fBirthDate, value); }
                                        }
                                        DateTime fHireDate;
                                        public DateTime HireDate {
                                            get { return fHireDate; }
                                            set { SetPropertyValue("HireDate", ref fHireDate, value); }
                                        }
                                        string fAddress;
                                        public string Address {
                                            get { return fAddress; }
                                            set { SetPropertyValue("Address", ref fAddress, value); }
                                        }
                                        string fCity;
                                        public string City {
                                            get { return fCity; }
                                            set { SetPropertyValue("City", ref fCity, value); }
                                        }
                                        string fPostalCode;
                                        public string PostalCode {
                                            get { return fPostalCode; }
                                            set { SetPropertyValue("PostalCode", ref fPostalCode, value); }
                                        }
                                        string fCountry;
                                        public string Country {
                                            get { return fCountry; }
                                            set { SetPropertyValue("Country", ref fCountry, value); }
                                        }
                                        string fHomePhone;
                                        public string HomePhone {
                                            get { return fHomePhone; }
                                            set { SetPropertyValue("HomePhone", ref fHomePhone, value); }
                                        }
                                        string fExtension;
                                        public string Extension {
                                            get { return fExtension; }
                                            set { SetPropertyValue("Extension", ref fExtension, value); }
                                        }
                                        [Delayed]
                                        public byte[] Photo {
                                            get { return GetDelayedPropertyValue<byte[]>("Photo"); }
                                            set { SetDelayedPropertyValue("Photo", value); }
                                        }
                                        string fNotes;
                                        [Size(SizeAttribute.Unlimited)]
                                        public string Notes {
                                            get { return fNotes; }
                                            set { SetPropertyValue("Notes", ref fNotes, value); }
                                        }
                                        Employee fReportsTo;
                                        [Association("Employee-Subordinates")]
                                        public Employee ReportsTo {
                                            get { return fReportsTo; }
                                            set { SetPropertyValue<Employee>("ReportsTo", ref fReportsTo, value); }
                                        }
                                
                                        [Association("Employee-Orders")]
                                        public IList<Order> Orders {
                                            get {
                                                return GetList<Order>("Orders");
                                            }
                                        }
                                
                                        [Association("Employee-Subordinates")]
                                        public IList<Employee> Subordinates {
                                            get {
                                                return GetList<Employee>("Subordinates");
                                            }
                                        }
                                    }
                                
                                    public class Order : PersistentBase {
                                        public Order(Session session) : base(session) { }
                                
                                        [Key(true)]
                                        public int OID;
                                
                                        Customer fCustomer;
                                        [Association("Customer-Orders")]
                                        public Customer Customer {
                                            get { return fCustomer; }
                                            set { SetPropertyValue("Customer", ref fCustomer, value); }
                                        }
                                        Employee fEmployee;
                                        [Association("Employee-Orders")]
                                        public Employee Employee {
                                            get { return fEmployee; }
                                            set { SetPropertyValue<Employee>("Employee", ref fEmployee, value); }
                                        }
                                        DateTime fOrderDate;
                                        public DateTime OrderDate {
                                            get { return fOrderDate; }
                                            set { SetPropertyValue("OrderDate", ref fOrderDate, value); }
                                        }
                                        DateTime fShippedDate;
                                        public DateTime ShippedDate {
                                            get { return fShippedDate; }
                                            set { SetPropertyValue("ShippedDate", ref fShippedDate, value); }
                                        }
                                        decimal fFreight;
                                        public decimal Freight {
                                            get { return fFreight; }
                                            set { SetPropertyValue("Freight", ref fFreight, value); }
                                        }
                                        string fShipName;
                                        public string ShipName {
                                            get { return fShipName; }
                                            set { SetPropertyValue("ShipName", ref fShipName, value); }
                                        }
                                        string fShipAddress;
                                        public string ShipAddress {
                                            get { return fShipAddress; }
                                            set { SetPropertyValue("ShipAddress", ref fShipAddress, value); }
                                        }
                                        string fShipCity;
                                        public string ShipCity {
                                            get { return fShipCity; }
                                            set { SetPropertyValue("ShipCity", ref fShipCity, value); }
                                        }
                                        string fShipRegion;
                                        public string ShipRegion {
                                            get { return fShipRegion; }
                                            set { SetPropertyValue("ShipRegion", ref fShipRegion, value); }
                                        }
                                        string fShipPostalCode;
                                        public string ShipPostalCode {
                                            get { return fShipPostalCode; }
                                            set { SetPropertyValue("ShipPostalCode", ref fShipPostalCode, value); }
                                        }
                                        string fShipCountry;
                                        public string ShipCountry {
                                            get { return fShipCountry; }
                                            set { SetPropertyValue("ShipCountry", ref fShipCountry, value); }
                                        }
                                    }
                                
                                    public class Customer : PersistentBase {
                                        public Customer(Session session) : base(session) { }
                                
                                        [Key(true)]
                                        public int OID;
                                
                                        string fCompanyName;
                                        public string CompanyName {
                                            get { return fCompanyName; }
                                            set { SetPropertyValue("CompanyName", ref fCompanyName, value); }
                                        }
                                        string fContactName;
                                        public string ContactName {
                                            get { return fContactName; }
                                            set { SetPropertyValue("ContactName", ref fContactName, value); }
                                        }
                                        string fContactTitle;
                                        public string ContactTitle {
                                            get { return fContactTitle; }
                                            set { SetPropertyValue("ContactTitle", ref fContactTitle, value); }
                                        }
                                        string fAddress;
                                        public string Address {
                                            get { return fAddress; }
                                            set { SetPropertyValue("Address", ref fAddress, value); }
                                        }
                                        string fCity;
                                        public string City {
                                            get { return fCity; }
                                            set { SetPropertyValue("City", ref fCity, value); }
                                        }
                                        string fRegion;
                                        public string Region {
                                            get { return fRegion; }
                                            set { SetPropertyValue("Region", ref fRegion, value); }
                                        }
                                        string fPostalCode;
                                        public string PostalCode {
                                            get { return fPostalCode; }
                                            set { SetPropertyValue("PostalCode", ref fPostalCode, value); }
                                        }
                                        string fCountry;
                                        public string Country {
                                            get { return fCountry; }
                                            set { SetPropertyValue("Country", ref fCountry, value); }
                                        }
                                        string fPhone;
                                        public string Phone {
                                            get { return fPhone; }
                                            set { SetPropertyValue("Phone", ref fPhone, value); }
                                        }
                                
                                        [Association("Customer-Orders")]
                                        public IList<Order> Orders {
                                            get {
                                                return GetList<Order>("Orders");
                                            }
                                        }
                                    }
                                
                                    public class Category : PersistentBase {
                                        public Category(Session session) : base(session) { }
                                
                                        string fCategoryName;
                                        public string CategoryName {
                                            get { return fCategoryName; }
                                            set { SetPropertyValue("CategoryName", ref fCategoryName, value); }
                                        }
                                        string fDescription;
                                        [Size(SizeAttribute.Unlimited)]
                                        public string Description {
                                            get { return fDescription; }
                                            set { SetPropertyValue("Description", ref fDescription, value); }
                                        }
                                
                                        [Delayed]
                                        public byte[] Picture {
                                            get { return GetDelayedPropertyValue<byte[]>("Picture"); }
                                            set { SetDelayedPropertyValue("Picture", value); }
                                        }
                                
                                        [Association("Category-Products")]
                                        public IList<Product> Products {
                                            get {
                                                return GetList<Product>("Products");
                                            }
                                        }
                                    }
                                
                                    public class Product : PersistentBase {
                                        public Product(Session session) : base(session) { }
                                
                                        string fProductName;
                                        public string ProductName {
                                            get { return fProductName; }
                                            set { SetPropertyValue("ProductName", ref fProductName, value); }
                                        }
                                        Category fCategory;
                                        [Association("Category-Products")]
                                        public Category Category {
                                            get { return fCategory; }
                                            set { SetPropertyValue<Category>("Category", ref fCategory, value); }
                                        }
                                        string fQuantityPerUnit;
                                        public string QuantityPerUnit {
                                            get { return fQuantityPerUnit; }
                                            set { SetPropertyValue("QuantityPerUnit", ref fQuantityPerUnit, value); }
                                        }
                                        decimal fUnitPrice;
                                        public decimal UnitPrice {
                                            get { return fUnitPrice; }
                                            set { SetPropertyValue("UnitPrice", ref fUnitPrice, value); }
                                        }
                                        bool fDiscontinued;
                                        public bool Discontinued {
                                            get { return fDiscontinued; }
                                            set { SetPropertyValue("Discontinued", ref fDiscontinued, value); }
                                        }
                                    }
                                }