Are you a highly motivated .NET code monkey developer in the Tampa Bay area with a passion for software and the ability to learn quickly?

if(not){return;}

Come join our top-notch team of developers who utilize the latest technologies (JQuery, NHibernate, CruiseControl, Nant, Resharper, etc.) to build the essential tools for the nation's largest and fastest-growing audiovisual firm.

The ideal candidate will have:

• Minimum 2 years experience developing applications.
• Minimum 1 year experience with C# in ASP.NET and/or Windows Forms.
• Strong experience with MS SQL Server.
• Solid skills and knowledge of HTML/DHTML, JavaScript and XML.
• Excellent written and verbal communication skills.
• Ability to learn quickly, as well as think and work independently.
• Passion for learning new technology and implementation techniques

In my neverending quest to keep my domain minimal, I ran into a query that I wanted to perform with NHibernate that seems to be impossible without adding an additional property and hbm mapping definition.

Note: I still consider myself rather new to NHibernate, so this might have an obvious answer.

Let's say I have following two classes:
public class School : EntityBase
{
     public string Name { get; set; }
     public IList<Student> Students { get; set; }
}

public class Student : EntityBase
{
     public string Name { get; set; }
}

The School.hbm.xml file contains this in the body:
<bag name="Students">
    <key column="SchoolId"/>
    <one-to-many class="Student"/>
</bag>

The database representation of the above looks something like this:

Without making any changes to my classes/mappings, I can perform this SQL query to retrieve all Students who's name contains 'Powers' that belong to a school who's name contains 'Middle':
SELECT * FROM Students
WHERE
     Students.Name LIKE '%Powers%'
     AND
     Students.SchoolId IN (SELECT School.Id FROM Schools WHERE Schools.Name LIKE '%Middle%')

So - Here is the question, how can I do this in an HQL query without making any changes to my domain (which would be specifically adding a School property to the Student class and defining the relationship in the Student.hbm.xml file)?

Wow, this isn't my ideal way of getting my hands dirty in a project.  But, this will be easy to fix.

Opening this .NET 1.1 ASP.NET app, I find three projects and no solution file.  Confused, I open the projects individually and realize there is a huge circular reference issue that was circumvented by compiling the projects seperately and then referencing their output assemblies. Yuck. There are also heaps of bugs in the code causing all sorts of unneeded memory usage that's causing the application to freeze and recycle several times a day.  Finally, I'm told that all of the latest features created for the site have been causing problems everywhere else.  I think it's time for a change.

After several weeks of unit tests, refactoring, SVN, and CC.NET configuration.

• The site no longer crashes.
  
• Features can be implemented faster and more effectively.
• Source control provides a source history with much safer storage.
• A new version of the site can be deployed with the click of a button.
  

• America's Army: Special Forces
• Battlecruiser 3000 A.D.
• Grand Theft Auto & Grand Theft Auto 2
• Hidden & Dangerous Deluxe
• The Marathon Trilogy
• Return to Castle Wolfenstein: Enemy Territory
• Starsiege: Tribes
• Wild Metal Country
• The Zork Trilogy

http://www.ukuleledisco.com/jakeconcert

Here's another one: http://movies.collegehumor.com/items/2005/06/collegehumor.159572.mov

I've never heard anyone play a ukulele like this... his name is Jake Shimabukuro jakeshimabukuro.com