public static bool RemoveTeamMembersFromTeamId(int teamId)
{
try
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
var members = (from c in data.TeamMemberDataProviders
where c.team_id == teamId
select c).ToList();
foreach (TeamMemberDataProvider member in members)
{
data.TeamMemberDataProviders.DeleteOnSubmit(member);
data.SubmitChanges();
}
return true;
}
}
catch (Exception)
{
return false;
}
}