public void RetrieveAll_QueryExpression_Typed() { //Arrange int totalRecords = 5010; string distinctAccountName = Guid.NewGuid().ToString(); List <Entity> accounts = new List <Entity>(); for (int i = 0; i < totalRecords; i++) { accounts.Add(new Account() { Id = Guid.NewGuid(), Name = distinctAccountName }); } _context.Initialize(accounts); //Act Microsoft.Xrm.Sdk.Query.QueryExpression queryExpression = new Microsoft.Xrm.Sdk.Query.QueryExpression(Account.EntityLogicalName) { ColumnSet = new Microsoft.Xrm.Sdk.Query.ColumnSet(Account.Fields.Name) }; queryExpression.Criteria.AddCondition(Account.Fields.Name, Microsoft.Xrm.Sdk.Query.ConditionOperator.Equal, distinctAccountName); IEnumerable <Account> results = _service.RetrieveAll <Account>(queryExpression); //Assert Assert.Equal(totalRecords, results.Count()); }
public JsonResult Authenticate(dynamic data) { log.Info("Entering Authenticate method"); var result = new JsonResult(); result.Data = "false"; Microsoft.Xrm.Sdk.Query.QueryExpression queryExpression = new Microsoft.Xrm.Sdk.Query.QueryExpression("contact") { Distinct = true, Criteria = new FilterExpression(LogicalOperator.And) { Conditions = { new ConditionExpression("emailaddress1", ConditionOperator.Equal, data.username.Value), new ConditionExpression("concap_password", ConditionOperator.Equal, data.password.Value) } }, ColumnSet = new ColumnSet(new string[] { "contactid", "fullname", "concap_password" }) }; try { log.Info("Data Retrieval from MSCRM begin"); EntityCollection contacts = _serviceProxy.RetrieveMultiple(queryExpression); log.Debug("Retrieved record count =" + contacts.Entities.Count); if (contacts.Entities.Count > 0) { Entity contact = contacts.Entities[0]; if (contact.GetAttributeValue <String>("concap_password").Equals(data.password.Value)) { log.Debug("User logged in : " + contacts.Entities[0].Id); result.Data = contacts.Entities[0]; } else { result.Data = null; } } // result.Data = "true"; else { result.Data = null; // result.Data = "false"; } log.Info("Data Retrieval from MSCRM end"); } catch (Exception ex) { log.Error(" Exception occured in Authenticate method ." + ex.Message + ". Returning null"); return(new JsonResult { Data = null }); } log.Info("leaving Authenticate method"); return(result); }