public void StringFunctions() { Context context = new Context(SetUpCodeFirst.Connection); var myGroupBy2 = context.TableWithSeveralFieldsTypes .GroupBy(g => g.MyString, r => r.MyInt) .Select(g => new { Group = JetFunctions.LCase(g.Key), MyLastInt = JetFunctions.JetLast(g) }).First(); Console.WriteLine("{0} {1}", myGroupBy2.Group, myGroupBy2.MyLastInt); Assert.AreEqual(myGroupBy2.Group, myGroupBy2.Group.ToLower()); context.Dispose(); }
public void GroupByFunctions() { Context context = new Context(SetUpCodeFirst.Connection); var myGroupBy1 = context.TableWithSeveralFieldsTypes .GroupBy(g => g.MyString, r => r.MyInt) .Select(g => new { Group = g.Key, MyFirstInt = g.JetFirst() }).First(); Console.WriteLine("{0} {1}", myGroupBy1.Group, myGroupBy1.MyFirstInt); var myGroupBy2 = context.TableWithSeveralFieldsTypes .GroupBy(g => g.MyString, r => r.MyInt) .Select(g => new { Group = g.Key, MyLastInt = JetFunctions.JetLast(g) }).First(); Console.WriteLine("{0} {1}", myGroupBy2.Group, myGroupBy2.MyLastInt); context.Dispose(); }