NULL ForeignKeyTo property in Subsonic 3/ASP.NET MVC?

Posted by chad on Stack Overflow See other posts from Stack Overflow or by chad
Published on 2009-06-10T13:34:47Z Indexed on 2010/04/17 3:23 UTC
Read the original article Hit count: 302

Filed under:

subsonic3

|

subsonic-v3p2

|

subsonic

|

asp.net-mvc

Issue: the primary key of the base table is named differently than the the key in the fk table.

Subsonic 3 does not know how to handle that, which is fine, its beta. So I was going to change the Html.ControlFor logic to just grab the table and use the pkname from that:

var fk = db.FindTable(col.ForeignKeyTo.FriendlyName);

However the .ForeignKeyTo is null. Where in the templates does that ITable get populated?

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

Developer IT

NULL ForeignKeyTo property in Subsonic 3/ASP.NET MVC? - Developer IT

NULL ForeignKeyTo property in Subsonic 3/ASP.NET MVC?

subsonic3

subsonic-v3p2

subsonic

asp.net-mvc

Related posts about subsonic3

How to log subsonic3 sql

Left Join in Subsonic3

Help with Subsonic3 ActiveRecord LINQ query

Help with Subsonic3 LINQ query

Using constructor to load data in subsonic3?

Related posts about subsonic-v3p2

NULL ForeignKeyTo property in Subsonic 3/ASP.NET MVC?

Categories cloud