My Entity Framework SQL Demo

.NET Framework, ADO.NET, C#, Console Applications, Entity Framework, LINQ, SQL, , , , , , , , , , ,


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).

Table of Contents

Demo

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

Code

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.