Constructing a where clause in Iron Speed is a straight forward and painless process.
In Visual Studio, when overriding any of the base methods, it is essential to be able to compare the value of a column that needs to have some sort of test to determine whether or not the current record is saved successfully i.e: Validate() is a prime example.
One aspect that frequently catches me out is not using .UniqueName, so for example:
CarTable.HasAirCon should infact be CarTable.HasAirCon.UniqueName.
Using SQL Server's Profiler you can see format of the execution of the query that Iron Speed has generated. Without the uniquename you will see something that does not resemble any table column in your database and have an error thrown at run time.
Ricci