Wow, really? Any other ideas what I might have configured incorrectly? It must be something, if James was getting the same issue.
On Sat, Mar 7, 2009 at 2:20 PM, Tuna Toksoz <[email protected]> wrote: > Your project. All selects are fine.. > > Tuna Toksöz > http://tunatoksoz.com > http://turkiyealt.net > http://twitter.com/tehlike > > Typos included to enhance the readers attention! > > > > On Sat, Mar 7, 2009 at 10:10 PM, Randy McCluer <[email protected]> wrote: > >> I have SP1. Not sure what tests you're running, can you send them? Are >> you able to get the following code to run in a test? >> >> using (ISession session = NHibernateHelper.OpenSession()) >> { >> DateTime d = DateTime.Now; >> List<PickPeriod> periods = >> session.Linq<PickPeriod>().Where(pp => pp.StartDate < d).ToList(); >> } >> >> I'm not having any trouble w/ INSERTs, so I don't think the issue you >> pointed out is the problem. >> >> >> On Sat, Mar 7, 2009 at 12:02 PM, Tuna Toksoz <[email protected]> wrote: >> >>> Because all tests are passing, except the two with the following error >>> >>> >>> NHibernate: INSERT INTO pool_PickPeriods (StartDate, EndDate, >>> LastGoodFeedDate, FeedLockInDate, Name, SeasonID) VALUES (@p0, @p1, @p2, >>> @p3, @p4, @p5); select SCOPE_IDENTITY(); @p0 = '3/7/2009 8:01:09 PM', @p1 = >>> '3/14/2009 8:01:09 PM', @p2 = '1/1/1900 12:00:00 AM', @p3 = '3/7/2009 >>> 8:01:09 PM', @p4 = 'week1', @p5 = '2007' >>> >>> System.Data.SqlClient.SqlException: The INSERT statement conflicted with >>> the FOREIGN KEY constraint "FK_pool_PickPeriods_pool_Seasons". The conflict >>> occurred in database "MvcTest", table "dbo.pool_Seasons", column 'SeasonID'. >>> The statement has been terminated. >>> >>> >>> >>> Tuna Toksöz >>> http://tunatoksoz.com >>> http://turkiyealt.net >>> http://twitter.com/tehlike >>> >>> Typos included to enhance the readers attention! >>> >>> >>> >>> On Sat, Mar 7, 2009 at 8:01 PM, Tuna Toksoz <[email protected]> wrote: >>> >>>> dO you have SP1 installed? it could be the reason. >>>> >>>> Tuna Toksöz >>>> http://tunatoksoz.com >>>> http://turkiyealt.net >>>> http://twitter.com/tehlike >>>> >>>> Typos included to enhance the readers attention! >>>> >>>> >>>> >>>> On Sat, Mar 7, 2009 at 7:51 PM, Randy McCluer <[email protected]>wrote: >>>> >>>>> Here's the sample. I rolled everything into the MVC app and the sample >>>>> call is in the index action on the Home controller. Hope this helps as I >>>>> really love the linq side of this! >>>>> >>>>> >>>>> On Sat, Mar 7, 2009 at 11:39 AM, Randy <[email protected]> wrote: >>>>> >>>>>> >>>>>> Sorry, wasn't tracking via email. Dummy reply to get it to my inbox. >>>>>> >>>>>> On Mar 7, 11:31 am, Tuna Toksoz <[email protected]> wrote: >>>>>> > Just send it as an attachment in your mail >>>>>> > >>>>>> > Tuna Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp:// >>>>>> twitter.com/tehlike >>>>>> > >>>>>> > Typos included to enhance the readers attention! >>>>>> > >>>>>> > On Sat, Mar 7, 2009 at 7:30 PM, Randy <[email protected]> wrote: >>>>>> > >>>>>> > > Nothing to do w/ DateTime, it happens for any query w/ any data >>>>>> type. >>>>>> > > Trying to pare the project down to something meaningful, but how >>>>>> do I >>>>>> > > attach it here? >>>>>> > >>>>>> > > On Mar 7, 11:00 am, Tuna Toksoz <[email protected]> wrote: >>>>>> > > > Can yo add the test project? I guess I know the problem. >>>>>> > >>>>>> > > > The problem can be the use of DateTime >>>>>> > >>>>>> > > > Try >>>>>> > >>>>>> > > > var date=DateTime.Now; >>>>>> > > > List<PickPeriod> periods = session.Linq<PickPeriod> >>>>>> > > > ().Where(pp => pp.StartDate < date).ToList(); >>>>>> > >>>>>> > > > Tuna Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp:// >>>>>> > > twitter.com/tehlike >>>>>> > >>>>>> > > > Typos included to enhance the readers attention! >>>>>> > >>>>>> > > > On Sat, Mar 7, 2009 at 6:55 PM, Randy <[email protected]> >>>>>> wrote: >>>>>> > >>>>>> > > > > Started over with the simplest configuration I could manage >>>>>> and still >>>>>> > > > > having this problem. Is there any configuration necessary for >>>>>> > > > > enabling NHibernate.Linq functionality that I may be missing? >>>>>> > >>>>>> > > > > I am making a simple call: >>>>>> > > > > using (ISession session = NHibernateHelper.OpenSession()) >>>>>> > > > > { >>>>>> > > > > List<PickPeriod> periods = >>>>>> session.Linq<PickPeriod> >>>>>> > > > > ().Where(pp => pp.StartDate < DateTime.Now).ToList(); >>>>>> > > > > } >>>>>> > >>>>>> > > > > Here's the stack trace for the exception: >>>>>> > >>>>>> > > > > [MappingException: No persister for: System.DateTime] >>>>>> > > > > NHibernate.Impl.SessionFactoryImpl.GetEntityPersister(String >>>>>> > > > > entityName) +144 >>>>>> > > > > >>>>>> NHibernate.Linq.Visitors.AssociationRewriteVisitor.VisitMemberAccess >>>>>> > > > > (MemberExpression expr) in >>>>>> E:\code\nHibernate\trunk\nhibernate\src >>>>>> > > > > \NHibernate.Linq\Visitors\AssociationRewriteVisitor.cs:53 >>>>>> > > > > NHibernate.Linq.ExpressionVisitor.Visit(Expression exp) in >>>>>> E:\code >>>>>> > > > > >>>>>> \nHibernate\trunk\nhibernate\src\NHibernate.Linq\ExpressionVisitor.cs: >>>>>> > > > > 66 >>>>>> > > > > NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit >>>>>> > > > > (Expression exp) in E:\code\nHibernate\trunk\nhibernate\src >>>>>> > > > > \NHibernate.Linq\Visitors\NHibernateExpressionVisitor.cs:33 >>>>>> > > > > >>>>>> NHibernate.Linq.ExpressionVisitor.VisitBinary(BinaryExpression b) >>>>>> > > > > in E:\code\nHibernate\trunk\nhibernate\src\NHibernate.Linq >>>>>> > > > > \ExpressionVisitor.cs:124 >>>>>> > > > > NHibernate.Linq.ExpressionVisitor.Visit(Expression exp) in >>>>>> E:\code >>>>>> > > > > >>>>>> \nHibernate\trunk\nhibernate\src\NHibernate.Linq\ExpressionVisitor.cs: >>>>>> > > > > 56 >>>>>> > > > > NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit >>>>>> > > > > (Expression exp) in E:\code\nHibernate\trunk\nhibernate\src >>>>>> > > > > \NHibernate.Linq\Visitors\NHibernateExpressionVisitor.cs:33 >>>>>> > > > > >>>>>> NHibernate.Linq.ExpressionVisitor.VisitLambda(LambdaExpression >>>>>> > > > > lambda) in >>>>>> E:\code\nHibernate\trunk\nhibernate\src\NHibernate.Linq >>>>>> > > > > \ExpressionVisitor.cs:313 >>>>>> > > > > NHibernate.Linq.ExpressionVisitor.Visit(Expression exp) in >>>>>> E:\code >>>>>> > > > > >>>>>> \nHibernate\trunk\nhibernate\src\NHibernate.Linq\ExpressionVisitor.cs: >>>>>> > > > > 70 >>>>>> > > > > NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit >>>>>> > > > > (Expression exp) in E:\code\nHibernate\trunk\nhibernate\src >>>>>> > > > > \NHibernate.Linq\Visitors\NHibernateExpressionVisitor.cs:33 >>>>>> > > > > NHibernate.Linq.ExpressionVisitor.VisitUnary(UnaryExpression >>>>>> u) in >>>>>> > > > > E:\code\nHibernate\trunk\nhibernate\src\NHibernate.Linq >>>>>> > > > > \ExpressionVisitor.cs:114 >>>>>> > > > > NHibernate.Linq.ExpressionVisitor.Visit(Expression exp) in >>>>>> E:\code >>>>>> > > > > >>>>>> \nHibernate\trunk\nhibernate\src\NHibernate.Linq\ExpressionVisitor.cs: >>>>>> > > > > 32 >>>>>> > > > > NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit >>>>>> > > > > (Expression exp) in E:\code\nHibernate\trunk\nhibernate\src >>>>>> > > > > \NHibernate.Linq\Visitors\NHibernateExpressionVisitor.cs:33 >>>>>> > > > > >>>>>> NHibernate.Linq.ExpressionVisitor.VisitList(ReadOnlyCollection`1 >>>>>> > > > > original) in >>>>>> E:\code\nHibernate\trunk\nhibernate\src\NHibernate.Linq >>>>>> > > > > \ExpressionVisitor.cs:200 >>>>>> > > > > NHibernate.Linq.ExpressionVisitor.VisitMethodCall >>>>>> > > > > (MethodCallExpression m) in >>>>>> E:\code\nHibernate\trunk\nhibernate\src >>>>>> > > > > \NHibernate.Linq\ExpressionVisitor.cs:185 >>>>>> > > > > NHibernate.Linq.ExpressionVisitor.Visit(Expression exp) in >>>>>> E:\code >>>>>> > > > > >>>>>> \nHibernate\trunk\nhibernate\src\NHibernate.Linq\ExpressionVisitor.cs: >>>>>> > > > > 68 >>>>>> > > > > NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit >>>>>> > > > > (Expression exp) in E:\code\nHibernate\trunk\nhibernate\src >>>>>> > > > > \NHibernate.Linq\Visitors\NHibernateExpressionVisitor.cs:33 >>>>>> > > > > NHibernate.Linq.Visitors.AssociationRewriteVisitor.Rewrite >>>>>> > > > > (Expression expr, ISessionFactoryImplementor factory) in >>>>>> E:\code >>>>>> > > > > \nHibernate\trunk\nhibernate\src\NHibernate.Linq\Visitors >>>>>> > > > > \AssociationRewriteVisitor.cs:29 >>>>>> > > > > NHibernate.Linq.Query.LinqTranslator.Translate() in E:\code >>>>>> > > > > \nHibernate\trunk\nhibernate\src\NHibernate.Linq\Query >>>>>> > > > > \LinqTranslator.cs:39 >>>>>> > > > > NHibernate.Linq.NHibernateQueryProvider.Execute(Expression >>>>>> > > > > expression) in >>>>>> E:\code\nHibernate\trunk\nhibernate\src\NHibernate.Linq >>>>>> > > > > \NHibernateQueryProvider.cs:27 >>>>>> > > > > NHibernate.Linq.Query`1.GetEnumerator() in >>>>>> E:\code\nHibernate\trunk >>>>>> > > > > \nhibernate\src\NHibernate.Linq\Query.cs:58 >>>>>> > > > > System.Collections.Generic.List`1..ctor(IEnumerable`1 >>>>>> collection) >>>>>> > > > > +7663302 >>>>>> > > > > System.Linq.Enumerable.ToList(IEnumerable`1 source) +61 >>>>>> > >>>>>> > > > > Also, in case it somehow matters the Helper is creating it's >>>>>> > > > > ISessionFactory with: >>>>>> > >>>>>> > > > > var configuration = new Configuration(); >>>>>> > >>>>>> > > > > configuration.Configure(); >>>>>> > >>>>>> > > > > configuration.AddAssembly(typeof >>>>>> > > > > (Season).Assembly); >>>>>> > >>>>>> > > > > _sessionFactory = >>>>>> configuration.BuildSessionFactory >>>>>> > > > > (); >>>>>> > >>>>>> > > > > On Mar 6, 2:00 pm, Tuna Toksoz <[email protected]> wrote: >>>>>> > > > > > The trunk code with latest NH trunk dll works perfectly >>>>>> fine. >>>>>> > >>>>>> > > > > > Tuna Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp:// >>>>>> > > > > twitter.com/tehlike >>>>>> > >>>>>> > > > > > Typos included to enhance the readers attention! >>>>>> > >>>>>> > > > > > On Fri, Mar 6, 2009 at 6:58 AM, Tuna Toksoz < >>>>>> [email protected]> >>>>>> > > wrote: >>>>>> > > > > > > I'll check it out today. >>>>>> > >>>>>> > > > > > > Tuna Toksöz >>>>>> > > > > > >http://tunatoksoz.com >>>>>> > > > > > >http://turkiyealt.net >>>>>> > > > > > >http://twitter.com/tehlike >>>>>> > >>>>>> > > > > > > Typos included to enhance the readers attention! >>>>>> > >>>>>> > > > > > > On Fri, Mar 6, 2009 at 5:34 AM, Randy <[email protected]> >>>>>> wrote: >>>>>> > >>>>>> > > > > > >> I've confirmed that this is an issue w/o Castle Windsor >>>>>> in the >>>>>> > > > > > >> pipeline. Is there some sort of configuration necessary >>>>>> for >>>>>> > > getting >>>>>> > > > > > >> LinqToHibernate to work? >>>>>> > >>>>>> > > > > > >> On Mar 5, 12:50 pm, Randy <[email protected]> wrote: >>>>>> > > > > > >> > Sorry that's on my box at home, but it's on trunk of >>>>>> nHibernate >>>>>> > > and >>>>>> > > > > > >> > LinqToNHIibernate as of last night. I am also using >>>>>> the Castle >>>>>> > > NH >>>>>> > > > > > >> > Facility on the latest build, if that may be part of >>>>>> the issue. >>>>>> > > I >>>>>> > > > > was >>>>>> > > > > > >> > planning on testing it without Castle tonite to further >>>>>> isolate >>>>>> > > the >>>>>> > > > > > >> > issue. I am very new to NH so I could be missing >>>>>> something >>>>>> > > basic >>>>>> > > > > > >> > here, but I was able to get NH and Castle running just >>>>>> fine >>>>>> > > until I >>>>>> > > > > > >> > tried integrating the Linq stuff. >>>>>> > >>>>>> > > > > > >> > Thanks! >>>>>> > >>>>>> > > > > > >> > On Mar 5, 4:19 am, Tuna Toksoz <[email protected]> >>>>>> wrote: >>>>>> > >>>>>> > > > > > >> > > Randy? >>>>>> > >>>>>> > > > > > >> > > Tuna >>>>>> Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp:// >>>>>> > > > > > >> twitter.com/tehlike >>>>>> > >>>>>> > > > > > >> > > Typos included to enhance the readers attention! >>>>>> > >>>>>> > > > > > >> > > On Thu, Mar 5, 2009 at 12:18 PM, Tuna Toksoz < >>>>>> > > [email protected]> >>>>>> > > > > > >> wrote: >>>>>> > > > > > >> > > > Trunk doesn't have any changes since february 6. >>>>>> > >>>>>> > > > > > >> > > > Which revision of NH are you using? >>>>>> > >>>>>> > > > > > >> > > > Tuna Toksöz >>>>>> > > > > > >> > > >http://tunatoksoz.com >>>>>> > > > > > >> > > >http://turkiyealt.net >>>>>> > > > > > >> > > >http://twitter.com/tehlike >>>>>> > >>>>>> > > > > > >> > > > Typos included to enhance the readers attention! >>>>>> > >>>>>> > > > > > >> > > > On Thu, Mar 5, 2009 at 6:24 AM, Randy < >>>>>> [email protected]> >>>>>> > > > > wrote: >>>>>> > >>>>>> > > > > > >> > > >> I'm getting the same exception w/ trunk as of 3/4. >>>>>> Anyone >>>>>> > > have >>>>>> > > > > any >>>>>> > > > > > >> > > >> ideas? >>>>>> > >>>>>> > > > > > >> > > >> On Feb 24, 4:34 pm, James Crowley < >>>>>> [email protected] >>>>>> > >>>>>> > > > > wrote: >>>>>> > > > > > >> > > >> > I'm workingagainst the current trunk of >>>>>> nhibernate and >>>>>> > > > > > >> nhibernate.linq. >>>>>> > > > > > >> > > >> > Accessing my data via the standard query methods >>>>>> is fine, >>>>>> > > but >>>>>> > > > > > >> when going >>>>>> > > > > > >> > > >> via >>>>>> > > > > > >> > > >> > the linq2hibernate provider, I'm getting a >>>>>> > > MappingException >>>>>> > > > > > >> stating "No >>>>>> > > > > > >> > > >> > persister for: System.*" where * is whatever the >>>>>> first >>>>>> > > > > System.* >>>>>> > > > > > >> type >>>>>> > > > > > >> > > >> that >>>>>> > > > > > >> > > >> > appears in my entity. >>>>>> > >>>>>> > > > > > >> > > >> > The line where it goes wrong is in >>>>>> VisitMemberAccess of >>>>>> > > > > > >> > > >> > AssociationRewriteVisitor >>>>>> > >>>>>> > > > > > >> > > >> > IPropertyMapping mapping = >>>>>> > > > > > >> > > >> > >>>>>> sessionFactory.GetEntityPersister(expr.Type.FullName) as >>>>>> > > > > > >> > > >> IPropertyMapping; >>>>>> > >>>>>> > > > > > >> > > >> > and it's trying to find an entity persister for >>>>>> > > > > "System.String", >>>>>> > > > > > >> > > >> > "System.Bool" etc. >>>>>> > >>>>>> > > > > > >> > > >> > Any ideas? Am I doing something wrong? >>>>>> > >>>>>> > > > > > >> > > >> > Thanks, >>>>>> > >>>>>> > > > > > >> > > >> > James >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>> >>> >>> >>> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
