CODEWITHSUNDEEP
entity-framework
VSO
VSO

Reputation: 12646

Any Point to the DbSet Property Name?

public DbSet<Lecture> Lectures{ get; set; }

Does the property name here matter at all? It seems that if I want to use the model, I use "Lecture". The generated table is just a plural of whatever is in <>, e.g., if I understand correctly, I can change "Lectures" to "Leprechauns" and my table will still be called "Lectures" based on <Lecture> and I will use context.Lectures to select from it. Does the property name have any point?

I didn't find the answers in this tutorial or on msdn.

Edit: Upon further testing - the db table name is based on the model name in the angle brackets, but to actually select from the db (in the C# code), you use the property name specified in DbSet propertyName. Still would like to hear how this works in detail.

Upvotes: 2

Views: 826

Answers (3)

AlinM
AlinM

Reputation: 21

The property name matters. The EF translates the name of the property into the name of the table. If the property name is not the same with the table name you'll get an error. Unless you specifically tell the builder the name of the table like this:

    public void Configure(EntityTypeBuilder<Lecture> builder)
    {
        builder.ToTable("License");
    }

Upvotes: 0

jjj
jjj

Reputation: 4997

Entity Framework builds a model of the database, where each class/model represents an entity type, and each DbSet represents a set of entities of a single type. When you declare a DbSet<T> property in your DbContext, that tells EF to include the class of type T as one of the entity types, and it automatically includes any other connected types (e.g. navigation properties) in the object graph as well.

All this to say, the name of the property itself probably doesn't matter. In fact, you could use the Fluent API to add entity types as well, not declare any DbSet properties if you wanted, in which case you'd use context.Set<T> to retrieve the DbSets. The properties are really just for convenience.

Maybe this is helpful as well: https://msdn.microsoft.com/en-us/data/jj592675.aspx

Upvotes: 2

Sirwan Afifi
Sirwan Afifi

Reputation: 10824

DbSet corresponds to a table or view in your database, So you will be using your DbSet's to get access, create, update, delete and modify your table data.
By the way you can remove the convention:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{    
    modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}

Upvotes: 0

Related Questions