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

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. experience analyzing business IT needs and engineering solutions in electric utilities, pharmaceutical, 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 implementation and testing of the IT solutions. She has also delivered technical training, user documentation, and developed new business processes for the solutions. Kathleen also has strengths in software development, programming, testing vendor applications, databases, creating business efficiency tools, and IT solutions with proficiency in technologies such as C# .NET applications, Visual Basic (VB.NET), SQL, Visual Studio, Oracle, XML, Microsoft applications, and more.