Is there a reason you're using the full database.schema.table format? Have you tried just specifying the table name?
On 2/9/09, Pete <pete554is...@snapsintime.com> wrote: > > James, thanks for the quick response. The IList fix the problem. > But I am still having issues with the collections. I am now getting > this error message.... > > _Test_EOMapping.UserPermissionTest.DisplayOneRow: > NHibernate.Exceptions.GenericADOException : could not initialize a > collection: [SnapsInTime.EO.UserPermission.allRoles#ab68b9ac-f2e5-4147- > a143-00a405d47e39][SQL: SELECT allroles0_.UserPermission_id as > UserPerm1_1_, allroles0_.UserRoles_id as UserRoles2_1_, > userroles1_.RoleId as RoleId1_0_, userroles1_.RoleName as RoleName1_0_ > FROM [SnapData].[dbo].[aspnet_UsersInRole] allroles0_ left outer join > [SnapData].[dbo].[aspnet_Users] userroles1_ on > allroles0_.UserRoles_id=userroles1_.RoleId WHERE > allroles0_.UserPermission_id=?] > ----> System.Data.SqlClient.SqlException : Invalid object name > 'SnapData.dbo.aspnet_UsersInRole'. > > On Feb 8, 2:24 pm, James Gregory <jagregory....@gmail.com> wrote: >> Your UserPermission.allRoles is an List<T>, when it should be an IList<T>; >> that's why you're getting the conversion error. >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to fluent-nhibernate@googlegroups.com To unsubscribe from this group, send email to fluent-nhibernate+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en -~----------~----~----~----~------~----~------~--~---