Restore sqlite database in C#

Question

0.00/5 (No votes)

See more:

I programmed a c# application that can work on any other computer so i used from sqlite database.I want to backup and restore data in this app.for backup it's ok.I use from below code:

C#

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 restore.how can i restore the database wichi backuped? I searche alot but no result.

I added bellow code to delete sqlite file of befor and copy new database that is in drive d.but when i click button nothing happen and no error or exception.but if i copy the file to another folder excep debug every thinng is ok.but my firs db is in debug folder and it should be change from here

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";
                
                
                //string FileToReplace = @"E:\BazarganiProj2\BazarganiProj\bin\Debug\bazarganidb.db";

                if(File.Exists(FileToReplace))
                File.Delete(FileToReplace);
                File.Copy(OriginalFile, FileToReplace,true);
               }
            catch (Exception k)
            {
                Console.WriteLine(k);
            }

What I have tried:

i searched alot but no result

Posted 4-Nov-17 10:26am

Member 11727674

Updated 5-Nov-17 23:11pm

v4

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)

Graeme_Grant · Accepted Answer · 2017-11-04T13:58:00

SQLITE is a single-user local file based DB unlike multi-user server based DB systems, like MySql, Sql Server, etc... it is far less restrictive.

So, if it is a complete backup/restore, simply rename to backup, and delete & rename to restore.

UPDATE: Here is a quick example of how to do it:

C#

class Program
{
    private static readonly string filePath = Environment.CurrentDirectory;

    static void Main(string[] args)
    {
        var filename = "mock.db";
        var bkupFilename = Path.GetFileNameWithoutExtension(filename) + ".bak";

        CreateDB(filePath, filename);

        BackupDB(filePath, filename, bkupFilename);
        RestoreDB(filePath, bkupFilename, filename, true);
    }

    private static void RestoreDB(string filePath, string srcFilename, string destFileName, bool IsCopy = false)
    {
        var srcfile = Path.Combine(filePath, srcFilename);
        var destfile = Path.Combine(filePath, destFileName);

        if (File.Exists(destfile)) File.Delete(destfile);

        if (IsCopy)
            BackupDB(filePath, srcFilename, destFileName);
        else
            File.Move(srcfile, destfile);
    }

    private static void BackupDB(string filePath, string srcFilename, string destFileName)
    {
        var srcfile = Path.Combine(filePath, srcFilename);
        var destfile = Path.Combine(filePath, destFileName);

        if (File.Exists(destfile)) File.Delete(destfile);

        File.Copy(srcfile, destfile);
    }

    private static void CreateDB(string filePath, string filename)
    {
        var fullfile = Path.Combine(filePath, filename);
        if (File.Exists(fullfile)) File.Delete(fullfile);

        File.WriteAllText(fullfile, "this is the dummy data");
    }
}