Is it just me or is Subsonic the topic of discussion right now? I had a need to retrieve the last ID that had been generated in a table; that being, the last “auto increment” ID of a table. The following example worked a charm using Subsonic and activerecord. var fetch_ref_id = contract.All().OrderByDescending(c...

So the subsonic documentation sucks. If you’re new to activerecord, linq and subsonic in general; you’ll find it fairly hard to construct basic queries. However once you’ve got it under control, it’s a piece of cake. To sort your table using activerecord, use the following examples; To...