public virtual async Task Can_attach_owner_with_dependents()
{
var options = Fixture.CreateOptions();
Vehicle firstVehicle;
using (var context = new EmbeddedTransportationContext(options))
{
firstVehicle = await context.Set <Vehicle>().OrderBy(o => o.Name).FirstAsync();
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
//Issue #15289
var firstVehicleEntry = context.Add(firstVehicle);
firstVehicleEntry.State = EntityState.Unchanged;
firstVehicle.Operator.Name += "1";
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var vehicle = await context.Set <Vehicle>().OrderBy(o => o.Name).FirstAsync();
Assert.Equal(firstVehicle.Operator.Name, vehicle.Operator.Name);
}
}
public virtual async Task Can_change_principal_instance_non_derived()
{
var options = Fixture.CreateOptions();
using (var context = new EmbeddedTransportationContext(options))
{
var bike = await context.Vehicles.SingleAsync(v => v.Name == "Trek Pro Fit Madone 6 Series");
var newBike = new Vehicle
{
Name = "Trek Pro Fit Madone 6 Series",
Operator = bike.Operator,
SeatingCapacity = 2
};
context.Remove(bike);
context.Add(newBike);
TestSqlLoggerFactory.Clear();
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var bike = await context.Vehicles.SingleAsync(v => v.Name == "Trek Pro Fit Madone 6 Series");
Assert.Equal(2, bike.SeatingCapacity);
Assert.NotNull(bike.Operator);
}
}
public virtual async Task Can_query_just_embedded_collection()
{
var options = Fixture.CreateOptions(seed: false);
using (var context = new EmbeddedTransportationContext(options))
{
context.Add(
new Person
{
Id = 3,
Addresses = new[]
{
new Address {
Street = "First", City = "City"
}, new Address {
Street = "Second", City = "City"
}
}
});
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var addresses = await context.Set <Person>().Select(p => p.Addresses).AsNoTracking().FirstAsync();
Assert.Equal(2, addresses.Count);
}
}
public virtual async Task Can_change_nested_instance_non_derived()
{
var options = Fixture.CreateOptions();
using (var context = new EmbeddedTransportationContext(options))
{
var bike = await context.Vehicles.SingleAsync(v => v.Name == "Trek Pro Fit Madone 6 Series");
bike.Operator = new Operator {
Name = "Chris Horner"
};
context.ChangeTracker.DetectChanges();
bike.Operator = new LicensedOperator {
Name = "repairman"
};
TestSqlLoggerFactory.Clear();
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var bike = await context.Vehicles.SingleAsync(v => v.Name == "Trek Pro Fit Madone 6 Series");
Assert.Equal("repairman", bike.Operator.Name);
}
}
public virtual async Task Can_update_dependents()
{
var options = Fixture.CreateOptions();
Operator firstOperator;
Engine firstEngine;
using (var context = new EmbeddedTransportationContext(options))
{
firstOperator = context.Set <Vehicle>().Select(v => v.Operator).OrderBy(o => o.VehicleName).First();
firstOperator.Name += "1";
firstEngine = context.Set <PoweredVehicle>().Select(v => v.Engine).OrderBy(o => o.VehicleName).First();
firstEngine.Description += "1";
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var @operator = await context.Set <Vehicle>()
.Select(v => v.Operator).OrderBy(o => o.VehicleName).FirstAsync();
Assert.Equal(firstOperator.Name, @operator.Name);
var engine = await context.Set <PoweredVehicle>()
.Select(v => v.Engine).OrderBy(o => o.VehicleName).FirstAsync();
Assert.Equal(firstEngine.Description, engine.Description);
}
}
public virtual async Task Properties_on_owned_types_can_be_client_generated()
{
var options = Fixture.CreateOptions(seed: false);
using (var context = new EmbeddedTransportationContext(options))
{
var address = new Address
{
Street = "First",
City = "City",
AddressTitle = new AddressTitle()
};
context.Add(new Person {
Id = 1, Addresses = new List <Address> {
address
}
});
Assert.Equal("DefaultTitle", address.AddressTitle.Title);
await context.SaveChangesAsync();
var people = await context.Set <Person>().ToListAsync();
Assert.Same(address, people[0].Addresses.Single());
}
}
public virtual async Task Can_use_non_int_keys_for_embedded_entities()
{
var options = Fixture.CreateOptions(
modelBuilder =>
{
modelBuilder.Entity <Person>(
eb => eb.OwnsMany(
v => v.Addresses, b =>
{
b.Property <Guid>("Id");
}));
},
additionalModelCacheKey: "Guid_key",
seed: false);
Address address;
Guid addressGuid;
await using (var context = new EmbeddedTransportationContext(options))
{
await context.Database.EnsureCreatedAsync();
var person = new Person {
Id = 1
};
address = new Address {
Street = "Second", City = "Village"
};
person.Addresses.Add(address);
context.Add(person);
var addressEntry = context.Entry(address);
addressGuid = (Guid)addressEntry.Property("Id").CurrentValue;
await context.SaveChangesAsync();
}
await using (var context = new EmbeddedTransportationContext(options))
{
var people = await context.Set <Person>().OrderBy(o => o.Id).ToListAsync();
var addresses = people[0].Addresses.ToList();
Assert.Single(addresses);
Assert.Equal(address.Street, addresses[0].Street);
Assert.Equal(address.City, addresses[0].City);
var addressEntry = context.Entry(addresses[0]);
Assert.Equal(addressGuid, (Guid)addressEntry.Property("Id").CurrentValue);
}
}
public virtual async Task Inserting_dependent_without_principal_throws()
{
var options = Fixture.CreateOptions(seed: false);
using (var context = new EmbeddedTransportationContext(options))
{
context.Add(
new LicensedOperator {
Name = "Jack Jackson", LicenseType = "Class A CDC", VehicleName = "Fuel transport"
});
Assert.Equal(
CosmosStrings.OrphanedNestedDocumentSensitive(
nameof(Operator), nameof(Vehicle), "{VehicleName: Fuel transport}"),
(await Assert.ThrowsAsync <InvalidOperationException>(() => context.SaveChangesAsync())).Message);
}
}
public virtual async Task Can_update_owner_with_dependents()
{
var options = Fixture.CreateOptions();
Operator firstOperator;
using (var context = new EmbeddedTransportationContext(options))
{
firstOperator = context.Set <Vehicle>().OrderBy(o => o.Name).First().Operator;
firstOperator.Name += "1";
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var vehicle = await context.Set <Vehicle>().OrderBy(o => o.Name).FirstAsync();
Assert.Equal(firstOperator.Name, vehicle.Operator.Name);
}
}
public virtual async Task Can_query_and_modify_nested_embedded_types()
{
var options = Fixture.CreateOptions();
using (var context = new EmbeddedTransportationContext(options))
{
var missile = context.Set <Vehicle>().First(v => v.Name == "AIM-9M Sidewinder");
Assert.Equal("Heat-seeking", missile.Operator.Details.Type);
missile.Operator.Details.Type = "IR";
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var missile = context.Set <Vehicle>().First(v => v.Name == "AIM-9M Sidewinder");
Assert.Equal("IR", missile.Operator.Details.Type);
}
}
public virtual async Task Can_manipulate_embedded_collections()
{
var options = Fixture.CreateOptions(seed: false);
Address existingAddress1Person2;
Address existingAddress1Person3;
Address existingAddress2Person3;
Address addedAddress1;
Address addedAddress2;
Address addedAddress3;
using (var context = new EmbeddedTransportationContext(options))
{
context.Add(new Person {
Id = 1
});
var note1 = new Note {
Content = "First note"
};
var note2 = new Note {
Content = "Second note"
};
existingAddress1Person2 = new Address
{
Street = "Second",
City = "Village",
Notes = new List <Note> {
note1, note2
}
};
context.Add(new Person {
Id = 2, Addresses = new List <Address> {
existingAddress1Person2
}
});
existingAddress1Person3 = new Address
{
Street = "First",
City = "City",
AddressTitle = new AddressTitle {
Title = "P3 Shipping"
}
};
existingAddress2Person3 = new Address
{
Street = "Second",
City = "City",
AddressTitle = new AddressTitle {
Title = "P3 Billing"
}
};
context.Add(new Person {
Id = 3, Addresses = new List <Address> {
existingAddress1Person3, existingAddress2Person3
}
});
await context.SaveChangesAsync();
var people = await context.Set <Person>().ToListAsync();
Assert.Empty(people[0].Addresses);
Assert.Equal(1, people[1].Addresses.Count);
Assert.Same(existingAddress1Person2, people[1].Addresses.First());
Assert.Equal(2, existingAddress1Person2.Notes.Count);
Assert.Same(existingAddress1Person3, people[2].Addresses.First());
Assert.Same(existingAddress2Person3, people[2].Addresses.Last());
Assert.Equal(2, people[2].Addresses.Count);
Assert.Same(existingAddress1Person3, people[2].Addresses.First());
Assert.Same(existingAddress2Person3, people[2].Addresses.Last());
}
using (var context = new EmbeddedTransportationContext(options))
{
var people = await context.Set <Person>().ToListAsync();
addedAddress1 = new Address
{
Street = "First",
City = "Town",
AddressTitle = new AddressTitle {
Title = "P1"
}
};
people[0].Addresses.Add(addedAddress1);
addedAddress2 = new Address
{
Street = "Another",
City = "Village",
AddressTitle = new AddressTitle {
Title = "P2"
},
Notes = existingAddress1Person2.Notes
};
people[1].Addresses.Clear();
people[1].Addresses.Add(addedAddress2);
addedAddress3 = new Address
{
Street = "Another",
City = "City",
AddressTitle = new AddressTitle {
Title = "P3 Alternative"
},
Notes = new List <Note> {
new Note {
Content = "Another note"
}
}
};
var existingFirstAddressEntry = context.Entry(people[2].Addresses.First());
var addressJson = existingFirstAddressEntry.Property <JObject>("__jObject").CurrentValue;
Assert.Equal("First", addressJson[nameof(Address.Street)]);
addressJson["unmappedId"] = 2;
existingFirstAddressEntry.Property <JObject>("__jObject").IsModified = true;
var existingLastAddress = people[2].Addresses.Last();
people[2].Addresses.Remove(existingLastAddress);
people[2].Addresses.Add(addedAddress3);
people[2].Addresses.Add(existingLastAddress);
existingLastAddress.Notes.Add(new Note {
Content = "City note"
});
await context.SaveChangesAsync();
await AssertState(context);
}
using (var context = new EmbeddedTransportationContext(options))
{
await AssertState(context);
}
async Task AssertState(EmbeddedTransportationContext context)
{
var people = await context.Set <Person>().OrderBy(o => o.Id).ToListAsync();
var firstAddress = people[0].Addresses.Single();
Assert.Equal("First", firstAddress.Street);
Assert.Equal("Town", firstAddress.City);
Assert.Equal("P1", firstAddress.AddressTitle.Title);
Assert.Empty(firstAddress.Notes);
var addresses = people[1].Addresses.ToList();
Assert.Single(addresses);
Assert.Equal("Another", addresses[0].Street);
Assert.Equal("Village", addresses[0].City);
Assert.Equal("P2", addresses[0].AddressTitle.Title);
var notes = addresses[0].Notes;
Assert.Equal(2, notes.Count);
Assert.Equal("First note", notes.First().Content);
Assert.Equal("Second note", notes.Last().Content);
addresses = people[2].Addresses.ToList();
Assert.Equal(3, addresses.Count);
Assert.Equal("First", addresses[0].Street);
Assert.Equal("City", addresses[0].City);
Assert.Equal("P3 Shipping", addresses[0].AddressTitle.Title);
var existingAddressEntry = context.Entry(addresses[0]);
var addressJson = existingAddressEntry.Property <JObject>("__jObject").CurrentValue;
Assert.Equal("First", addressJson[nameof(Address.Street)]);
Assert.Equal(5, addressJson.Count);
Assert.Equal(2, addressJson["unmappedId"]);
Assert.Equal("Another", addresses[1].Street);
Assert.Equal("City", addresses[1].City);
Assert.Equal("P3 Alternative", addresses[1].AddressTitle.Title);
Assert.Equal(1, addresses[1].Notes.Count);
Assert.Equal("Another note", addresses[1].Notes.First().Content);
Assert.Equal("Second", addresses[2].Street);
Assert.Equal("City", addresses[2].City);
Assert.Equal("P3 Billing", addresses[2].AddressTitle.Title);
Assert.Equal(1, addresses[2].Notes.Count);
Assert.Equal("City note", addresses[2].Notes.First().Content);
}
}
public virtual async Task Can_add_collection_dependent_to_owner()
{
var options = Fixture.CreateOptions(seed: false);
Address existingAddress1Person2;
Address existingAddress1Person3;
Address existingAddress2Person3;
Address addedAddress1;
Address addedAddress2;
Address addedAddress3;
using (var context = new EmbeddedTransportationContext(options))
{
context.Add(new Person {
Id = 1
});
existingAddress1Person2 = new Address
{
Street = "Second",
City = "Village",
Notes = new[] { new Note {
Content = "First note"
}, new Note {
Content = "Second note"
} }
};
context.Add(new Person {
Id = 2, Addresses = new[] { existingAddress1Person2 }
});
existingAddress1Person3 = new Address {
Street = "First", City = "City"
};
existingAddress2Person3 = new Address {
Street = "Second", City = "City"
};
context.Add(new Person {
Id = 3, Addresses = new[] { existingAddress1Person3, existingAddress2Person3 }
});
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var people = await context.Set <Person>().ToListAsync();
addedAddress1 = new Address {
Street = "First", City = "Town"
};
people[0].Addresses.Add(addedAddress1);
addedAddress2 = new Address {
Street = "Another", City = "Village"
};
people[1].Addresses.Add(addedAddress2);
var existingAddressEntry = context.Entry(people[1].Addresses.First());
var addressJson = existingAddressEntry.Property <JObject>("__jObject").CurrentValue;
Assert.Equal("Second", addressJson[nameof(Address.Street)]);
addressJson["unmappedId"] = 2;
existingAddressEntry.Property <JObject>("__jObject").IsModified = true;
addedAddress3 = new Address {
Street = "Another", City = "City"
};
var existingLastAddress = people[2].Addresses.Last();
people[2].Addresses.Remove(existingLastAddress);
people[2].Addresses.Add(addedAddress3);
people[2].Addresses.Add(existingLastAddress);
await context.SaveChangesAsync();
}
using (var context = new EmbeddedTransportationContext(options))
{
var people = await context.Set <Person>().OrderBy(o => o.Id).ToListAsync();
var addresses = people[0].Addresses.ToList();
Assert.Equal(addedAddress1.Street, addresses.Single().Street);
Assert.Equal(addedAddress1.City, addresses.Single().City);
Assert.Equal(addedAddress1.Notes, addresses.Single().Notes);
addresses = people[1].Addresses.ToList();
Assert.Equal(2, addresses.Count);
Assert.Equal(existingAddress1Person2.Street, addresses[0].Street);
Assert.Equal(existingAddress1Person2.City, addresses[0].City);
Assert.Equal(
existingAddress1Person2.Notes.OrderBy(n => n.Content).Select(n => n.Content),
addresses[0].Notes.OrderBy(n => n.Content).Select(n => n.Content));
Assert.Equal(addedAddress2.Street, addresses[1].Street);
Assert.Equal(addedAddress2.City, addresses[1].City);
var existingAddressEntry = context.Entry(people[1].Addresses.First());
var addressJson = existingAddressEntry.Property <JObject>("__jObject").CurrentValue;
Assert.Equal("Second", addressJson[nameof(Address.Street)]);
Assert.Equal(4, addressJson.Count);
Assert.Equal(2, addressJson["unmappedId"]);
addresses = people[2].Addresses.ToList();
Assert.Equal(3, addresses.Count);
Assert.Equal(existingAddress1Person3.Street, addresses[0].Street);
Assert.Equal(existingAddress1Person3.City, addresses[0].City);
Assert.Equal(addedAddress3.Street, addresses[1].Street);
Assert.Equal(addedAddress3.City, addresses[1].City);
Assert.Equal(existingAddress2Person3.Street, addresses[2].Street);
Assert.Equal(existingAddress2Person3.City, addresses[2].City);
}
}