public void CreateSponsorProfileTest() { using (var db = new CSBCDbContext()) { var repPeople = new PersonRepository(db); var people = db.People.Where(p => p.Sponsor == true).ToList(); var repColor = new ColorRepository(db); var color = repColor.GetByName(1, "Red").ID; Contract.Assert(color != 0); var repProfile = new SponsorProfileRepository(db); var person = people.FirstOrDefault(); var sponsorProfile = repProfile.Insert(new SponsorProfile { SpoName = person.LastName + "Company", SponsorProfileID = 0, CompanyID = 1, HouseID = person.HouseID, State = "FL", City = "Coral Springs", Address = "10 Main Street", ContactName = person.FirstName + " " + person.LastName }); var profile = repProfile.GetById(sponsorProfile.SponsorProfileID); Assert.IsTrue(profile != null); repProfile.Delete(profile); profile = repProfile.GetById(sponsorProfile.SponsorProfileID); Assert.IsTrue(profile == null); } }