Entity Framework read only collections
Asked Answered
M

2

19

Consider a domain where a Customer, Company, Employee, etc, etc, have a ContactInfo property which in turn contains a set of Address(es), Phone(es), Email(s), etc, etc...

Here is my abbreviated ContactInfo:

public class ContactInfo : Entity<int>
{
    public ContactInfo()
    {
        Addresses = new HashSet<Address>();          
    }

    public virtual ISet<Address> Addresses { get ; private set; }

    public Address PrimaryAddress
    {
        get { return Addresses.FirstOrDefault(a => a.IsPrimary); }
    }

    public bool AddAddress(Address address)
    {
        // insure there is only one primary address in collection
        if (address.IsPrimary)
        {                  
            if (PrimaryAddress != null)
            {
                PrimaryAddress.IsPrimary = false;
            }
        }
        else
        {
            // make sure the only address in collection is primary
            if (!Addresses.Any())
            {
                address.IsPrimary = true;
            }
        }
        return Addresses.Add(address);
    }
}

Some notes (I am not 100% sure if these are EF "best practices"):

  • collection of Address(es) is virtual to allow for lazy loading
  • private setter on collection prohibits collection replacement
  • collection is an ISet to insure that there are no duplicate addresses per contact
  • using AddAddress method I can insure that there is always and at most 1 address which is primary....

I would like (if possible) to prevent adding Addresses via ContactInfo.Addresses.Add() method and to force using of ContactInfo.AddAddress(Address address)...

I am thinking exposing the set of addresses via ReadOnlyCollection but will this work with Entity Framework (v5)?

How would I go about this?

Moneybags answered 25/6, 2012 at 14:19 Comment(0)
B
3

One way is to make the ICollection property protected and create a new property of IEnumerable that just returns the list of the ICollection property.

The downside with this is that you are not able to query on addresses through the ContactInfo like get all contactinfo that lives in this city.

This is not possible!:

from c in ContactInfos 
where c.Addresses.Contains(x => x.City == "New York") 
select c

Code:

public class ContactInfo : Entity<int>
{
    public ContactInfo()
    {
        Addresses = new HashSet<Address>();          
    }

    protected virtual ISet<Address> AddressesCollection { get ; private set; }

    public IEnumerable<Address> Addresses { get { return AddressesCollection; }}

    public Address PrimaryAddress
    {
        get { return Addresses.FirstOrDefault(a => a.IsPrimary); }
    }

    public bool AddAddress(Address address)
    {
        // insure there is only one primary address in collection
        if (address.IsPrimary)
        {                  
            if (PrimaryAddress != null)
            {
                PrimaryAddress.IsPrimary = false;
            }
        }
        else
        {
            // make sure the only address in collection is primary
            if (!Addresses.Any())
            {
                address.IsPrimary = true;
            }
        }
        return Addresses.Add(address);
    }
}
Beloved answered 26/6, 2012 at 12:7 Comment(3)
Shouldn't it be possible to cast the IEnumerable to an ISet and do all the magic which should be hidden afterwards?Aeriell
@Beloved Unfortunately, this is not an option for me...I need to be able to query...Moneybags
It doesn't work in code first. EF does not create any table for the protected collection/set.Kelsi
D
14

Another option suggested by Edo van Asseldonk is to create a custom collection that inherits its behavior from Collection.

You'd have to make your own implementation for ISet but the principle is the same.

By hiding any methods that modifies the list and marking them as obsolete you effectively get a ReadOnlyCollection but EF will still be able to modify it when it's unboxed as Collection. In my version I've added an implicit operator conversion for List so we don't have to unbox the collection when adding items:

var list = ListProperty.ToList();
list.Add(entity)
ListProperty = list;

Where

public virtual EntityCollection<MyEntity> ListProperty { get; protected set; }

and here's the EntityCollection:

public class EntityCollection<T> : Collection<T>
{
    [Obsolete("Unboxing this collection is only allowed in the declarating class.", true)]
    public new void Add(T item) { }

    [Obsolete("Unboxing this collection is only allowed in the declarating class.", true)]
    public new void Clear() { }

    [Obsolete("Unboxing this collection is only allowed in the declarating class.", true)]
    public new void Insert(int index, T item) { }

    [Obsolete("Unboxing this collection is only allowed in the declarating class.", true)]
    public new void Remove(T item) { }

    [Obsolete("Unboxing this collection is only allowed in the declarating class.", true)]
    public new void RemoveAt(int index) { }

    public static implicit operator EntityCollection<T>(List<T> source)
    {
        var target = new EntityCollection<T>();
        foreach (var item in source)
            ((Collection<T>) target).Add(item); // unbox

        return target;
    }
}

This way you can still run your Linq as usual but will get a proper warning of usage when trying to modify the Collection property. Un-boxing it to a Collection would be the only way:

((Collection<MyEntity>)ListProperty).Add(entity);
Dana answered 5/2, 2013 at 14:52 Comment(0)
B
3

One way is to make the ICollection property protected and create a new property of IEnumerable that just returns the list of the ICollection property.

The downside with this is that you are not able to query on addresses through the ContactInfo like get all contactinfo that lives in this city.

This is not possible!:

from c in ContactInfos 
where c.Addresses.Contains(x => x.City == "New York") 
select c

Code:

public class ContactInfo : Entity<int>
{
    public ContactInfo()
    {
        Addresses = new HashSet<Address>();          
    }

    protected virtual ISet<Address> AddressesCollection { get ; private set; }

    public IEnumerable<Address> Addresses { get { return AddressesCollection; }}

    public Address PrimaryAddress
    {
        get { return Addresses.FirstOrDefault(a => a.IsPrimary); }
    }

    public bool AddAddress(Address address)
    {
        // insure there is only one primary address in collection
        if (address.IsPrimary)
        {                  
            if (PrimaryAddress != null)
            {
                PrimaryAddress.IsPrimary = false;
            }
        }
        else
        {
            // make sure the only address in collection is primary
            if (!Addresses.Any())
            {
                address.IsPrimary = true;
            }
        }
        return Addresses.Add(address);
    }
}
Beloved answered 26/6, 2012 at 12:7 Comment(3)
Shouldn't it be possible to cast the IEnumerable to an ISet and do all the magic which should be hidden afterwards?Aeriell
@Beloved Unfortunately, this is not an option for me...I need to be able to query...Moneybags
It doesn't work in code first. EF does not create any table for the protected collection/set.Kelsi

© 2022 - 2024 — McMap. All rights reserved.