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);
}
}
