ORMs don’t kill databases. Developers do.(arrangeactassert.com)

    Just as guns don’t kill people, ORMs don’t kill databases. Developers do.

    [Test]
    public void Tale_Of_Two_Queries()
    {
        var fruitDatabase = new FruitDatabase();
        using (ISession session = fruitDatabase.Session)
        {
            using (ITransaction txn = session.BeginTransaction())
            {

                var apple = new Fruit() { Name = "Apple", IsAlsoAColor = false};
                var orange = new Fruit() { Name = "Orange", IsAlsoAColor = true };

                session.Save(apple);
                session.Save(orange);
                txn.Commit();
            }

            var firstQuery = session.Query<Fruit>()
            .Where(f => !f.IsAlsoAColor)
            .Select(f => f.Name)
            .ToList();        

            var secondQuery = session.Query<Fruit>()
                    .Where(f => f.IsAlsoAColor == false)
                    .Select(f => f.Name)
                    .ToList();
        }
    }

    select fruit0_.Name as col_0_0_
    from   Fruits fruit0_
    where  not (fruit0_.IsAlsoAColor = 1)

    select fruit0_.Name as col_0_0_
    from   Fruits fruit0_
    where  case
             when fruit0_.IsAlsoAColor = 1 then 1
             else 0
           end = case
                   when 0 /* @p0 */ = 1 then 1
                   else 0
                 end