For executing DML you'll have to use NH Session directly to create the HQL
query and call ExecuteUpdate() on it.
When using ActiveRecord you can obtain a NH session like this:
var session = SessionScope.Current.GetSession(typeof (ActiveRecordBase));
,or
var session =
ActiveRecordMediator.GetSessionFactoryHolder().CreateSession(typeof(User))
and then session.CreateQuery("update User usr set usr.Login= 'Test' ").*
ExecuteUpdate()*;
-- Roelof.
On Tue, Sep 15, 2009 at 5:24 PM, Gustavo Melo <[email protected]> wrote:
> Gerdus,
>
> Thanks for your reply...
>
> But now...
> *Not supported for DML operations*I try find some on web (Ayende Blog) but
> it's very hard to make this work...
>
> I have a reference of Antlr3.Runtime.dll on my project.
>
> I almost given up :(
>
> On Tue, Sep 15, 2009 at 11:45 AM, Gerdus van Zyl
> <[email protected]>wrote:
>
>>
>> I think it should be:
>>
>> SimpleQuery query = new SimpleQuery(typeof(User), "update User usr set
>> usr.Login= 'Test' ");
>>
>> Case matters and you have to use the defined property name.
>>
>> ~Gerdus
>>
>> On Tue, Sep 15, 2009 at 4:16 PM, Gustavo Melo <[email protected]> wrote:
>> > Thanks Gauthier,
>> >
>> > But i'm still have a trouble with that...
>> >
>> > I try something like that:
>> >
>> > [ActiveRecord("user")]
>> > public class User : ActiveRecordBase
>> > {
>> > [PrimaryKey(PrimaryKeyType.Assigned, "usu_id")]
>> > public string Id { get; set; }
>> >
>> > [Property("name", NotNull = true)]
>> > public string Login { get; set; }
>> >
>> > public void updateAllUsers()
>> > {
>> > SimpleQuery query = new SimpleQuery(typeof(User), "update
>> user
>> > set name = Test");
>> >
>> > ExecuteQuery(query);
>> > }
>> > }
>> >
>> > When i call updateAllUsers: Could not perform ExecuteQuery for Usuario
>> >
>> > user is not mapped [update user set name = 'Test']
>> >
>> > All CRUD's operations work fine, but i don't know how to use HQL.
>> >
>> >
>> > On Tue, Sep 15, 2009 at 2:38 AM, Gauthier Segay <
>> [email protected]>
>> > wrote:
>> >>
>> >> Best way is executing an update HQL statement:
>> >>
>> >>
>> >>
>> http://ayende.com/Blog/archive/2009/05/28/nhibernate-ndash-executable-dml.aspx
>> >>
>> >> using the execute callback is the straight forward way:
>> >>
>> >>
>> >>
>> http://www.castleproject.org/ActiveRecord/documentation/v1rc1/usersguide/hql.html
>> >>
>> >> On Sep 14, 9:43 pm, Gustavo Melo <[email protected]> wrote:
>> >> > I have a table (user)
>> >> >
>> >> > [ActiveRecord("user")]
>> >> > public class User : ActiveRecordBase
>> >> > {
>> >> > [PrimaryKey(PrimaryKeyType.Assigned, "usu_id")]
>> >> > public string Id { get; set; }
>> >> >
>> >> > [Property("name", NotNull = true)]
>> >> > public string Login { get; set; }
>> >> >
>> >> > }
>> >> >
>> >> > How do i update all users in the table for name = "Test" ?
>> >> >
>> >> > I didn't find on web or documantation...
>> >> >
>> >> > Some1 can help me?
>> >> >
>> >> > Best Regards
>> >>
>> >
>> >
>> >
>> > --
>> > Analista Desenvolvedor
>> > www.espacodj.com
>> >
>> > >
>> >
>>
>>
>>
>
>
> --
> Analista Desenvolvedor
> www.espacodj.com
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" 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/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
