C# (CSharp) LinqDBDataContext.SP_LOAD_SEARCH_QUERY_STATISTIC Examples

Example #1

File: DataModel.cs Project: gvhung/hospital-finder

        public static List <SentenceDictionaryEntity> SearchQueryStatistic(DateTime fromDate, DateTime toDate)
        {
            List <SentenceDictionaryEntity> sdeList = null;

            using (LinqDBDataContext data = new LinqDBDataContext())
            {
                sdeList = (from sd in data.SP_LOAD_SEARCH_QUERY_STATISTIC(fromDate, toDate)
                           select new SentenceDictionaryEntity()
                {
                    Sentence = sd.Sentence,
                    Search_Time_Count = sd.Search_Time_Count,
                    Result_Count = sd.Result_Count
                }).ToList <SentenceDictionaryEntity>();
            }
            return(sdeList);
        }