[nhusers] Re: MySQL SchemaUpdate error

2009-03-16 Thread Sushant
Has this been applied to MSSQLCE and SQLite? I'm getting exactly the same error on both when I use SchemaUpdate.. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email

[nhusers] Re: MySQL SchemaUpdate error

2009-03-16 Thread Sushant
Has this been applied to MS SQL (Compact Edition) or SQLite ? With SchemaUpdate.Execute I get exactly the same error using both these datatypes.. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "nhusers" group. To po

[nhusers] Re: nHibernate SetFirstResult & SetMaxResults Problems

2009-03-16 Thread Craig van Nieuwkerk
I have created a test project that shows two issues. You can get it from http://www.baseestate.com/downloads/testproject1.zip. You will have to change some settings in app.config probably to get it to run but I am sure it won't take long. Craig. On Tue, Mar 17, 2009 at 2:11 PM, Dario Quintana w

[nhusers] Re: nHibernate SetFirstResult & SetMaxResults Problems

2009-03-16 Thread Craig van Nieuwkerk
I will do so including the joined subclass problem. On Tue, Mar 17, 2009 at 2:11 PM, Dario Quintana wrote: > Could you create a TestCase and send us ? Would be a great help to see the > problem > > On Mon, Mar 16, 2009 at 11:49 PM, Craig van Nieuwkerk > wrote: >> >> It could be related to this

[nhusers] Re: nHibernate SetFirstResult & SetMaxResults Problems

2009-03-16 Thread Dario Quintana
Could you create a TestCase and send us ? Would be a great help to see the problem On Mon, Mar 16, 2009 at 11:49 PM, Craig van Nieuwkerk wrote: > > It could be related to this other problem from the other day that I > have yet to fix "Joined subclass problem". > > The sql in the log that is gener

[nhusers] Re: nHibernate SetFirstResult & SetMaxResults Problems

2009-03-16 Thread Craig van Nieuwkerk
It could be related to this other problem from the other day that I have yet to fix "Joined subclass problem". The sql in the log that is generated is. INFO 2009-03-17 12:49:00,183 27480ms Loader GetResultSet - select author0_.id as id0_, author0_1_.name as name0_, author0_.country as cou

[nhusers] Re: nHibernate SetFirstResult & SetMaxResults Problems

2009-03-16 Thread Dario Quintana
Into your log4net configuration you can paste this to see what actually NH is generating ... ... On Mon, Mar 16, 2009 at 11:01 PM, Craig van Nieuwkerk wrote: > > I am using nHibernate and trying to implement some paging. If I run this > code > >IList list = session.CreateQuery("FROM

[nhusers] Re: nHibernate SetFirstResult & SetMaxResults Problems

2009-03-16 Thread Craig van Nieuwkerk
It is on the trunk with SQL Server. The queries below are the exact code I am running. On Tue, Mar 17, 2009 at 1:36 PM, Will Shaver wrote: > > Can you paste the actual queries? What DB are you using? Is this on the trunk? > > On Mon, Mar 16, 2009 at 7:01 PM, Craig van Nieuwkerk > wrote: >> >>

[nhusers] Re: nHibernate SetFirstResult & SetMaxResults Problems

2009-03-16 Thread Will Shaver
Can you paste the actual queries? What DB are you using? Is this on the trunk? On Mon, Mar 16, 2009 at 7:01 PM, Craig van Nieuwkerk wrote: > > I am using nHibernate and trying to implement some paging. If I run this code > >    IList list = session.CreateQuery("FROM Author").List(); > > it retur

[nhusers] nHibernate SetFirstResult & SetMaxResults Problems

2009-03-16 Thread Craig van Nieuwkerk
I am using nHibernate and trying to implement some paging. If I run this code IList list = session.CreateQuery("FROM Author").List(); it returns 8 records. If I run this code though IList list = session.CreateQuery("FROM Author") .SetFirstResult(1).SetMaxResults(5).List(); it r

[nhusers] How can I get the Entity in the OnDirtyCheck event?

2009-03-16 Thread mhnyborg
The PostLoadEvent has an entity as an property, but the OnDirtyCheck has Session and IsDirty. What is the purpose of this event? I have implemented dirty tracking and IsNew, IsDeleted on the entites and I am using them in a Silverlight app. I just want to tell NH which object to save, update and

[nhusers] Re: Sql Server Execution Plans / Parameter Size

2009-03-16 Thread Dario Quintana
BTW, thanks to Claudio Maccari we have write it down http://nhforge.org/wikis/howtonh/tuning-queries-with-ms-sqlserver.aspx On Mon, Mar 16, 2009 at 12:52 AM, Fabio Maulo wrote: > 2009/3/15 Dario Quintana > >> Here it says, that there is no reason to call it in the client application >> where us

[nhusers] Re: Fetching only base type objects in nHibernate

2009-03-16 Thread Fabio Maulo
2009/3/16 James Crowley > I asked a similar question a few days ago. > > Fabio Maulo said: You can call me "Fabio" or "Brutus" ;) -- Fabio Maulo P.S. I don't know why but, apparently, there aren't so many "Fabio" between NH's users. --~--~-~--~~~---~--~~ You

