public Sponsor GetSponsor(int id) { using (var context = new JobbiesContext(_connectionString)) { return context.Sponsors.FirstOrDefault(c => c.Id == id); } }
public Listing GetListing(int id) { using (var context = new JobbiesContext(_connectionString)) { return(context.Listings.FirstOrDefault(c => c.Id == id)); } }
public Listing GetListing(int id) { using (var context = new JobbiesContext(_connectionString)) { return context.Listings.FirstOrDefault(c => c.Id == id); } }
public Sponsor GetSponsor(int id) { using (var context = new JobbiesContext(_connectionString)) { return(context.Sponsors.FirstOrDefault(c => c.Id == id)); } }
public List<Listing> GetListings() { var results = new List<Listing>(); using (JobbiesContext context = new JobbiesContext(_connectionString)) { results = context.GetTable<Listing>().ToList(); } return results; }
public List <Listing> GetListings() { var results = new List <Listing>(); using (JobbiesContext context = new JobbiesContext(_connectionString)) { results = context.GetTable <Listing>().ToList(); } return(results); }
public Applicant Add(Applicant applicant) { using (var context = new JobbiesContext(_connectionString)) { context.Applicants.InsertOnSubmit(applicant); context.SubmitChanges(); } //TODO: return updated applicant with ID return applicant; }
public Applicant Add(Applicant applicant) { using (var context = new JobbiesContext(_connectionString)) { context.Applicants.InsertOnSubmit(applicant); context.SubmitChanges(); } //TODO: return updated applicant with ID return(applicant); }
public List <Listing> GetListings(int sponsorId) { var results = new List <Listing>(); using (JobbiesContext context = new JobbiesContext(_connectionString)) { var things = from sponsors in context.Sponsors join listings in context.Listings on sponsors.Id equals listings.SponsorId select listings; results = things.ToList(); } return(results); }
public List<Listing> GetListings(int sponsorId) { var results = new List<Listing>(); using (JobbiesContext context = new JobbiesContext(_connectionString)) { var things = from sponsors in context.Sponsors join listings in context.Listings on sponsors.Id equals listings.SponsorId select listings; results = things.ToList(); } return results; }