EF Core basics

Which of the following development approaches EF Core supports?

• Code-First and Database-First

• Model-First and Database-First

• Code-First, Database-First, Model-First

Fluent API is most commonly accessed by overriding the _____________ method on your derived DbContext.

How to execute plain SQL in EF?

• DbSet.ExecuteSqlCommand()

• DbContext.SqlQuery()

• DbSet.SqlQuery()

• u can not execute plain SQL in EF

The _______ attribute can be applied to properties of an entity class for which we do not want to create corresponding columns in the database

The composite key can be created using:

• Fluent API

• DataAnnotations

Does EFC wrap operation in a transaction, when you execute SaveChanges() to insert, update or delete data into the database?

• Yes

• No

Whether the created index is unique by default?

• Yes

• No

Can we use Fluent API to configure property as a key?

• Yes

• No

How can we set the max length of string for our property?

• MaxLength if you are using attributes

• HasMaxLength() in FluentAPI

• Length if you are using attributes

• SetMaxLength() in FluentAPI

• WithMaxLength() in FluentAPI

What are the various Entity States in EF?

• Added

• Modified

• Deleted

• Unchanged

• Detached