C# (CSharp) SQLite.AddColumns示例

示例#1

        private void UpdateDatabase(int versionFrom, int versionTo)
        {
            FileBackup.BackupWithTime(Info.GetDirectory() + "\\data.db");
            SQLite sqlite = new SQLite("data.db");

            switch (versionTo)
            {
            case 2:
                sqlite.AddColumns(LIST_FAMILIES_TABLE_NAME, new List <string> {
                    FIELD_NAME_SHOW_FINISHED_ITEM, FIELD_NAME_SHOW_ABANDONED_ITEM, FIELD_NAME_SHOW_OVERDUE_ITEM, FIELD_NAME_SORT_TYPE
                }, new List <string> {
                    "INTEGER", "INTEGER", "INTEGER", "INTEGER"
                });
                sqlite.Update(LIST_FAMILIES_TABLE_NAME, new List <string> {
                    FIELD_NAME_SHOW_FINISHED_ITEM, FIELD_NAME_SHOW_ABANDONED_ITEM, FIELD_NAME_SHOW_OVERDUE_ITEM, FIELD_NAME_SORT_TYPE
                }, new List <string> {
                    "1", "0", "1", "1"
                }, "list_family_id > '0'");
                break;
            }
        }

示例#2

文件： UpdateDialog.xaml.cs 项目： HADB/ListManager

 private void UpdateDatabase(int versionFrom, int versionTo)
 {
     FileBackup.BackupWithTime(Info.GetDirectory() + "\\data.db");
     SQLite sqlite = new SQLite("data.db");
     switch (versionTo)
     {
         case 2:
             sqlite.AddColumns(LIST_FAMILIES_TABLE_NAME, new List<string> { FIELD_NAME_SHOW_FINISHED_ITEM, FIELD_NAME_SHOW_ABANDONED_ITEM, FIELD_NAME_SHOW_OVERDUE_ITEM, FIELD_NAME_SORT_TYPE }, new List<string> { "INTEGER", "INTEGER", "INTEGER", "INTEGER" });
             sqlite.Update(LIST_FAMILIES_TABLE_NAME, new List<string> { FIELD_NAME_SHOW_FINISHED_ITEM, FIELD_NAME_SHOW_ABANDONED_ITEM, FIELD_NAME_SHOW_OVERDUE_ITEM, FIELD_NAME_SORT_TYPE }, new List<string> { "1", "0", "1", "1" }, "list_family_id > '0'");
             break;
     }
 }