I think [HasMany] should look like [ HasMany( typeof(AppAtbs) ) ] ~G
On Thu, Sep 3, 2009 at 11:28 AM, JamesL<[email protected]> wrote: > > Hi all, > > I have two tables: > > CREATE TABLE [SpatialApplications] ( > [ApplicationId] [int] IDENTITY (1, 1) NOT NULL , > [CRN] [char] (8) COLLATE Latin1_General_CI_AS NOT NULL , > [SRN] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , > [CaseId] [int] NULL , > [EditStatusId] [int] NULL , > ) ON [PRIMARY] > > CREATE TABLE [AppAtbs] ( > [Id] [int] NOT NULL , > [CRN] [char] (8) COLLATE Latin1_General_CI_AS NOT NULL , > [EOIReceived] [datetime] NULL , > ) ON [PRIMARY] > > (PK on SpatialApplication is ApplicationId, while PK on AppAtbs is Id) > > A SpatialApplications record has many AppAtbs records. > > In my (C#) AppAtb class, I've got the relationship set up as > > private SpatialApplication _SpatialApplication; > [BelongsTo("CRN")] > public SpatialApplication SpatialApplication > { > get { return _SpatialApplication; } > set { _SpatialApplication = value; } > } > > and in the SpatialApplication class: > > private IList<CAP_AppAtb> _CAP_AppAtbs; > [HasMany] > private IList<CAP_AppAtb> CAP_AppAtbs > { > get { return _CAP_AppAtbs; } > set { _CAP_AppAtbs = value; } > } > > > When I run the application, I'm getting the error "Syntax error > converting the varchar value 'A0000001' to a column of data type int." > when retrieving SpatialApplication records and their AppAtbs records. > > The full logged SQL is: > > SQL: SELECT cap_appatb0_.CRN as CRN__1_, cap_appatb0_.Id as Id1_, > cap_appatb0_.Id as Id1_0_, cap_appatb0_.CRN as CRN1_0_, > cap_appatb0_.EOIReceived as EOIRecei3_1_0_, cap_appatb0_.AppPackSent > as AppPackS4_1_0_, cap_appatb0_.AppReceived as AppRecei5_1_0_, > cap_appatb0_.NSAppPoints as NSAppPoi6_1_0_ FROM AppAtbs cap_appatb0_ > WHERE cap_appatb0_.CRN=? > > Copying this int SQL Query Analyzer and running it with an appropriate > CRN for the parameter placeholder works fine. > > Can anyone enlighten me as to what is going on? > > Thanks, > > James > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
