Fluent API In Code First Approach

Entity Mapping:

Now we will learn how to configure the entity using the Fluent API. Entity mapping is a simple approach that explains how the domain classes will map to the database. Let us take some example of entity mapping.

Default Schema

The default schema of database is “dbo” but you can change the default schema from “dbo” to another schema.



To change the schema use the “HasDefaulSchema” method in “OnModel Creating” method as below.



Map Entity To Table:

With default convention of Code First, it will create the database tables with the name of DbSet properties in the context class. So Code First creates the Table with “Employee” and “Project” name. But we can change the name of table and their schema also let us take some examples.

Change the names of tables.



After above query now My_Company database will look like below.



We can see that name of tables are changed, in the same way we can also change the schema of tables.





After above query schema of tables we will change .



Entity Splitting

Using splitting we can divide the entity into multiple tables , in other words we can combine the result coming from multiple tables into a single class. But it is only possible for one to one relationships. The following example shows split Employee entity to multiple tables in the database.



Database



We can see that in the database two new tables are generated Employee_Tab(Emp_Id, Number_Of_Projects) and Employee_Tab(Emp_Id, Emp_Name).

Let us take an another example.



Database



We can see that now three tables are generated for Employee entity , this happens because we forgot to include the “department” property in mapping so a new table is generated for department entity. So the conclusion is don’t use any property in mapping the new table that will contain the all unused properties or fields.

In previous articles we performed the mapping using the “lambda” operator, Code First approach also provide delegate concept for mapping of entity to database. Let us take an example of mapping using the delegates.




Property Mapping Using fluent API:

Using the property mapping we can configure the property of an entity. We can also map and configure the properties of your domain classes using Fluent API. Now we learn how to configure the property using the property method of DbmodelBuilder class.



Configure the Column:

Using the Fluent API we can change the default configuration of a column like column name, column order, data type , maximum length etc. Let us take an example.



Database:



We can see that Order of Emp_Name column in table is second and length of data is 200 and null is allowed in column as per property defined using the Fluent API.

Configure the Primary Key

When an entity class contains a column name with “ID” postfix then this column will become the primary key for that column but if we don’t define any column with “ID”postfix then error will generate. We can also explicitly define the primary key for a table using the “HasKey” Method.



Database



Configure Concurrency Column:

If we define any column as Concurrency column then this column must be included in where clause for updating and deleting query else error will generate. In below query we define the Emp_Id column as concurrency column so this column must be included in where clause for updating and deleting query. We can achieve this using the IsConcurrencyToken method.



Configure Null and NotNull column for property:

In code first approach primitive data type property generates a not null column and reference type property generate nullable column. But we can explicitly define the column as nullbale or not nullable. The Isoptional method is used to define a nullable column and IsRequired method is used to generate the not nullable column.



Define Parameter Name in Stored Procedure:

Using the HasParameterName method we can define the parameter name for a property that will be used in stored procedure.



Thanks for reading the article. If you have any doubt or query related to this topic then mention your query in comment section.