Roelof, Works perfect...
*Thank you all of you guys for your time.* On Tue, Sep 15, 2009 at 3:18 PM, Roelof Blom <[email protected]> wrote: > 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 >> >> >> > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
