Exclude a field/property from the database with Entity Framework 4 & Code-First

user_162176 0
Viewed 44844

I will like to know that is there a way to exclude some fields from the database? For eg:

public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string FatherName { get; set; }

    public bool IsMale { get; set; }
    public bool IsMarried { get; set; }

    public string AddressAs { get; set; }
}

How can I exclude the AddressAs field from the database?

ef-code-first entity-framework-4 poco .net c#
4 Answers

I know this is an old question but in case anyone (like me) comes to it from search...

Now it is possible in entity framework 4.3 to do this. You would do it like so:

builder.Entity<Employee>().Ignore(e => e.AddressAs);
user_10399470

It's also possible to add the column you want to ignore as a Shadow Property in the DbContext:

builder.Entity<Employee>().Property<string>("AddressAs");

Then you can query on that column like so:

context.Employees.Where(e => EF.Property<string>(e, "AddressAs") == someValue);
user_3922710
Related