Converting SQL Script into VB.Net Code

[Tyecom]

I trying the find a way to hook this SQL script into .Net code. The script will prompt the users the insert a USB drive into Drive D:\ and then proceed to back myDatabase. Can anyone help me convert this into .Net Code?

--Create a differential database backup.
BACKUP DATABASE eFB TO DISK = 'F:\EFB\EFBSave.bak'
WITH DIFFERENTIAL;


Thanks in advance.

 

[cjard]

huh? you mean you want to execute that SQL? Try asking in the SQL Server forum

 

[rfaricy]

SQL and .NET are completely different. .NET can USE SQL statements inside objects which can manipulate a database, but you can't just convert SQL to .NET code. You can use your above statement and directly pass it to a database object, however, which will accomplish the same thing.

 

[Tyecom]

Thank you.