[fluent-nhib] Problem with Mapping a User-Permission Table

2011-02-25 Thread TheNephalim
I want to start with the fact that this is a legacy system. I have three tables: TItemList TItemListID (PK) SystemUser SystemUserID (PK) TItemListPerm TItemListPermID TItemListUserPerm TItemList

[fluent-nhib] Re: Lazy Loading and Properties

2010-02-01 Thread TheNephalim
entirely, but my approach to exposing > >> collections is to make the getter an IEnumerable: > > >> public class Foo > >> { > >>   private List _bars { get; set; } > > >>   public IEnumerable Bars > >>   { > >>     get { return _bars; } > >>

[fluent-nhib] Re: Limiting the Number of Records Returned in a Mapping

2010-01-29 Thread TheNephalim
I'll start down the path of finding > out why. I really wouldn't worry about it at this point. I return 5000 heavy > objects in some associations and it's barely a blip on the radar in terms of > speed impact. > > On Fri, Jan 29, 2010 at 10:18 AM, TheNephalim > wr

[fluent-nhib] Re: Lazy Loading and Properties

2010-01-29 Thread TheNephalim
return _logins.Count(); > > } > > That will keep your collection lazy loaded until you actually need to do > something like a for each and iterate over it. > 5.) Grab nhprofiler. This is one of the single best tools for finding bottle > necks in your application. > > On Fri

[fluent-nhib] Limiting the Number of Records Returned in a Mapping

2010-01-29 Thread TheNephalim
This is another issue that I'm working on and, unlike the previous one, I don't have a solution for it. The issue is that I have a property on my parent object, User, and the property is called Logins. Logins represents a collection of Login information that includes when the user logged in, ip ad

[fluent-nhib] Lazy Loading and Properties

2010-01-29 Thread TheNephalim
I have several issues that I'm working on, because I'm a newbie at this, and wanted to address the one that I "solved" first. The problem was that I was noticing that all of my collections were not loading lazily, no matter what I did to mark them as such. It then dawned on me that the problem wa

[fluent-nhib] Re: Link Table of Same Type

2010-01-18 Thread TheNephalim
tree/self-referencing-...>There > is a download source link if you just want a zip and don't want to fool > around with git. > > Paul. > > On Sat, Jan 16, 2010 at 1:44 AM, TheNephalim wrote: > > > Still a "No go." > > > Theoretically, it should w

[fluent-nhib] Re: Link Table of Same Type

2010-01-15 Thread TheNephalim
Still a "No go." Theoretically, it should work, but I think that the issue is that the items that are composing the many-to-many relationship are of the same type. If, for example, I had a separate entity called Sponsor with its own data and linked the Sponsors to the Users in the UserSponsor tab

[fluent-nhib] Re: Need Advise: Parent-Child Mapping

2010-01-14 Thread TheNephalim
There is a thread here that you might also find useful: http://www.mail-archive.com/fluent-nhibernate@googlegroups.com/msg01158.html I also had to implement a tree, but my structure was contained within one table and not two. On Jan 14, 3:50 am, Ton wrote: > Hi there. We are trying to implement

[fluent-nhib] Re: Link Table of Same Type

2010-01-14 Thread TheNephalim
I feel completely stupid now. I changed the type in the User class from User to UserSponsor. When I run it, I get a list that includes the User information and the Sponsor information. Thanks again for your help. -Robert Eberhart On Jan 14, 12:16 pm, TheNephalim wrote: > Thanks for y

[fluent-nhib] Re: Link Table of Same Type

2010-01-14 Thread TheNephalim
       .Table("UserSponsor") >                .ParentKeyColumn("SponsorId") >                .ChildKeyColumn("UserId") >                .AsBag(); > > Now FNH shouldn't complain about not being able to find the other side. That > mapped SponsoredUsers p

[fluent-nhib] Re: Link Table of Same Type

2010-01-13 Thread TheNephalim
n when FNH can't find the other side of a > relationship, usually due to there being some ambiguity in the naming of > collections. Sounds like we either need to be smarter, or stop throwing that > exception. > > On Wed, Jan 13, 2010 at 1:42 PM, TheNephalim wrote: > > > M

[fluent-nhib] Re: Link Table of Same Type

2010-01-13 Thread TheNephalim
ponsors) >                .Table("UserSponsor") >                .ParentKeyColumn("UserId") >                .ChildKeyColumn("SponsorId") >                .AsBag(); > > On Wed, Jan 13, 2010 at 6:35 AM, TheNephalim wrote: > > > Hello, > > > I&

[fluent-nhib] Link Table of Same Type

2010-01-12 Thread TheNephalim
Hello, I'm a little confused about how to resolve this situation. I have two tables: User and UserSponsor. User is a table of users for our site. A user can have multiple sponsors. The UserSponsor table has two foreign keys UserId and SponsorId. SponsorId actually points back to the User tab

[fluent-nhib] Entity to Table Mapping

2009-12-25 Thread TheNephalim
Hello, I'm new to Fluent NHibernate and I'm trying it out against our database at work. I keep getting an error stating, "There is already a tabled named 'MenuItem' in the database." I'm not quite sure what I am doing wrong. If I set the CreateSchema parameters both to false, I do no get this e