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].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
