robertmeta

      private void InsertCard(CardModel card)
        {
            var sb = new StringBuilder();
            using (SQLiteCommand com = GamesRepository.DatabaseConnection.CreateCommand())
            {
                //Build Query
                sb.Append("INSERT INTO [cards](");
                sb.Append("[id],[game_id],[set_real_id],[name], [image], [alternate]");
                sb.Append(") VALUES(");
                sb.Append("@id,@game_id,(SELECT real_id FROM sets WHERE id = @set_id LIMIT 1),@name,@image,@alternate");