My Entity Framework SQL Demo

A simple windows console application that uses ADO.NET Entity Framework libraries and patterns to connect to a database, read records, write new records, and perform a LINQ query on a selected table in the database.

Comments: You need to install theΒ Northwind databaseΒ to an SQL Server instance on your computer or server, then modify the application’s connection string to connect to your unique server SQL database instance. Also, you need to edit the NWind database Identity configuration and Tool Options to edit the database (see photos below with configuration settings).


SQL Server Database Table Identity Configuration
SQL Server Database Tool Options Configuration
Menu & Read
Menu & Write
Menu, Write, then Read
LINQ Query


Download and access the code on GitHub here.

Kathleen has 15 yrs. of experience analyzing business IT needs and engineering solutions in payments, electric utilities, pharmaceutical, financial, virtual reality, and internet industries with a variety of technologies. Kathleen's project experience has been diverse ranging from executing the business analysis β€œdesign phase” to hands-on development, implementation, and testing of the IT solutions. Kathleen and her husband reside in Indiana with no children, instead living along with their fur babies.