[nhusers] Re: Mapping question - how to Map fixed element List as part of parent

2009-03-16 Thread Fabio Maulo
2009/3/16 Ramana Kumar > If I use a list of components, the properties of the component (Par and > Handicap) would end up in the child table. Which is what I am trying to > avoid. > Ok, so... you don't have other option than . or better... in this moment nothing more than that come in my m

[nhusers] Re: Fetching only base type objects in nHibernate

2009-03-16 Thread Maciej Paszta
Fabio Maulo wrote: from Base b where b.class = Base Yeh, it's working. I've previously tried it but got errors that there's no such property. It seems that ".class" is only available when there are in fact any subclasses of the given one smime.p7s Description: S/MIME Cryptographic Signature

[nhusers] Re: Mapping question - how to Map fixed element List as part of parent

2009-03-16 Thread Ramana Kumar
Hi Fabio I looked up the NHibernate in Action and did a quick google search. I might be missing somthing obvious here If I use a list of components, the properties of the component (Par and Handicap) would end up in the child table. Which is what I am trying to avoid. Ramana On Mon, Mar 16,

[nhusers] Re: how to map a collection of items that have composite ids

2009-03-16 Thread epitka
Ok I'll try to explain this little bit better. Basically I have two tables (Client), that has surrogate PK key "ClientID" and Client has natural key composed of ClientID and EffectiveDate. How do I map a collection in Client that has all items for ClientID. On Mar 16, 11:54 am, epitka wrote: > H

[nhusers] Re: Mapping question - how to Map fixed element List as part of parent

