title: C# CAML query to sharepoint returns all items in the list (instead of only ones that mach query value)
body: <p>I have the following code in my app to pull details from a sharepoint list.</p>
  
  <pre><code>            string siteUrl = "http://SHAREPOINTURL";
  
          ClientContext clientContext = new ClientContext(siteUrl);
          clientContext.Credentials = new NetworkCredential("UN", "PW", "DOMAIN");
          SP.List oList = clientContext.Web.Lists.GetByTitle("Licences");
  
          CamlQuery camlQuery = new CamlQuery();
          camlQuery.ViewXml = "&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='Account' /&gt;&lt;Value Type='Text'&gt;123456&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;";
  
          ListItemCollection collListItem = oList.GetItems(camlQuery);
          clientContext.Load(collListItem);
          clientContext.ExecuteQuery();
  
          Console.WriteLine("Filtered List: " + collListItem.Count.ToString() + "\n");
          foreach (ListItem oListItem in collListItem)
          {
              Console.WriteLine("Account: {0} \nLicence: {1} \nMAC: {2}\n", oListItem["Account"], oListItem["Licence"], oListItem["MAC"]);
          }
  </code></pre>
  
  <p>In the sharepoint list I have created multiple test items but every time I run the above code all items in the list are returned regardless of what I use for the camlQuery. </p>
  
  <p>Can anyone let me know where I'm going wrong with this pretty new to C# and never touched sharepoint before this.</p>
  
  <p>Edit1: updated with advice from below.</p>
  
  <p>Edit2: simplified the code but still getting the same problem.</p>