28 Apr 2019

We learned about App.Config file and the benefits of using a configuration file in our application. we saw how to read data from the App.Config using ConfigurationManager class. we explored the location of the super config file (machine.config) in the computer’s .NET framework folder. Then we stored our ConnectionString in the App.Config file. Later, we discussed about Entity Framework: DataBase first, Code first, Model first methodology. then we implemented a DataBase first approach in a C# console application which uses the Entity Framework to interact with the MSSQL data base.

More topics covered:

• App.Config – SKU vs supported version
• ConfigurationManager key value pair
• Modifying App.config without compilation
• Running console application from command line
• ADO.NET Entity Data Mode
• Pluralize/ signalize POCO class

Links:

• • App.Config demo code: data read
  • App.Config demo code: ConnectionString
  • Entity Framework: code demo
  • MSSQL nested query syntax
  • Entity Framework 6 – MSDN link
  • App.Config – MSDN link
  • Lesson Summary Video!
  • Home-Work: connect to one of your tables in the MSSQL DB using Entity Framework (watch summary video). Console.WriteLine all of the table rows