Get All Items From SharePoint List Using CSOM

 Get All Items From SharePoint List Using CSOM

Please follow the steps to execute the code in visual studio using Console Application.

Steps:

1. Open your Visual Studio.
2. From the template select Console Application and click next.
3. Enter name and select the location to store the project and click create.
4. Now your program.cs file will open, write/copy, paste the below-given code.

using Microsoft.SharePoint.Client;

using System;

namespace CSOMCRUD 

 { 

  class Program

   { 

try

     {

          using (ClientContext ctx = new ClientContext("Site URL"))

            {

                Web web = ctx.Web;

// Enter List Name

                List list = web.Lists.GetByTitle("Employee");

// CamlQuery

                CamlQuery query = new CamlQuery();

                query.ViewXml = "<View/>";

// GetItems by query

                ListItemCollection items = list.GetItems(query);

// load the list and items

                ctx.Load(list);

                ctx.Load(items);

                ctx.ExecuteQuery();

                foreach (ListItem item in items)

                {

                    Console.WriteLIne(item.Id + " - " + item["Title"]);

                }

                Console.ReadLine();

            }

      }

      catch (Exception ex)

        {

           throw;

        }

    }

 }

5. Click F5 or Run the Application.

Thank You for reading. Hope you have enjoyed this! :-)