public void ExactlyN() { var expected = Console.NintendoConsoles.Where(c => c.PortableConsole).ToArray(); var actual = Query.SelectExactly <Console>(expected.Length, ConsoleSelect.Where("PortableConsole = 1")).ToArray(); CollectionAssert.AreEqual(expected, actual); }
public void Insert() { Query.Change( @" INSERT INTO Console (Name, HomeConsole, PortableConsole) VALUES (@Name, @HomeConsole, @PortableConsole) ", new { Name = "Virtual Boy", HomeConsole = false, PortableConsole = true, } ); var virtualBoy = Query.SelectExactlyOne <Console>(ConsoleSelect.Where("Id = 13")); var expected = new Console[Console.NintendoConsoles.Length + 1]; var actual = Query.Select <Console>(ConsoleSelect).ToArray(); Array.Copy(Console.NintendoConsoles, expected, Console.NintendoConsoles.Length); expected[expected.Length - 1] = virtualBoy; CollectionAssert.AreEqual(expected, actual); }