/// <summary>
/// Retrieves and includes the meanings of the given kanji in the entity.
/// </summary>
internal static void IncludeKanjiMeanings(DaoConnection connection, KanjiEntity kanji)
{
IEnumerable <NameValueCollection> nvcMeanings = connection.Query(
string.Format("SELECT * FROM {0} km WHERE km.{1}=@kanjiId AND km.{2} IS NULL;",
SqlHelper.Table_KanjiMeaning,
SqlHelper.Field_KanjiMeaning_KanjiId,
SqlHelper.Field_KanjiMeaning_Language),
new DaoParameter("@kanjiId", kanji.ID));
KanjiMeaningBuilder meaningBuilder = new KanjiMeaningBuilder();
foreach (NameValueCollection nvcMeaning in nvcMeanings)
{
// For each meaning result : build a meaning and set the associations.
KanjiMeaning meaning = meaningBuilder.BuildEntity(nvcMeaning, null);
meaning.Kanji = kanji;
kanji.Meanings.Add(meaning);
}
}
/// <summary>
/// Retrieves and includes the meanings of the given kanji in the entity.
/// </summary>
internal static void IncludeKanjiMeanings(DaoConnection connection, KanjiEntity kanji)
{
IEnumerable<NameValueCollection> nvcMeanings = connection.Query(
"SELECT * "
+ "FROM " + SqlHelper.Table_KanjiMeaning + " km "
+ "WHERE km." + SqlHelper.Field_KanjiMeaning_KanjiId + "=@kanjiId "
+ "AND km." + SqlHelper.Field_KanjiMeaning_Language + " IS NULL;",
new DaoParameter("@kanjiId", kanji.ID));
KanjiMeaningBuilder meaningBuilder = new KanjiMeaningBuilder();
foreach (NameValueCollection nvcMeaning in nvcMeanings)
{
// For each meaning result : build a meaning and set the associations.
KanjiMeaning meaning = meaningBuilder.BuildEntity(nvcMeaning, null);
meaning.Kanji = kanji;
kanji.Meanings.Add(meaning);
}
}
