public void When_doing_a_crm_linq_query_and_proxy_types_and_a_selected_attribute_returned_projected_entity_is_thesubclass() { var fakedContext = new XrmFakedContext(); var guid1 = Guid.NewGuid(); var guid2 = Guid.NewGuid(); fakedContext.Initialize(new List<Entity>() { new Contact() { Id = guid1, FirstName = "Jordi" }, new Contact() { Id = guid2, FirstName = "Other" } }); var service = fakedContext.GetFakedOrganizationService(); using (XrmServiceContext ctx = new XrmServiceContext(service)) { var matches = (from c in ctx.CreateQuery<Contact>() where c.FirstName.Equals("Jordi") select new { FirstName = c.FirstName, CrmRecord = c }).ToList(); Assert.True(matches.Count == 1); Assert.True(matches[0].FirstName.Equals("Jordi")); Assert.IsAssignableFrom(typeof(Contact), matches[0].CrmRecord); Assert.True(matches[0].CrmRecord.GetType() == typeof(Contact)); } }
public void When_doing_a_crm_linq_query_with_an_equals_operator_record_is_returned() { var fakedContext = new XrmFakedContext(); var guid1 = Guid.NewGuid(); var guid2 = Guid.NewGuid(); fakedContext.Initialize(new List<Entity>() { new Contact() { Id = guid1, FirstName = "Jordi" }, new Contact() { Id = guid2, FirstName = "Other" } }); var service = fakedContext.GetFakedOrganizationService(); using (XrmServiceContext ctx = new XrmServiceContext(service)) { var matches = (from c in ctx.CreateQuery<Contact>() where c.FirstName.Equals("Jordi") select c).ToList(); Assert.True(matches.Count == 1); Assert.True(matches[0].FirstName.Equals("Jordi")); matches = (from c in ctx.CreateQuery<Contact>() where c.FirstName == "Jordi" //Using now equality operator select c).ToList(); Assert.True(matches.Count == 1); Assert.True(matches[0].FirstName.Equals("Jordi")); } }
public void When_executing_a_query_expression_with_2_filters_combined_with_an_or_filter_right_result_is_returned() { var context = new XrmFakedContext(); var contact1 = new Entity("contact") { Id = Guid.NewGuid() }; contact1["fullname"] = "Contact 1"; contact1["firstname"] = "First 1"; var contact2 = new Entity("contact") { Id = Guid.NewGuid() }; contact2["fullname"] = "Contact 2"; contact2["firstname"] = "First 2"; context.Initialize(new List<Entity>() { contact1, contact2 }); var qe = new QueryExpression() { EntityName = "contact" }; qe.ColumnSet = new ColumnSet(true); var filter1 = new FilterExpression(); filter1.AddCondition(new ConditionExpression("fullname", ConditionOperator.Equal, "Contact 1")); var filter2 = new FilterExpression(); filter2.AddCondition(new ConditionExpression("fullname", ConditionOperator.Equal, "Contact 2")); qe.Criteria = new FilterExpression(LogicalOperator.Or); qe.Criteria.AddFilter(filter1); qe.Criteria.AddFilter(filter2); var result = XrmFakedContext.TranslateQueryExpressionToLinq(context, qe).ToList(); Assert.True(result.Count == 2); }
public void When_initialising_the_context_twice_exception_is_thrown() { var context = new XrmFakedContext(); var c = new Contact() { Id = Guid.NewGuid(), FirstName = "Lionel" }; Assert.DoesNotThrow(() => context.Initialize(new List<Entity>() { c })); Assert.Throws<Exception>(() => context.Initialize(new List<Entity>() { c })); }
public static void When_using_proxy_types_assembly_the_attribute_metadata_is_inferred_from_the_proxy_types_assembly() { var fakedContext = new XrmFakedContext(); fakedContext.ProxyTypesAssembly = Assembly.GetExecutingAssembly(); var contact1 = new Entity("contact") { Id = Guid.NewGuid() }; contact1["fullname"] = "Contact 1"; contact1["firstname"] = "First 1"; var contact2 = new Entity("contact") { Id = Guid.NewGuid() }; contact2["fullname"] = "Contact 2"; contact2["firstname"] = "First 2"; fakedContext.Initialize(new List<Entity>() { contact1, contact2 }); var guid = Guid.NewGuid(); //Empty contecxt (no Initialize), but we should be able to query any typed entity without an entity not found exception var service = fakedContext.GetFakedOrganizationService(); using (XrmServiceContext ctx = new XrmServiceContext(service)) { var contact = (from c in ctx.CreateQuery<Contact>() where c.FirstName.Equals("First 1") select c).ToList(); Assert.True(contact.Count == 1); } }
public void When_the_create_task_activity_is_executed_a_task_is_created_in_the_context() { var fakedContext = new XrmFakedContext(); fakedContext.ProxyTypesAssembly = Assembly.GetExecutingAssembly(); var guid1 = Guid.NewGuid(); var account = new Account() { Id = guid1 }; fakedContext.Initialize(new List<Entity>() { account }); //Inputs var inputs = new Dictionary<string, object>() { { "inputEntity", account.ToEntityReference() } }; var result = fakedContext.ExecuteCodeActivity<CreateTaskActivity>(inputs); //The wf creates an activity, so make sure it is created var tasks = (from t in fakedContext.CreateQuery<Task>() select t).ToList(); //The activity creates a taks Assert.True(tasks.Count == 1); var output = result["taskCreated"] as EntityReference; //Task created contains the account passed as the regarding Id Assert.True(tasks[0].RegardingObjectId != null && tasks[0].RegardingObjectId.Id.Equals(guid1)); //Same task created is returned Assert.Equal(output.Id, tasks[0].Id); }
public void Should_Not_Change_Context_Objects_Without_Update() { var entityId = Guid.NewGuid(); var context = new XrmFakedContext(); var service = context.GetOrganizationService(); context.Initialize(new[] { new Entity ("account") { Id = entityId, Attributes = new AttributeCollection { { "accountname", "Adventure Works" } } } }); var firstRetrieve = service.Retrieve("account", entityId, new ColumnSet(true)); var secondRetrieve = service.Retrieve("account", entityId, new ColumnSet(true)); firstRetrieve["accountname"] = "Updated locally"; Assert.Equal("Updated locally", firstRetrieve["accountname"]); Assert.Equal("Adventure Works", secondRetrieve["accountname"]); }
public static void When_a_query_by_attribute_is_executed_when_one_attribute_right_result_is_returned() { var context = new XrmFakedContext(); var account = new Account() {Id = Guid.NewGuid(), Name = "Test"}; var account2 = new Account() { Id = Guid.NewGuid(), Name = "Other account!" }; context.Initialize(new List<Entity>() { account, account2 }); var service = context.GetFakedOrganizationService(); QueryByAttribute query = new QueryByAttribute(); query.Attributes.AddRange(new string[] { "name" }); query.ColumnSet = new ColumnSet(new string[] { "name" }); query.EntityName = Account.EntityLogicalName; query.Values.AddRange(new object[] { "Test" }); //Execute using a request to test the OOB (XRM) message contracts RetrieveMultipleRequest request = new RetrieveMultipleRequest(); request.Query = query; Collection<Entity> entityList = ((RetrieveMultipleResponse)service.Execute(request)).EntityCollection.Entities; Assert.True(entityList.Count == 1); Assert.Equal(entityList[0]["name"].ToString(), "Test"); }
public void Should_update_an_entity_when_calling_update() { var ctx = new XrmFakedContext(); var logSystem = A.Fake<IDetailedLog>(); var service = ctx.GetOrganizationService(); //Arrange var contact = new Entity("contact") { Id = Guid.NewGuid() }; contact["fullname"] = "Lionel Messi"; ctx.Initialize(new Entity[] { contact }); //Act var contactToUpdate = new Entity("contact") { Id = contact.Id }; contactToUpdate["fullname"] = "Luis Suárez"; var actions = new Actions(logSystem, service); actions.Update(contactToUpdate); //Assert var contacts = ctx.CreateQuery("contact").ToList(); Assert.Equal(1, contacts.Count); Assert.Equal(contacts[0]["fullname"], "Luis Suárez"); }
public void When_doing_a_crm_linq_query_and_proxy_types_projection_must_be_applied_after_where_clause() { var fakedContext = new XrmFakedContext(); fakedContext.ProxyTypesAssembly = Assembly.GetExecutingAssembly(); var guid1 = Guid.NewGuid(); var guid2 = Guid.NewGuid(); fakedContext.Initialize(new List<Entity>() { new Contact() { Id = guid1, FirstName = "Jordi", LastName = "Montana" }, new Contact() { Id = guid2, FirstName = "Other" } }); var service = fakedContext.GetFakedOrganizationService(); using (XrmServiceContext ctx = new XrmServiceContext(service)) { var matches = (from c in ctx.CreateQuery<Contact>() where c.LastName == "Montana" //Should be able to filter by a non-selected attribute select new { FirstName = c.FirstName }).ToList(); Assert.True(matches.Count == 1); Assert.True(matches[0].FirstName.Equals("Jordi")); } }
public void When_initializing_the_context_with_an_entity_with_an_empty_guid_an_exception_is_thrown() { var context = new XrmFakedContext(); IEnumerable<Entity> data = new List<Entity>() { new Entity("account") { Id = Guid.Empty } }; var ex = Assert.Throws<InvalidOperationException>(() => context.Initialize(data)); Assert.Equal(ex.Message, "An entity with an empty Id can't be added"); }
public void When_initializing_the_context_with_an_entity_with_an_empty_logical_name_an_exception_is_thrown() { var context = new XrmFakedContext(); IEnumerable<Entity> data = new List<Entity>() { new Entity() { Id = Guid.NewGuid()} }; var ex = Assert.Throws<InvalidOperationException>(() => context.Initialize(data)); Assert.Equal(ex.Message, "An entity must not have a null or empty LogicalName property."); }
public void When_initializing_the_context_with_a_dynamic_entity_with_a_primary_key_is_added_to_the_context() { var context = new XrmFakedContext(); IEnumerable<Entity> data = new List<Entity>() { new Entity("account") { Id = Guid.NewGuid(), Attributes = new AttributeCollection { { "accountid", Guid.NewGuid() } } } }; Assert.DoesNotThrow(() => context.Initialize(data)); Assert.True(context.Data.Count == 1); Assert.True(context.Data["account"].Count == 1); }
public void When_initializing_the_context_with_an_entity_it_should_have_default_createdon_createdby_modifiedon_and_modifiedby_attributes() { var context = new XrmFakedContext(); var service = context.GetFakedOrganizationService(); var e = new Entity("account") { Id = Guid.NewGuid() }; context.Initialize(new List<Entity>() { e }); Assert.True(e.Attributes.ContainsKey("createdon")); Assert.True(e.Attributes.ContainsKey("modifiedon")); Assert.True(e.Attributes.ContainsKey("createdby")); Assert.True(e.Attributes.ContainsKey("modifiedby")); }
public void When_initializing_the_context_with_an_entity_the_context_has_that_entity() { var context = new XrmFakedContext(); var guid = Guid.NewGuid(); IQueryable<Entity> data = new List<Entity>() { new Entity("account") { Id = guid } }.AsQueryable(); context.Initialize(data); Assert.True(context.Data.Count == 1); Assert.True(context.Data["account"].Count == 1); Assert.Equal(context.Data["account"][guid], data.FirstOrDefault()); }
public void When_initializing_with_two_entities_with_the_same_guid_only_the_latest_will_be_in_the_context() { var context = new XrmFakedContext(); var guid = Guid.NewGuid(); IQueryable<Entity> data = new List<Entity>() { new Entity("account") { Id = guid }, new Entity("account") { Id = guid } }.AsQueryable(); context.Initialize(data); Assert.True(context.Data.Count == 1); Assert.True(context.Data["account"].Count == 1); Assert.Equal(context.Data["account"][guid], data.LastOrDefault()); }
public void When_executing_a_query_expression_with_a_not_implemented_operator_pull_request_exception_is_thrown() { var context = new XrmFakedContext(); var contact1 = new Entity("contact") { Id = Guid.NewGuid() }; contact1["fullname"] = "Contact 1"; contact1["firstname"] = "First 1"; var contact2 = new Entity("contact") { Id = Guid.NewGuid() }; contact2["fullname"] = "Contact 2"; contact2["firstname"] = "First 2"; context.Initialize(new List<Entity>() { contact1, contact2 }); var qe = new QueryExpression() { EntityName = "contact" }; qe.ColumnSet = new ColumnSet(true); qe.Criteria = new FilterExpression(LogicalOperator.And); var condition = new ConditionExpression("fullname", ConditionOperator.LastXFiscalPeriods, "Contact 1"); qe.Criteria.AddCondition(condition); Assert.Throws<PullRequestException>(() => XrmFakedContext.TranslateQueryExpressionToLinq(context, qe).ToList()); }
public void When_retrieve_is_invoked_with_non_existing_entity_null_is_returned() { var context = new XrmFakedContext(); //Initialize the context with a single entity var guid = Guid.NewGuid(); var data = new List<Entity>() { new Entity("account") { Id = guid } }.AsQueryable(); context.Initialize(data); var service = context.GetFakedOrganizationService(); Assert.Throws<FaultException<OrganizationServiceFault>>(() => service.Retrieve("account", Guid.NewGuid(), new ColumnSet())); }
public void When_translating_a_query_from_a_non_existing_entity_an_exception_is_thrown() { var context = new XrmFakedContext(); var guid1 = Guid.NewGuid(); var guid2 = Guid.NewGuid(); var guid3 = Guid.NewGuid(); IQueryable<Entity> data = new List<Entity>() { new Entity("account") { Id = guid1 }, new Entity("account") { Id = guid2 }, new Entity("contact") { Id = guid3 } }.AsQueryable(); context.Initialize(data); var qe = new QueryExpression() { EntityName = "nonexistingentityname"}; Assert.Throws<Exception>(() => XrmFakedContext.TranslateQueryExpressionToLinq(context, qe)); }
public void When_delete_is_invoked_with_an_existing_entity_that_entity_is_delete_from_the_context() { var context = new XrmFakedContext(); //Initialize the context with a single entity var guid = Guid.NewGuid(); var data = new List<Entity>() { new Entity("account") { Id = guid } }.AsQueryable(); context.Initialize(data); var service = context.GetFakedOrganizationService(); service.Delete("account", guid); Assert.True(context.Data["account"].Count == 0); }
public void When_translating_a_query_from_a_non_existing_entity_an_empty_list_is_returned_when_using_dynamic_entities() { var context = new XrmFakedContext(); var guid1 = Guid.NewGuid(); var guid2 = Guid.NewGuid(); var guid3 = Guid.NewGuid(); IQueryable<Entity> data = new List<Entity>() { new Entity("account") { Id = guid1 }, new Entity("account") { Id = guid2 }, new Entity("contact") { Id = guid3 } }.AsQueryable(); context.Initialize(data); var qe = new QueryExpression() { EntityName = "nonexistingentityname" }; var result = XrmFakedContext.TranslateQueryExpressionToLinq(context, qe); Assert.Equal(0, result.Count()); }
public void When_retrieve_is_invoked_with_an_existing_entity_and_all_columns_all_the_attributes_are_returned() { var context = new XrmFakedContext(); //Initialize the context with a single entity var guid = Guid.NewGuid(); var data = new List<Entity>() { new Entity("account") { Id = guid } }.AsQueryable(); context.Initialize(data); var service = context.GetFakedOrganizationService(); var result = service.Retrieve("account", guid, new ColumnSet(true)); Assert.Equal(result.Id, data.FirstOrDefault().Id); Assert.Equal(result.Attributes.Count, data.FirstOrDefault().Attributes.Count); }
public void When_delete_is_invoked_with_non_existing_entity_an_exception_is_thrown() { var context = new XrmFakedContext(); //Initialize the context with a single entity var guid = Guid.NewGuid(); var nonExistingGuid = Guid.NewGuid(); var data = new List<Entity>() { new Entity("account") { Id = guid } }.AsQueryable(); context.Initialize(data); var service = context.GetFakedOrganizationService(); var ex = Assert.Throws<FaultException<OrganizationServiceFault>>(() => service.Delete("account", nonExistingGuid)); Assert.Equal(ex.Message, string.Format("account with Id {0} Does Not Exist", nonExistingGuid)); }
public void When_executing_a_query_expression_with_endswith_operator_right_result_is_returned() { var context = new XrmFakedContext(); var contact1 = new Entity("contact") { Id = Guid.NewGuid() }; contact1["fullname"] = "Contact 1"; contact1["firstname"] = "First 1"; var contact2 = new Entity("contact") { Id = Guid.NewGuid() }; contact2["fullname"] = "Contact 2"; contact2["firstname"] = "First 2"; context.Initialize(new List<Entity>() { contact1, contact2 }); var qe = new QueryExpression() { EntityName = "contact" }; qe.ColumnSet = new ColumnSet(true); qe.Criteria = new FilterExpression(LogicalOperator.And); var condition = new ConditionExpression("fullname", ConditionOperator.EndsWith, "2"); qe.Criteria.AddCondition(condition); var result = XrmFakedContext.TranslateQueryExpressionToLinq(context, qe).ToList(); Assert.True(result.Count() == 1); }
public void When_executing_a_query_expression_with_a_simple_join_right_result_is_returned() { var context = new XrmFakedContext(); var contact1 = new Entity("contact") { Id = Guid.NewGuid() }; contact1["fullname"] = "Contact 1"; var contact2 = new Entity("contact") { Id = Guid.NewGuid() }; contact2["fullname"] = "Contact 2"; var account = new Entity("account") { Id = Guid.NewGuid() }; account["name"] = "Account 1"; contact1["parentcustomerid"] = account.ToEntityReference(); //Both contacts are related to the same account contact2["parentcustomerid"] = account.ToEntityReference(); context.Initialize(new List<Entity>() { account, contact1, contact2}); var qe = new QueryExpression() { EntityName = "contact" }; qe.LinkEntities.Add( new LinkEntity() { LinkFromEntityName = "contact", LinkToEntityName = "account", LinkFromAttributeName = "parentcustomerid", LinkToAttributeName = "accountid", JoinOperator = JoinOperator.Inner, Columns = new ColumnSet(new string[] { "name" }) } ); qe.ColumnSet = new ColumnSet(new string[] { "fullname", "parentcustomerid" }); var result = XrmFakedContext.TranslateQueryExpressionToLinq(context, qe); Assert.True(result.Count() == 2); //2 Contacts related to the same account var firstContact = result.FirstOrDefault(); var secondContact = result.LastOrDefault(); Assert.True(firstContact.Attributes.Count == 3); Assert.True(secondContact.Attributes.Count == 3); Assert.True(firstContact["fullname"].Equals(contact1["fullname"])); Assert.True((firstContact["account.name"] as AliasedValue).Value.Equals(account["name"])); Assert.True(secondContact["fullname"].Equals(contact2["fullname"])); Assert.True((secondContact["account.name"] as AliasedValue).Value.Equals(account["name"])); }
public void When_executing_a_linq_query_with_equals_between_2_strings_result_is_returned() { var fakedContext = new XrmFakedContext(); var guid = Guid.NewGuid(); fakedContext.Initialize(new List<Entity>() { new Contact() { Id = guid, FirstName = "Jordi" } }); var service = fakedContext.GetFakedOrganizationService(); using (XrmServiceContext ctx = new XrmServiceContext(service)) { var contact = (from c in ctx.CreateQuery<Contact>() where c.FirstName == "Jordi" select c).FirstOrDefault(); Assert.True(contact != null); } }
public void After_querying_the_context_with_an_invalid_entity_name_exception_is_thrown() { var context = new XrmFakedContext(); context.ProxyTypesAssembly = Assembly.GetExecutingAssembly(); var service = context.GetFakedOrganizationService(); var guid = Guid.NewGuid(); var data = new List<Entity>() { new Contact() { Id = guid } }.AsQueryable(); context.Initialize(data); Assert.Throws<Exception>(() => { var query = (from c in context.CreateQuery(" ") select c); }); }
public void When_retrieve_is_invoked_with_an_existing_entity_and_only_one_column_only_that_one_is_retrieved() { var context = new XrmFakedContext(); //Initialize the context with a single entity var guid = Guid.NewGuid(); var entity = new Entity("account") { Id = guid }; entity["name"] = "Test account"; entity["createdon"] = DateTime.UtcNow; var data = new List<Entity>() { entity }.AsQueryable(); context.Initialize(data); var service = context.GetFakedOrganizationService(); var result = service.Retrieve("account", guid, new ColumnSet(new string [] {"name"})); Assert.Equal(result.Id, data.FirstOrDefault().Id); Assert.True(result.Attributes.Count == 1); Assert.Equal(result["name"], "Test account"); }
public void When_doing_a_crm_linq_query_a_retrievemultiple_with_a_queryexpression_is_called() { var fakedContext = new XrmFakedContext(); var guid = Guid.NewGuid(); fakedContext.Initialize(new List<Entity>() { new Contact() { Id = guid, FirstName = "Jordi" } }); var service = fakedContext.GetFakedOrganizationService(); using (XrmServiceContext ctx = new XrmServiceContext(service)) { var contact = (from c in ctx.CreateQuery<Contact>() where c.FirstName.Equals("Jordi") select c).FirstOrDefault(); } A.CallTo(() => service.Execute(A<OrganizationRequest>.That.Matches(x => x is RetrieveMultipleRequest && ((RetrieveMultipleRequest)x).Query is QueryExpression))).MustHaveHappened(); }
public void When_executing_a_linq_query_with_equals_between_2_boolean_managed_properties_result_is_returned() { var fakedContext = new XrmFakedContext(); var guid = Guid.NewGuid(); fakedContext.Initialize(new List<Entity>() { new Report() { Id = guid, IsCustomizable = new BooleanManagedProperty(true) }, new Report() { Id = Guid.NewGuid()} //To test also nulls }); var service = fakedContext.GetFakedOrganizationService(); using (XrmServiceContext ctx = new XrmServiceContext(service)) { var contact = (from c in ctx.CreateQuery<Report>() where c.IsCustomizable.Value == true select c).ToList(); Assert.True(contact.Count == 1); } }