2009-03-16 Thread Fabio Maulo
list of 2009/3/16 Ramana Kumar > Hi > I have a mapping question and I could use some help > > In my GolfHandicapManager system, I have a domain object called Course. I > want to have Par and Handicap assigned to each hole of the course (i.e hole > 1 is Par 4 and Handicap 7, Hole 2 is Par 5 an

[nhusers] Mapping question - how to Map fixed element List as part of parent

2009-03-16 Thread Ramana Kumar
Hi I have a mapping question and I could use some help In my GolfHandicapManager system, I have a domain object called Course. I want to have Par and Handicap assigned to each hole of the course (i.e hole 1 is Par 4 and Handicap 7, Hole 2 is Par 5 and Handicap 14 etc). I have the following optio

[nhusers] Re: how to map a collection of items that have composite ids

2009-03-16 Thread epitka
A new error now ---> NHibernate.MappingException: collection foreign key mapping has wrong number of columns: SR.Domain.Client.Entities.Client.AccountTypeHistory type: Int32 On Mar 16, 12:33 pm, epitka wrote: > Figured it out, was missing property-ref in key. > > On Mar 16, 11:54 am, epitka wr

[nhusers] Re: how to map a collection of items that have composite ids

2009-03-16 Thread epitka
Figured it out, was missing property-ref in key. On Mar 16, 11:54 am, epitka wrote: > Hi, I am trying to map a collection (bag) or items that have composite > id. The mapping I have throws an error saying that > >  NHibernate.FKUnmatchingColumnsException: Foreign key > (FK6A7D859A4C8DCC7F:Client

[nhusers] Can a stateless session and regular session share a transaction ?

2009-03-16 Thread ccollie
Question in subject. Here's the scenario : Event 1 --* Occurrence Occurrences can be many, so i want to persist using stateless session, but i want to rollback in case of errors. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the

[nhusers] how to map a collection of items that have composite ids

2009-03-16 Thread epitka
Hi, I am trying to map a collection (bag) or items that have composite id. The mapping I have throws an error saying that NHibernate.FKUnmatchingColumnsException: Foreign key (FK6A7D859A4C8DCC7F:ClientAcctType [ClientId, EffectiveDate])) must have same number of columns as the referenced primary

[nhusers] Re: How to use registerfunction to add "NewID()" to the 2005 dialect

2009-03-16 Thread Dario Quintana
Map the NewID() function to a property into your object, then order-by for that property. On Mon, Mar 16, 2009 at 12:39 PM, rsadams wrote: > > Hi All, > > I'm currently trying to add a "more like this" function to my website, > this requires that I pull records ordered by NewID.. If I was using

[nhusers] How to use registerfunction to add "NewID()" to the 2005 dialect

2009-03-16 Thread rsadams
Hi All, I'm currently trying to add a "more like this" function to my website, this requires that I pull records ordered by NewID.. If I was using SQL I'd do this.. SELECT TOP 5 * FROM video ORDER BY NEWID() But it seems that NewID is not a part of the MSSql2005 dialect? So to add it I' have th

[nhusers] Re: Read and Insert/Update from two different databases

2009-03-16 Thread caiokf
i'll give it a try. thank you On 16 mar, 11:46, Markus Zywitza wrote: > With ActiveRecord (based on NHibernate), I'd use DifferentDatabaseScope to > do it. The principle is to have two sessions, one for the MsSql on one for > the Firebird. You have to detach the changed objects from the first se

[nhusers] Re: Read and Insert/Update from two different databases

2009-03-16 Thread Markus Zywitza
With ActiveRecord (based on NHibernate), I'd use DifferentDatabaseScope to do it. The principle is to have two sessions, one for the MsSql on one for the Firebird. You have to detach the changed objects from the first session and attach them to the other. Best approach with NH would be a repository

[nhusers] Re: Fetching only base type objects in nHibernate

2009-03-16 Thread Fabio Maulo
from Base b where b.class = Base 2009/3/14 paszczi > > > > Hello! > > I'm currently trying to solve a problem. I have a class table > inheritance aka table-er-subclass (one main table + several others > with additional data). In my app both base object instances and > extended objects can exist.

[nhusers] Re: Loading collections (bag) efficiently

2009-03-16 Thread Davy Brion
oh right... the trick works better for many-to-one's instead of one-to-many's ;) On Mon, Mar 16, 2009 at 9:45 AM, Thomas Koch wrote: > > Hi Davy - neat trick. :-) > > But if I did that would I not have to avoid the use of a of B's > in my A entity ? > > Thomas > > > > On 15 Mar., 19:23, Davy B

[nhusers] Re: Fetching only base type objects in nHibernate

2009-03-16 Thread James Crowley
I asked a similar question a few days ago. Fabio Maulo said: 2 paths...polymorphism="explicit" (but you must deal with it if then you want a poly-query) entity-name (allow you duplicated mapping of same class... to "solve" the first path ;) ) Hope that helps 2009/3/14 paszczi > > > > Hello! >

[nhusers] Read and Insert/Update from two different databases

2009-03-16 Thread caiokf
is there a way to map a class to read from one db an insert/update to another? or do I have to create two classes? ...why I want to do that ? I'm working on a system using a Firebird db, which is used by another 3 applications that I don't have access to the source. We also have a SqlServer db w

[nhusers] Re: Loading collections (bag) efficiently

2009-03-16 Thread Thomas Koch
Hi Davy - neat trick. :-) But if I did that would I not have to avoid the use of a of B's in my A entity ? Thomas On 15 Mar., 19:23, Davy Brion wrote: > depending on the size of the joined resultset, you might want to look into > using MultiCriteria/MultiQuery (or Future if you're using tr