Repository navigation
Getting Bool #9
Description
Hi, how can i get the boolean value in my database column?
SqliteDatabase sqlDB = new SqliteDatabase ("config.db");
string query = "SELECT bookName ,read " + "FROM Books";
var data = sqlDB.ExecuteQuery (query);
bool boolData = data.Rows[0]["read"];
Currently it returns data.Rows[0]["read"] as object so it gives me an error:
Cannot implicitly convert type object' tobool'. An explicit conversion exists (are you missing a cast?)
Activity
isaacgoodfellow commentedon Dec 11, 2015
Sqlite has no internal representation for boolean values, but they can be represented with integers,
bool read = ((int)result.Rows [i] ["read"]) > 0;
would suffice in this case