Simple way to use Foreign Key values for sorting?

Posted by Brian Rizzo on Stack Overflow See other posts from Stack Overflow or by Brian Rizzo
Published on 2010-05-14T01:09:05Z Indexed on 2010/05/14 1:14 UTC
Read the original article Hit count: 320

Filed under:

subsonic-active-record

|

subsonic3

|

subsonic

Disclaimer: I jumped to C# 2008 recently and SubSonic 3 (3.0.0.4) at the same time. I haven't used Linq for much of anything in the past.

Is there an easy way to use the foreign key display value for sorting, rather than the FK Id (which is numeric)?

I've added a new Find method in my ActiveRecord.tt to help with sorting based on a string field name but after doing some testing I realized that even though its working as it should be, I am not handling foreign key fields at all (they are just sorting by their value).

Even if I need to change how I am accessing the data it is early enough in the project to do that. Just looking for suggestions.

© Stack Overflow or respective owner

Related posts about subsonic-active-record

what's the point of using subsonic's active record ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there! I can't understand if we have linq to sql is there any benefits of using subsonic's active record because thay are similar (table=class). and sorry for offtop but does it support Oracle or DB2? Thanks! Victor. >>> More
Using constructor to load data in subsonic3?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm getting an error while trying to load an record through the constructor. The constructor is: public Document(Expression<Func<Document,bool>> expression); and i try to load a single item in like this var x = new Document(f=>f.publicationnumber=="xxx"); publicationnumber isn't… >>> More
Saving record in Subsonic 3 using Active Record

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having trouble saving a record in Subsonic 3 using Active record. I've generated my objects using the DALs and tts and everything seems fine because the following test passes. I think that my connection string is correct or the generation wouldn't have succeeded. [Test] public void… >>> More
Subsonic 3.0.0.4 Does not Update

as seen on Stack Overflow - Search for 'Stack Overflow'
I tried 3 variants but doesn't seem to update (I am using Linq Templates and MSSQL) Luna.Data.GameDBDB db = new Luna.Data.GameDBDB(); db.Update<Luna.Record.TB_ITEM>() .Set(x => x.ITEM_DURABILITY == Convert.ToInt32(quantity)) .Where(x => x.ITEM_DBIDX == Convert… >>> More
Atomically increment a field using SubSonic 3 ActiveRecord.

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm tring to increment a field in a MySQL database using SubSonic 3 ActiveRecord. In SQL, this is what I'm after: UPDATE people SET messages_received=messages_received+1 WHERE people_id=@id_to; I tried the following, but it didn't seem to work (messages_received always seemed to be 1): _db.Update<person>() … >>> More

Related posts about subsonic3

How to log subsonic3 sql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm starting to develop a new asp.net application based on subsonic3 (for queries) and log4net (for logs) and would like to know how to interface subsonic3 with log4net so that log4net logs the underlying sql used by subsonic. This is what I have so far: public static IEnumerable<arma_ocorrencium>… >>> More
Left Join in Subsonic3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I'm new in subsonic3, and I'm getting some errors when I try to use LeftJoin var q = from c in categories join p in products on c equals p.Category into ps from p in ps.DefaultIfEmpty() select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName… >>> More
Help with Subsonic3 ActiveRecord LINQ query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following subsonic entities TInvoiceHeader TAccountAssociation How can I achieve the following in LINQ (subsonic) SELECT * from TInvoiceHeader WHERE custid IN (SELECT custid FROM TAccountAssociation WHERE username = 'a') I need to bind the results to a GridView. >>> More
Help with Subsonic3 LINQ query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following subsonic entities TInvoiceHeader TAccountAssociation How can I achieve the following in LINQ SELECT * from TInvoiceHeader WHERE custid IN (SELECT custid FROM TAccountAssociation WHERE username = 'a') I need to bind the results to a GridView. >>> More
Using constructor to load data in subsonic3?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm getting an error while trying to load an record through the constructor. The constructor is: public Document(Expression<Func<Document,bool>> expression); and i try to load a single item in like this var x = new Document(f=>f.publicationnumber=="xxx"); publicationnumber isn't… >>> More