DevExpress XPO - 1.0

using DevExpress.Xpo;

namespace DevExpress.Xpo.ConsoleCoreDemo {
    class StatisticInfo : XPLiteObject {
        public StatisticInfo(Session session)
            : base(session) {
        }
        Guid key;
        [Key(true)]
        public Guid Key {
            get { return key; }
            set { SetPropertyValue(nameof(Key), ref key, value); }
        }
        string info;
        [Size(255)]
        public string Info {
            get { return info; }
            set { SetPropertyValue(nameof(Info), ref info, value); }
        }
        DateTime date;
        public DateTime Date {
            get { return date; }
            set { SetPropertyValue(nameof(Date), ref date, value); }
        }
    }
}

using DevExpress.Xpo;
using DevExpress.Xpo.DB;

namespace DevExpress.Xpo.ConsoleCoreDemo {
    class Program {
        static void Main(string[] args) {
                    
        using(UnitOfWork uow = new UnitOfWork()) {
                StatisticInfo newInfo = new StatisticInfo(uow);
                newInfo.Info = result;
                newInfo.Date = DateTime.Now;
                newInfo.Save();
                Console.WriteLine("Saved.");
            }
        }
    }
}

namespace DevExpress.Xpo.ConsoleCoreDemo {
    class Program {
        static void Main(string[] args) {

        using(UnitOfWork uow = new UnitOfWork()) {
                var query = uow.Query<StatisticInfo>()
                    .OrderBy(info => info.Date)
                    .Select(info => $"[{info.Date}] {info.Info}");
                foreach(var line in query) {
                    Console.WriteLine(line);
            }
        }     
    }
}

using DevExpress.Xpo.DB;
using DevExpress.Xpo.Metadata;

namespace dxTestSolutionXPO {
    class Program {
        static void Main(string[] args) {
            ConnectionHelper.Connect(DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
            MakeInitialData();
            var session = new Session();
            var lst = new XPCollection<OrderItem>(session);
            var cnt = lst.Count;
            var c = new XPCollection<Order>(session)[0].OrderItems.ToList();
        }

        static T CreateObject<T>(string propertyName, string value, Session session) {

            T theObject = session.FindObject<T>(new OperandProperty(propertyName) == value);
            if (theObject == null) {
                theObject = (T)Activator.CreateInstance(typeof(T), new object[] { session });
                ((XPCustomObject)(object)theObject).SetMemberValue(propertyName, value);
            }

            return theObject;

        }
    }
}

namespace WpfApplication1
{
  using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Windows;

  using DevExpress.Xpo;
  using DevExpress.Xpo.DB;


  public class DataSource
  {
    public DataSource()
    {
      Setup();
    }

    public XPDataView Data { get; private set; }

    private void Setup()
    {
      var connectionString = MSSqlConnectionProvider.GetConnectionString("sever", "user", "passwd", "database");
      var dataLayer        = XpoDefault.GetDataLayer(connectionString, AutoCreateOption.SchemaAlreadyExists);

      using (var uow = new UnitOfWork(dataLayer))
      {
        var sql    = "SELECT Id, Name FROM customer WHERE Name = @Name";
        var dbData = uow.ExecuteQueryWithMetadata(sql, new[] { "Name" }, new[] { "Computer" });

        Data = new XPDataView().FillAndLoad(dbData.ResultSet);
      }
    }
  }
}

namespace WpfApplication1
{
  using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Windows;

  using DevExpress.Xpo;
  using DevExpress.Xpo.DB;

  public partial class MainWindow : Window
  {
    public MainWindow()
    {
      InitializeComponent();
      DataContext = new DataSource();
    }
  }

  public class DataSource
  {
    public DataSource()
    {
      Setup();
    }

    public static XPDataView FillAndLoad(this XPDataView self, Session sess, string sql)
    {
      return self.FillAndLoad(sess.ExecuteQueryWithMetadata(sql).ResultSet);
    }
  }
}