I posted this question in SubSonic's forum, but their forum seems pretty dead. I've only posted 4 times and I'm ranked as one of the most active users!
If anyone has any insight, I'd appreciate it. The documentation for SubSonic stuff isn't very detailed or easy to find.
SubsonicNamespace.GeneratedClassname object = new SubsonicNamespace.GeneratedClassname(string columnName,object columnValue);
When you pass in a column name and a value, I can't tell exactly what it's trying to do. It's creating an object even if no records exist in the table. It looks like it is intended to try and query the database for that column and value. What if there is more than one record that matches? Does it return just the first record or does it have a collection attached to it?
Well, I never did find an explanation for how that method works, but I found a way to get the result I wanted that's even better!
SubsonicNamespace.GeneratedClassname dataObject = new SubSonic.Select().From(SubsonicNamespace.GeneratedClassname.Schema).Where("ColumnName").IsNull().ExecuteSingle<SubsonicNamespace.GeneratedClassname>();