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);
}
