Getting SharePoint BlogPost item via LinQ without SPMetal

My Criteria:
a. Getting SharePoint BlogPost items without generating SPMetal
b. Have a custom column which inherit from SPFieldURL

//Remember to add the following using in your CS file:
/*

using System;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using System.Web.Services;
using System.Linq;
*/

Here goes the code:
On Page Load Event:

    SPList list = SPContext.Current.Web.Lists["Posts"];

//Row: to get the first 20 records:pagination
 var items = list.Items.OfType<SPListItem>().Take(Rows).Select(
    i => new {
       ID = i.ID,
       Picture1 =(new SPFieldUrlValue(i["Picture1"].ToString())).Url,
       Title = i.Title});    
 
       //Bind to a DataList
   DtBlogPost.DataSource = items.ToList();
   DtBlogPost.DataBind();


There you go, this is very simple code.

                           

Comments

Post a Comment

Popular posts from this blog

SharePoint 2013: Distributed Cache Services

Image
What is Distributed Cache Services(DCS)? - It is a Platform Service, it runs at the Farm Level.   -- You can decide to run it on all servers in the farm or you can use it to run on a 1 or a couple of servers.   -- Suggest to have dedicate servers for DCS. - It provides in-memory cache for the entire farm. - It is based on Window Server App Fabric Distributed Caching. - It uses to cache Authentication Token(to avoid multiple authentication processes) and MySite Social Feeds. - DCS enable by default and allocate memory based on total memory on your server.   -- You should at least dedicate 50% of RAM or more just to the DCS service for overhead. What is it NOT : - It do not uses Window Azure Cache services and thus it cache on local server (no cloud). - It uses Window Server App Fabric version that comes together with the installer: You are not recommended download any version from Microsoft and upgrade it independently.  - You are not recommende...
Read more

AWS: On Demand Capacity Reservation (ODCR) and preventing Insufficient Capacity Error (ICE)

 What is ODCR, and why does it matter? On-Demand Capacity Reservation is one of the ways how we can reserve capacity on AWS. This feature helped to reserved capacity especially the large EC2 instance or special instances like (P series) that is very little in the Availability Zones (AZ). The service will not charge you if you have an EC2 running 24 by 7. It will ensure when you need to start/stop your EC2, the same instance family/types for that particular AZ are reserved for you. It is not commitment-based, like a Reserved Instance or Saving Plan, where you need a minimum of 1 year. ODCR is only activated once you enable it in the AWS Console. You can cancel it anytime if you do not needed. What is an Insufficient Capacity Error (ICE)? ICE is an exception where there are not enough EC2 instance families available in a particular Region or AZ. This is not common in AWS, but it has happened before, especially for large EC2 like 32x or special EC2 like P series.  How does ODCR h...
Read more

SharePoint 2013: Execution Policy for PowerShell

Image
PowerShell is a very powerful administrative tool, just like old school batch job kind of scripting. PowerShell team at Microsoft knows that the security concerns when running PowerShell scripts which may post a major security thread thus no powershell script can be run unless the execution policy is set from Restricted to Unrestricted\ByPass or the script is signed individually. If you directly run PowerShell scripting, you will encounter the error like below: Following technet way("http://technet.microsoft.com/en-us/library/ee176961.aspx") you can actually set the policy to unrestricted\bypass. Try execute the script again, you will able to run it. Let set the script back to unrestricted and run the Hello.ps1 again to show the error. Next install SharePoint 2013 and you will see after the installation, the execution policy is set to ByPass. Conclusion : After installation of SharePoint 2013, the installer will change the execution policy so...
Read more