/// <summary>
/// 根据输入的文本，获取可用的帮助文档.
/// </summary>
/// <param name="inputText"></param>
/// <param name="topN"></param>
/// <returns></returns>
List <HelpDocument> IHelpService.GetHelpDocumentByInputKeyword(string inputText, int topN)
{
using (MyHelpContext context = new MyHelpContext())
{
var query =
from data in context.HelpKeywords.Include("HelpDocumentList")
where
data.KeywordText.Contains(inputText)
select
data;
List <HelpDocument> resultList = new List <HelpDocument>();
foreach (HelpKeyword keywordData in query)
{
foreach (HelpDocument doc in keywordData.HelpDocumentList)
{
if (!resultList.Exists(p => p.DocumentID == doc.DocumentID))
{
resultList.Add(doc);
}
if (resultList.Count >= topN)
{
break;
}
}
}
return(resultList);
}
}
HelpDocument IHelpService.GetHelpDocument(long id)
{
using (MyHelpContext context = new MyHelpContext())
{
HelpDocument doc = context.HelpDocuments.Find(id);
return(doc);
}
}
static void Main(string[] args)
{
// 当 Code First 与数据库结构不一致时
// 自动升级到最新的版本.
Database.SetInitializer(new MigrateDatabaseToLatestVersion <MyHelpContext, MyHelp.Migrations.Configuration>());
using (MyHelpContext context = new MyHelpContext())
{
var query =
from data in context.HelpKeywords
select data;
foreach (var item in query.Take(3))
{
Console.WriteLine(item.KeywordText);
}
}
Console.WriteLine("Finish!");
Console.ReadLine();
}
