예제 #1
0
        //public IQueryable<Post> GetPostsByTag(string tagname)
        public TagCount GetTagCount(string tagname)
        {
            TagCount counter;
            int count;
            count = Data.Posts.Count(p => p.Tags.Contains(tagname));

            counter = new TagCount { TagName = tagname, CountTag = count };

            return counter;
        }
예제 #2
0
        //This is the Dapper Version
        public TagCount GetdynPostsByTag(string tagname)
        {
            string connection = ConfigurationManager.ConnectionStrings["SoFConnStr"].ToString();
            int counter;

            using (System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(connection))
            {
                sqlConnection.Open();
                counter = sqlConnection.Query<int>("SELECT Count(0) as PostCount FROM dbo.Posts WHERE FREETEXT(tags, @tagname)", new { tagname = tagname }).Single();
            }
                TagCount taggy = new TagCount { TagName = tagname, CountTag = counter };
            return taggy;
        }