CODEWITHSUNDEEP
c#entity-frameworkef-code-first
Richthofen
Richthofen

Reputation: 2086

EF Code First: Trying to get a child property's parameters to appear in the parent class' table

I have a class, "Search". See definition below:

public class Search
{
    [Key]
    public int SearchID { get; set; }
    public int UserID { get; set; }

    public SearchParameters SearchParameters { get; set; }

    public ICollection<SearchProvider> SearchProviders { get; set; }
    public User User;
}

SearchParameters is a class with value types, and a few sub-classes; as defined below:

public class SearchParameters
{
    public List<string> SearchTerms { get; set; }
    public int MaxRecords { get; set; }
    public DistanceParameter Distance { get; set; }
    public PriceRangeParameter PriceRange { get; set; }
}

The idea is that I do not want a separate SearchParameters table that has to link to the Search table because every property of the search is always one to one (Except for SearchTerms). Really, what I want EF to do is 'bring up' the child classes' properties so we end up with All the properties of SearchParameter in the SearchTable (and all the parameters of the DistanceParameter and PriceRangeParameter objects themselves). What annotations or other logic would I need for this to work? Thanks!

Upvotes: 0

Views: 143

Answers (1)

Jurica Smircic
Jurica Smircic

Reputation: 6445

I think EF Complex Type mapping is what you need, see more here:

http://weblogs.asp.net/manavi/archive/2011/03/28/associations-in-ef-4-1-code-first-part-2-complex-types.aspx

Upvotes: 1

Related Questions