//delete people public static void DeletePeople(int idcode) { // Always use context on LINQ to SQL.. MC 28/05/2017 peopleDataContext dc = new peopleDataContext(); try { /* var findPeople = (from gente in dc.GetTable<people>() * where (gente.Id == idcode) * select gente).SingleOrDefault<people>(); */ // Call from getPeopleID function .. to create a clean code. var findPeople = GetPeopleID(idcode); if (findPeople != null) { try { dc.peoples.Attach(findPeople); dc.peoples.DeleteOnSubmit(findPeople); dc.SubmitChanges(); } catch (Exception) { throw; } } } catch (Exception) { throw; } }
public static IQueryable <people> GetIQueryablePeople() { peopleDataContext dc = new peopleDataContext(); try { return(dc.GetTable <people>()); } catch (Exception) { throw; } }
public static void ManuPeople(people _People) { peopleDataContext dc = new peopleDataContext(); { // here we have the update or Insert //// -- var findPeople = getPeopleID(_People.Id); var findPeople = (from gente in dc.GetTable <people>() where (gente.Id == _People.Id) select gente).SingleOrDefault <people>(); if (findPeople == null) { try { people people = new people(); people.Id = _People.Id; people.name = _People.name; people.phone = _People.phone; people.age = _People.age; Table <people> peopleInsert = GetPeople(); peopleInsert.InsertOnSubmit(people); peopleInsert.Context.SubmitChanges(); } catch (Exception) { // better way, because you can capture ALL exception and use it as IS throw; } } else { try { //use the findPeople on CONTEXT findPeople.Id = _People.Id; findPeople.name = _People.name; findPeople.phone = _People.phone; findPeople.age = _People.age; dc.SubmitChanges(); } catch (Exception) { // better way, because you can capture ALL exception and use it as IS throw; } } } }
// LINQ to GET PEOPLE public static people GetPeopleID(int idcode) { peopleDataContext dc = new peopleDataContext(); try { // This is LINQ Syntax to return just the record passed via ID return((from gente in dc.GetTable <people>() where (gente.Id == idcode) select gente).SingleOrDefault <people>()); } catch (Exception) { throw; } }