I have avoided left outer joins in Linq to SQL because I have been always able to use a linq projection to get the needed values in a sub query. However, I had a bug in ADefHelpDesk that would not allow a search on the description of a ticket if the Ticket didn't have a related details record.



ADefHelpDesk_Task contains the ticket, and ADefHelpDesk_TaskDetail contains 0 or more detail records. The previous search code looked like this:

...

Well I spent all day working on ADefHelpDesk. I got these features in and released:

Allows users in the Assigned group to selectively send emails to Requestor.

Fixed url link in emails when the current user that created the emails was using a url that was not the default url.

Removed the use of the Ajax update panel to fix a bug in DNN5 Beta that did not allow Administrator to create a ticket for another user.

Fix bugs in search and optimized code to improve performance.

Fixed formatting of the Logs screen.

Doesn't seem like a lot considering...

According to this site, as of today the project is worth $87,000

http://www.ohloh.net/p/adefhelpdesk

The first few weeks launching an Open Source project can be a bit stressful