private void CreateDB() { SQLiteConnection conn = new SQLite_Android().GetConnection(); conn.CreateTable <Phone>(); conn.CreateTable <User>(); conn.CreateTable <Contact>(); conn.CreateTable <Group>(); conn.CreateTable <ContactGroup>(); List <SQLiteConnection.ColumnInfo> c = new List <SQLiteConnection.ColumnInfo>(); c = conn.GetTableInfo("Phone"); c = conn.GetTableInfo("User"); c = conn.GetTableInfo("Contact"); c = conn.GetTableInfo("Group"); c = conn.GetTableInfo("ContactGroup"); // }
public void DropDB() { SQLiteConnection conn = new SQLite_Android().GetConnection(); //string dropUsersQuery = "DROP TABLE User"; //SQLiteCommand dropUsersCommand = conn.CreateCommand(dropUsersQuery); //dropUsersCommand.ExecuteNonQuery(); string dropContactsQuery = "DROP TABLE Contact"; SQLiteCommand dropContactsCommand = conn.CreateCommand(dropContactsQuery); dropContactsCommand.ExecuteNonQuery(); string dropPhonesQuery = "DROP TABLE Phone"; SQLiteCommand dropPhonesCommand = conn.CreateCommand(dropPhonesQuery); dropPhonesCommand.ExecuteNonQuery(); string dropGroupsTable = "DROP TABLE ContactGroup"; SQLiteCommand dropGroupsCommand = conn.CreateCommand(dropGroupsTable); dropGroupsCommand.ExecuteNonQuery(); }