Delete and copy database sqlite C#

Question

5.00/5 (1 vote)

See more:

I programmed a c# application with sqlite database.I saved the address of database in setting of project as string :

Data Source=bazarganidb.db;version=3

and i use it in my program as below:

SQLiteConnection con = new SQLiteConnection(Properties.Settings.Default.ConnectionString);

now how can i delete this database and replace with another database to restore backuped database?

What I have tried:

I backuped my database with this code:

private void button1_Click(object sender, EventArgs e)        
{   
using (var source = new SQLiteConnection("Data 
Source=bazarganidb.db;version=3"))
using (var destination = new SQLiteConnection("Data Source=" + textBox1.Text + "/" + DateTime.Now.ToString("yyyyMMdd") + "backup.db"))
    {
        source.Open();
        destination.Open();
        source.BackupDatabase(destination, "main", "main", -1, null, 0);
    }
}

but i dont know about restoring

Posted 4-Nov-17 19:53pm

Member 11727674

Updated 4-Nov-17 20:04pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2017-11-04T20:04:00

Solution 1

SQLite databases are a single file on disk, so just copy the file for backup, and delete it when you don't want it, there is no need for using SQlitexxx interface.

Posted 4-Nov-17 20:04pm

Mehdi Gholam

Comments

Member 11727674 6-Nov-17 4:47am

thanks but i dont know why when i'm delete and copy the backup into debug folder nothing happen and its just for debug folder it hasn't any problem with another folders.can you help me about it?

Mehdi Gholam 6-Nov-17 4:52am

What is the error?
Make sure the file is not open.

Member 11727674 6-Nov-17 5:15am

i updated code to this but no error or exception just nothing happen
try
{
string FileToReplace = System.IO.Path.Combine(System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase), "bazarganidb.db");
File.Delete(FileToReplace);
string OriginalFile =@"D:\bazarganidb.db";
if(File.Exists(FileToReplace))
File.Delete(FileToReplace);
File.Copy(OriginalFile, FileToReplace,true);
}
catch (Exception k)
{
Console.WriteLine(k);
}

Mehdi Gholam 6-Nov-17 5:17am

What is the value for FileToReplace ?

Member 11727674 6-Nov-17 5:20am

FileToReplace is the path of file bazargani.db that there is in debug folder of my project and i want to be delete and copy file @"D:\bazarganidb.db" instead of that

Mehdi Gholam 6-Nov-17 5:22am

What does the debugger say the value is?

Member 11727674 6-Nov-17 5:26am

debuger says its null :|

Mehdi Gholam 6-Nov-17 5:39am

Try : Path.GetDirectoryName(Assembly.GetEntryAssembly().Location)

Member 11727674 6-Nov-17 5:43am

also return null

Mehdi Gholam 6-Nov-17 5:46am

Debug and see which part is null, the above cannot be null, you are making a mistake.

Member 11727674 6-Nov-17 5:53am

yes i was wrong i got an exception URI format are not supported