/** * add advisor to Advisors table * add playerToAdvisor to PlayerToAdvisor table */ public void AddAdvisor(Player player, Advisor[] advisors, int gameId) { foreach (Advisor a in advisors) { Advisor advisor = new Advisor(); advisor.First_Name = a.First_Name; advisor.Last_Name = a.Last_Name; db.Advisors.InsertOnSubmit(advisor); db.SubmitChanges(); PlayerToAdvisor p = new PlayerToAdvisor(); p.Player = player.Id; p.Advisor = advisor.Id; p.Game = gameId; db.PlayerToAdvisors.InsertOnSubmit(p); db.SubmitChanges(); } }
partial void UpdatePlayerToAdvisor(PlayerToAdvisor instance);
partial void DeletePlayerToAdvisor(PlayerToAdvisor instance);
partial void InsertPlayerToAdvisor(PlayerToAdvisor instance);