c# - SubSonic3 SimpleRepository Relationships Generated are Wrong -


I am told that this is probably more than my database which is setting up incorrectly, so that the problems below are important fields With my tables and questions and questions. Table Presentations (Eid INT not create NULL identity (1 create, 1), SpeakerId INT not NULL, obstacle PK_Presentations Primary key (ID), constraint FK_Presentations_Speaker Alien Key (SpeakerId) Speakers Reference (ID)

When I execute: 

   
 Presentations = Presentations. Orderb (x = & gt; x.Speaker.FirstName);

Generates the query as generated: ... Select 

  [t0] [description], [t0] [eventID], [t0] [id], [t0]. [PresentedOn], [t0]. [Slug], [t0]. [SpeakerId], [t0]. [Title], [t0]. [Presentations] from [present] left in t0 form [speakers] in the form of current t1 ([t1]. [Id] = [t0]. [Id]] ou ([t1]. [First] Like 'B' + '%') Order BY [t1]. [First]

should join: .. 

  Left external [speakers] join in form of t1 ([t1] [id] = [t0] [SpeakerId 
 
 Related questions: 
 < Ul> 
  •  
    •  
  •  This is an urgent problem, 
    •   
     Really appreciate some help.

    < / Html>

    Comments

    Post a Comment