Mailing List



NerdyHearn - Blog

<< Back To All Blogs

Reading A Database Schema in SQLite with C#

Wednesday, September 16th, 2009

As an introduction to my next, still secret, blog post, I would like to go over how you can read the schema from a SQLite database, using C# and System.Data.SQLite.

This is a fairly simple process, but not immediately apparent if you are trying to do what I needed to do. In my case, I simply wanted to open an SQLite database (if you aren't familiar with SQLite, it is just a file-based DBMS), and read all of the tables within this database (file).

Without further ado, here is the code, which is fairly simple:

// Initialize the connection
SQLiteConnection conn = new SQLiteConnection("data source=" + file);

// These is how you list the schema of an SQLite database
SQLiteCommand comm = new SQLiteCommand("SELECT * FROM sqlite_master WHERE type = 'table'", conn);
// Populate the reader
SQLiteDataReader reader = comm.ExecuteReader();

// Step through each row
while (reader.Read())
for (int a = 0; a < reader.FieldCount; a++)
// This will give you the name of the current row's column
string columnName = reader.GetName(a);

// This will give you the value of the current row's column
string columnValue = reader[a].ToString();

Pretty easy, but very useful.

SQLitin' Tom Out.


CSharp Databases SQLite

Related Blogs

Creating an MD5 String Extension method in C#
Autostarting a Windows Service directly after install in C#
Generic Method for Loading Interfaces in C# (For a Plugin System)
Bitmasking userAccountControl attribute in LDAP from C#


Currently no comments.

Add A Comment



Email Address: (not public, used to send notifications on further comments)


Enter the text above, except for the 1st and last character:

NerdyHearn - Latest tech news relating to C#, ASP.NET, SharePoint, PHP, general development, and more. SaveMySerials - Protect yourself from theft, fire, natural disasters and more by recording your serial numbers