Hi Diego, Sorry about my description. You have already answered my question.
Many thanks. Daoming On 6 April 2010 13:23, Diego Mijelshon <[email protected]> wrote: > Daoming, > > I don't understand your question. session.CreateSQLQuery("spName") or > session.CreateSQLQuery("exec spName") work fine. > > Diego > > > On Tue, Apr 6, 2010 at 09:05, Daoming Yang <[email protected]>wrote: > >> *Hi Diego, * >> >> Thank you very much. You have given me the answer. I have implemented >> the *session.CreateSQLQuery(...).ExecuteUpdate()* . >> >> As you know I will come up another question. Is any other way to user the >> session to execute the Stored Procedures? >> >> *Hi Visar, * >> >> It's a good article, but I have not tried that. >> >> Many thanks. >> >> Daoming >> >> >> >> >> On 6 April 2010 12:20, Visar Uruqi <[email protected]> wrote: >> >>> Hello >>> >>> I am interested also to know if there is a way with Nhibernate >>> to backup up your DB, regardless the RDBMS your app sits on. >>> >>> I've found this link in top ten of google search results >>> http://www.jroller.com/ara_e/entry/backup_restore_to_from_xml >>> >>> The guy says that there is an object called "XMLDatabinder" in >>> Hibernate >>> the Java port, and it does all the magic, loads your objects into XML >>> and ... >>> >>> I did not found the XMLDatabinder in Nhibernate, is this possible >>> what he said in his article with Nhibernate? >>> >>> Visar >>> >>> On Apr 5, 7:28 pm, Diego Mijelshon <[email protected]> wrote: >>> > Daoming, >>> > >>> > Backup and admin scripts are not NH concerns. >>> > >>> > What you CAN do is execute a SQL script like that using >>> > session.CreateSQLQuery(...).ExecuteUpdate() or get the connection with >>> > session.Connection and create your command from there. >>> > >>> > Diego >>> > >>> > On Mon, Apr 5, 2010 at 14:13, Daoming Yang <[email protected] >>> >wrote: >>> > >>> > >>> > >>> > > Hi Everyone, >>> > >>> > > I need to create a database back function for the normal user by >>> using the >>> > > web application. >>> > >>> > > How can I run the following sample script in NHibernate or maybe you >>> have a >>> > > better solution to do the full database backup? >>> > >>> > > BACKUP DATABASE [AdventureWorks] TO >>> > > DISK = >>> N'\\nas\Backup\L40\SQL2005\AdventureWorks_backup_200702120215.bak' >>> > > WITH NOFORMAT, NOINIT, NAME = N'AdventureWorks-Full Database >>> Backup', >>> > > SKIP, NOREWIND, NOUNLOAD, STATS = 10 >>> > >>> > > Thank you very much. >>> > >>> > > Daoming >>> > >>> > > -- >>> > > 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]> >>> <nhusers%[email protected]<nhusers%[email protected]>> >>> > > . >>> > > For more options, visit this group at >>> > >http://groups.google.com/group/nhusers?hl=en. >>> >>> -- >>> 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. >>> >>> >> -- >> 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. >> > > -- > 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. > -- 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.
