internal IEnumerable<ContentDto> GetContentForElementText(ContentTypesEnum contentType, string element)
{
var selectSql = String.Format("SELECT * FROM Contents where content_type={0} and element='{1}'",
(int)contentType, HttpUtility.UrlEncode(element));
using (var selectCommand = new SQLiteCommand(selectSql, _sqliteCon))
{
var dataReader = selectCommand.ExecuteReader();
while (dataReader.Read())
{
ContentDto contentDto;
MapDataReaderToContentDto(dataReader, out contentDto);
yield return contentDto;
}
dataReader.Close();
}
}
public IEnumerable<ContentDto> GetContentForElementText(ContentTypesEnum contentType, string element)
{
return _contentDao.GetContentForElementText(contentType, element);
}
