Thank you for reply!
Why does NHibernate generate unsupported by targer database requests?
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider</
property>
<property name="dialect">NHibernate.Dialect.MsSqlCeDialect</
property>
<property
name="connection.driver_class">NHibernate.Driver.SqlServerCeDriver</
property>
<property name="connection.connection_string">Data Source=C:\lib
\docs\helpdesk\Helpdesk\planneddebtorsrollcall.sdf</property>
<property
name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory,
NHibernate.ByteCode.Castle</property>
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>
Thanks!
On Jul 15, 7:53 pm, cliff vaughn <[email protected]> wrote:
> http://www.lmgtfy.com/?q=sql+server+ce+and+nested+selects
>
>
>
> On Thu, Jul 15, 2010 at 12:11 AM, alexey_baranov <[email protected]> wrote:
> > Hello!
>
> > Is anybody know why this simple query doesn't run on SQL Server CE ?
>
> > SELECT Namee
> > FROM Obj AS p
> > WHERE ((SELECT COUNT(Parent) AS Expr1
> > FROM Obj AS c
> > WHERE (p.Id = Parent)) > 0)
>
> > As you can see I trying to get all nodes wich have at least one child.
> > Query is generated by NHibernate
>
> > session.CreateQuery("select p.Name from Obj as p where
> > size(p.Children)>0")
> > .List();
>
> > Thanks!
>
> > --
> > 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]<nhusers%[email protected]>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/nhusers?hl=en.
>
> --
> thanks
>
> cliff
--
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.
