public override bool TableExists(string tableName)
{
object result;
string sql = string.Format("select count(name) from sqlite_master where name = '{0}'", tableName);
using (var cn = new SQLiteConnectionAlias(this.ConnectionString))
{
using (var cmd = new SQLiteCommandAlias(sql, cn))
{
cn.Open();
try
{
result = cmd.ExecuteScalar();
}
catch (SQLiteExceptionAlias)
{
throw;
}
finally
{
cn.Close();
}
}
}
return((System.Int64)result > 0);
}
private int GetIdentity(IDbTransaction transaction)
{
using (var command = new SQLiteCommand("SELECT last_insert_rowid()", transaction.Connection as SQLiteConnection, transaction as SQLiteTransaction))
{
object id = command.ExecuteScalar();
return(Convert.ToInt32(id));
}
}
