Interview Questions and Answers

Code First Conventions are a set of rules that automatically configure the database schema based on the shape of your entity classes and their relationships.

The Fluent API is an alternative to the Data Annotations for configuring the model in Entity Framework. It provides a more programmatic way to configure the database schema.

The InverseProperty attribute is used to specify the inverse navigation property in a relationship when the default convention is not followed.

The Database.Log property is used to log SQL statements and other information related to database operations. It can be useful for debugging and performance tuning.

Example:

context.Database.Log = Console.WriteLine;

The [ConcurrencyCheck] attribute is used to specify that a property should be included in the WHERE clause of an UPDATE or DELETE statement to check for concurrency conflicts.

Example:

[ConcurrencyCheck] public byte[] RowVersion { get; set; }

The AsSplitQuery method is used to enable split queries for a LINQ query, allowing EF to generate separate SQL queries for different parts of the LINQ query.

The AsNoFilter method is used to disable query filters defined in the model, allowing you to retrieve entities without applying those filters.

The Keyless attribute is used to specify that an entity type does not have a primary key, and it is used for query types that represent database views or tables without primary keys.

Example:

[Keyless] public class MyQueryType { /* properties */ }

The Entry.StateChanged event is triggered when the state of an entity being tracked by the context changes. It can be used for implementing custom logic based on entity state changes.

Example:

entry.StateChanged += (sender, e) => { /* custom logic */ };