public void OrderByTest() { using (IBulkedDbConnection bulk = FConnection.CreateBulkedDbConnection()) { bulk.Insert(new OrmType { Id = Guid.NewGuid(), Order = 1 }, new OrmType { Id = Guid.NewGuid(), Order = 2 }); bulk.Flush(); } SqlExpression <OrmType> expression = FConnection.From <OrmType>(); expression.PrefixFieldWithTableName = true; ISqlQuery query = new OrmLiteSqlQuery(expression); query.Select(typeof(OrmType).GetProperty(nameof(OrmType.Order)), typeof(OrmType).GetProperty(nameof(OrmType.Order))); query.OrderBy(typeof(OrmType).GetProperty(nameof(OrmType.Order))); query.OrderByDescending(typeof(OrmType).GetProperty(nameof(OrmType.Id))); List <OrmType> result = query.Run <OrmType>(FConnection); Assert.That(result.Count, Is.EqualTo(2)); Assert.That(result[0].Order, Is.EqualTo(1)); Assert.That(result[1].Order, Is.EqualTo(2)); }
public void JoinTest() { Guid id = Guid.NewGuid(); using (IBulkedDbConnection bulk = FConnection.CreateBulkedDbConnection()) { bulk.Insert(new OrmType { Id = id }); bulk.Insert(new OrmTypeWithReference { Id = Guid.NewGuid(), Reference = id }); bulk.Flush(); } SqlExpression <OrmType> expression = FConnection.From <OrmType>(); ISqlQuery query = new OrmLiteSqlQuery(expression); query.Select(typeof(OrmType).GetProperty(nameof(OrmType.Id)), typeof(MyView).GetProperty(nameof(MyView.Azonosito))); query.InnerJoin(typeof(OrmType).GetProperty(nameof(OrmType.Id)), typeof(OrmTypeWithReference).GetProperty(nameof(OrmTypeWithReference.Reference))); List <MyView> result = query.Run <MyView>(FConnection); Assert.That(result.Count, Is.EqualTo(1)); Assert.That(result.Single().Azonosito, Is.EqualTo(id)); }
public void SelectTest() { Guid id = Guid.NewGuid(); FConnection.Insert(new OrmType { Id = id }); SqlExpression <OrmType> expression = FConnection.From <OrmType>(); ISqlQuery query = new OrmLiteSqlQuery(expression); query.Select(typeof(OrmType).GetProperty(nameof(OrmType.Id)), typeof(MyView).GetProperty(nameof(MyView.Azonosito))); List <MyView> result = query.Run <MyView>(FConnection); Assert.That(result.Count, Is.EqualTo(1)); Assert.That(result.Single().Azonosito, Is.EqualTo(id)); }