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.

I am a seasoned certified technologist with over 15 years of experience translating complex business needs into elegant IT solutions across industries, including payments, electric utilities, healthcare, finance, virtual reality, and the broader internet ecosystem. My project work spans the full lifecycle—from strategic business analysis and architectural design to hands-on development, implementation, and testing—bringing both precision and creativity to every phase.

Based in Indiana, my husband and I share our home with a few spoiled fur babies and a lot of coffee. Curious about what I’ve been building lately?

📂 Portfolio: https://portfolio.katiegirl.net 💻 GitHub: https://github.com/kathleenwest