Yes, if I just specify the the table name, sometimes the DB likes me and will find the table other times it will not like me and tell me the table is not found. I get this with linq-sql too. This is not a fluent issue. Therefore if I specify the full db.schema.table I do not have an issue about access.
On Feb 9, 7:43 am, James Gregory <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> wrote: > >> Your UserPermission.allRoles is an List<T>, when it should be an IList<T>; > >> that's why you're getting the conversion error.- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Fluent NHibernate" 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/fluent-nhibernate?hl=en -~----------~----~----~----~------~----~------~--~---
