Skip to content

Instantly share code, notes, and snippets.

@szunyog
Created February 20, 2015 09:36
Show Gist options
  • Select an option

  • Save szunyog/7f5c059886ef4312c7cf to your computer and use it in GitHub Desktop.

Select an option

Save szunyog/7f5c059886ef4312c7cf to your computer and use it in GitHub Desktop.
sqlite check column exists c#
private bool CheckIfColumnExists(string tableName, string columnName)
{
using(var conn = new SQLiteConnection("Data Source=mydb.sqlite;"))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = string.Format("PRAGMA table_info({0})", tableName);
var reader = cmd.ExecuteReader();
int nameIndex = reader.GetOrdinal("Name");
while (reader.Read())
{
if (reader.GetString(nameIndex).Equals(columnName))
return true;
}
conn.Close();
}
return false;
}
@karennk
Copy link

karennk commented Feb 28, 2021

Thank you for the explanation.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment