Attaching a database in Sqlite using .NET not working

Question

I created a helper class for Sqlite in C# (using Data.SQLite) where I am putting methods like GetTables,GetColumnNames,...

Now I added method AttachDatabase to attach a database but it does not seem to be working.

The code for this method is as follows

    public void AttachDatabase(string path)
    {
        string db_name = "attdb";
        sqlConnection.Open();

        SQLiteCommand scom = new SQLiteCommand(sqlConnection);
        scom.CommandText = "ATTACH '"+path+"' AS " + db_name;

        scom.ExecuteNonQuery();

        sqlConnection.Close();
    }

The method does not throw any exceptions, when I provide a path to a database file.

And to test it I added another method in helper class that is like this

    public List<string> GetAllDatabases()
    {
        List<string> mylist = new List<string>();

        sqlConnection.Open();
        SQLiteCommand scom = new SQLiteCommand("PRAGMA database_list", sqlConnection);
        SQLiteDataReader sreader = scom.ExecuteReader();

        while (sreader.Read())
        {
            string name = (sreader.GetValue(1)).ToString();
            mylist.Add(name);
        }
        sqlConnection.Close();

        return mylist;
    }

After attaching a database, this method returns a list with only main table in it.

What am I doing wrong?

What are you trying to achieve?

My Other Me
– My Other Me

2012-04-18 06:55:41 +00:00
Commented Apr 18, 2012 at 6:55 — My Other Me
– My Other Me, Commented Apr 18, 2012 at 6:55

My Other Me · Accepted Answer · 2012-04-18 06:55:28Z

3

Sqlite does not persist the attached databases. Every time you open and close the connection, the attached databases are forgotten.

answered Apr 18, 2012 at 6:55

My Other Me

5,1276 gold badges45 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user850010 Over a year ago

Should I then just keep the connection open in the helper class instead of opening/closing connection in each method as it is now? I only intend to use sqlite for desktop apps.

My Other Me Over a year ago

There is no generic answer to that question. If you only have one application accessing the DB at a time then I think it is fine to use the same connection (though there are some gotchas regarding multiple threads). If you want to just get information about a database file, then you could open a single connection to that file and query that file without a need to attach the file. it all depends on your circumstances.

Collectives™ on Stack Overflow

Attaching a database in Sqlite using .NET not working

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related