Click here to Skip to main content
15,561,125 members
Articles / Programming Languages / Visual Basic
Posted 19 Jan 2012


21 bookmarked

Lightswitch Job Hunter Application

Rate me:
Please Sign up or sign in to vote.
5.00/5 (10 votes)
19 Jan 2012CPOL3 min read
Job application tracker for those out of work built using Visual Studio Lightswitch 2011.

Job Hunter LS


Prove to us that LightSwitch was the best tool for the job! You must answer the following questions in order to qualify:

  1. What does your application/extension do? What business problem does it solve?

    The application allows those who are searching for work to track job applications. Those of us who are unemployed might need to track dozens of job applications and ensure we are following up on our applications. Ensuring timely follow-ups will separate you from the pack.

  2. How many screens and entities does this application have?

    The Job Hunter application has 10 screens, 3 entities, and 4 queries.

Additionally, answer as many questions below to improve your chances to win.

  1. Did LightSwitch save your business money? How?

    It is not a business application, but a get yourself back to business application. It will save your bank account, by helping get back to work sooner.

  2. Would this application still be built if you didn’t have LightSwitch? If yes, with what?

    Yes, I would have built it with WinForms, WPF, and an Access database or maybe Excel.

  3. How many users does this application support?

    It is set for one user, but the source code is available for expanding.

  4. How long did this application take to actually build using LightSwitch?

    The program took about 15 hours to build, but I was learning Lightswitch at the time. I could build it in as little as three hours now.

  5. Does this application use any LightSwitch extensions? If so, which ones? Did you write any of these extensions yourself? If so, is it available to the public? Where?

    The application uses the freely available controls; including Bing Maps Lightswitch control, Web Address Type by Alessandro Del Sole, and the Office Black and Silver Theme by Cromanty. All controls are available from the Visual Studio Gallery

  6. How did LightSwitch make your developer life better? Was it faster to build compared to other options you considered?

    Using Lightswitch made building the application dramatically faster. I could experiment and find the best way to build the application. It also allowed me to try several variations of deployment, before beginning use.

    There is one part that I hope to finish in the near future. A complete installer as described by Vincent at (Lightswitch Installer). This would be optimal to help someone who knows little about installing a DB.

Links, Screenshots, Videos

Demo video of application can be viewed here.


Home Screen

Home or "Start" Screen

Company List Detail - Company Information

Company List Detail - Job Application and Follow-Up Information

Company List Detail - Bing Map of Where Company Is Located

Follow-Up Screen - "Active" Job Applications That Have Not Been Updated (Modified) in More Than 7 Days

Applications this Week - For US unemployment, you need to fill out who you've applied to

Other screens are search - All, Active, and Inactive.

A neat little bit of code I had to learn to create the LINQ query to look up active jobs that have not been modified in over 7 days.

' Preprocess Query to select only active jobs that have not been modified in over 7 days.
Private Sub FollowUpDue_PreprocessQuery(ByRef query As System.Linq.IQueryable_
             (Of LightSwitchApplication.JobAppliedFor))
    ' Today minus 7 days
    Dim DatePlus = Date.Now.AddDays(-7D)
    '  query jobAppliedFors Table that are active and last modified over 7 days ago.
    query = From jobAppliedFors In query
            Where jobAppliedFors.Active = True
            Where jobAppliedFors.DateModified < DatePlus
            Order By jobAppliedFors.DateModified
End Sub

Points of Interest

One thing I learned is how to create basic LINQ queries and how to better create a database. Building this application really has helped me understand how to better understand development. LightSwitch reduces the initial learning curve of database development and I would recommend it to anyone who wants to learn more about software development. It should be used in school as a learning tool!


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Product Manager
United States United States
Hobby coder - VB.NET, C#, and Lightswitch advocate! I am a product manager specializing in data analysis systems for industrial manufacturing.

Comments and Discussions

GeneralMessage Closed Pin
23-Nov-20 23:34
Vaishnavi M23-Nov-20 23:34 
Questionwpf Pin
kiquenet.com20-Dec-19 10:23
professionalkiquenet.com20-Dec-19 10:23 
QuestionInvalid download link for source Pin
Larry @Datasmith1-Dec-13 8:12
Larry @Datasmith1-Dec-13 8:12 
Questionnot able to compile Pin
g_dev16-Mar-13 7:13
g_dev16-Mar-13 7:13 
Question5/5 Pin
Jan Van der Haegen28-Jan-12 8:30
Jan Van der Haegen28-Jan-12 8:30 
AnswerRe: 5/5 Pin
stuxstu28-Jan-12 10:23
stuxstu28-Jan-12 10:23 
GeneralMy vote of 5 Pin
defwebserver23-Jan-12 8:35
defwebserver23-Jan-12 8:35 
GeneralRe: My vote of 5 Pin
stuxstu23-Jan-12 8:43
stuxstu23-Jan-12 8:43 
QuestionMessage Pin
Eric Castellon19-Jan-12 18:14
Eric Castellon19-Jan-12 18:14 
AnswerRe: Message Pin
stuxstu20-Jan-12 4:09
stuxstu20-Jan-12 4:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.