In this chapter, we created our first Entity Framework-based application. We started by creating a new console application .NET project. We then added the Entity Framework reference using NuGet. Then, we decided what data we wanted to store in the database and created a class that maps to a table in the database, that is, the Person
class. Then, we created our database abstraction, the Context
class, inheriting from DbContext
. We specified the desired connection string in its constructor and added this connection string to the application configuration file. Then, we added a single property to our context, People
, which was a collection of Persons
object, of the type DbSet
of Person
. At this point, we ran our application. We observed that a database was created with a single table, based on the this property. The database creation process used many conventions, including the table name and making the PersonId
column unique (by identity)
and primary key.
We then worked on adding a...