<< 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
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.
Generic Method for Loading Interfaces in C# (For a Plugin System)
Enumerating all attributes of an element and adding them to a dictionary using LINQ with Lambda Expressions
Retrieving the SID of a user or group account using the Win32 SDK and C#
Using MOSS and WSS SharePoint Workflow to Resize Images in an Image Library
Creating a reusable web client for PUT, POST, and DELETE in 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: