public void can_use_execute_query() { _dataAccess.ExecuteCommand("CREATE TABLE Vampires(Name NVARCHAR(200) NOT NULL, Age INT NOT NULL)"); _dataAccess.ExecuteCommand("INSERT INTO Vampires(Name, Age) VALUES('Bill', 172)"); _dataAccess.ExecuteCommand("INSERT INTO Vampires(Name, Age) VALUES('Jessica', 17)"); _dataAccess.ExecuteCommand("INSERT INTO Vampires(Name, Age) VALUES('Erik', 1204)"); var vampireService = new VampireService(); var vampires = _dataAccess.ExecuteQuery<Vampire>( () => new Vampire(vampireService), "SELECT * FROM Vampires"); vampires.Count().ShouldBe(3); vampires.First(v => v.Name == "Bill").Age.ShouldBe(172); }
public void can_use_select() { _dataAccess.ExecuteCommand("CREATE TABLE Vampires(Name NVARCHAR(200) NOT NULL, Age INT NOT NULL)"); _dataAccess.ExecuteCommand("INSERT INTO Vampires(Name, Age) VALUES('Bill', 172)"); _dataAccess.ExecuteCommand("INSERT INTO Vampires(Name, Age) VALUES('Jessica', 17)"); _dataAccess.ExecuteCommand("INSERT INTO Vampires(Name, Age) VALUES('Erik', 1204)"); var vampireService = new VampireService(); var erik = _dataAccess.Select<Vampire>( () => new Vampire(vampireService), where: new { Name = "Erik" } ).First(); erik.Name.ShouldBe("Erik"); erik.Age.ShouldBe(1204); }
public Vampire(VampireService vampireService) { _vampireService = vampireService; }