private BaseEntry GetFullTextData(BaseEntry entry) { BaseEntry tempEntry = default(BaseEntry); List<string> queryValues = new List<string>(); EntryDataService eds = new EntryDataService(); switch (GetEntryType(entry)) { case EntryType.Types.Class: { queryValues.Add("class"); break; } case EntryType.Types.Domain: { queryValues.Add("domain"); break; } case EntryType.Types.Equipment: { queryValues.Add("equipment"); break; } case EntryType.Types.Feat: { queryValues.Add("feat"); break; } case EntryType.Types.Item: { queryValues.Add("item"); break; } case EntryType.Types.Monster: { queryValues.Add("monster"); break; } case EntryType.Types.Power: { queryValues.Add("power"); break; } case EntryType.Types.Skill: { queryValues.Add("skill"); break; } case EntryType.Types.Spell: { queryValues.Add("spell"); break; } } //ridiculousness due to sqlite lib not doing parameterized queries correctly imho queryValues.Add(entry.Name.Replace("'", "''")); tempEntry = eds.GetSingleValue<BaseEntity, BaseEntry>(DatabaseQueries.QUERY_FULLTEXT, queryValues.ToArray()); entry.Full_Text = tempEntry.Full_Text; return entry; }