public StatePower GetStatePowerById(SIGEeLDBContext e, string id) { var query = (from c in e.StatePowers where c.StatePowerId == new Guid(id) select c).FirstOrDefault(); return(query); }
public IEnumerable <Locality> GetLocalitiesByRegionId(SIGEeLDBContext e, string id) { var query = (from c in e.Localities where c.Region.RegionId == new Guid(id) select c); return(query); }
public SubSector GetSubSectorByName(SIGEeLDBContext e, string name) { var query = (from c in e.SubSectors where c.SubSectorName == name select c).FirstOrDefault(); return(query); }
public Country GetCountryById(SIGEeLDBContext e, string id) { var query = (from c in e.Countries where c.CountryId == new Guid(id) select c).FirstOrDefault(); return(query); }
public Locality GetLocalityById(SIGEeLDBContext e, string id) { var query = (from c in e.Localities where c.LocalityId == new Guid(id) select c).FirstOrDefault(); return(query); }
public Country GetCountryByName(SIGEeLDBContext e, string name) { var query = (from c in e.Countries where c.CountryName == name select c).FirstOrDefault(); return(query); }
public InstitutionType GetInstitutionTypeById(SIGEeLDBContext e, string id) { var query = (from c in e.InstitutionTypes where c.InstitutionTypeId == new Guid(id) select c).FirstOrDefault(); return(query); }
public InstitutionType GetInstitutionTypeByName(SIGEeLDBContext e, string name) { var query = (from c in e.InstitutionTypes where c.InstitutionTypeName == name select c).FirstOrDefault(); return(query); }
public Region GetRegionByName(SIGEeLDBContext e, string name) { var query = (from c in e.Regions where c.RegionName == name select c).FirstOrDefault(); return(query); }
public Region GetRegionById(SIGEeLDBContext e, string id) { var query = (from c in e.Regions where c.RegionId == new Guid(id) select c).FirstOrDefault(); return(query); }
public IEnumerable <StatePower> GetAll(SIGEeLDBContext e) { return(from c in e.StatePowers orderby c.StatePowerName ascending select c); }
public IEnumerable <SubSector> GetAll(SIGEeLDBContext e) { return(from c in e.SubSectors orderby c.SubSectorName ascending select c); }
public IEnumerable <Locality> GetAll(SIGEeLDBContext e) { return(from c in e.Localities orderby c.LocalityName ascending select c); }
public IEnumerable <Country> GetAll(SIGEeLDBContext e) { return(from c in e.Countries orderby c.CountryName ascending select c); }
public IEnumerable <InstitutionType> GetAll(SIGEeLDBContext e) { return(from c in e.InstitutionTypes orderby c.InstitutionTypeName ascending select c); }
public IEnumerable <Region> GetAll(SIGEeLDBContext e) { return(from c in e.Regions orderby c.RegionName ascending select c); }