All content will reference the AdventureWorks Database found over at https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/adventure-works
Starting with simple console applications, learn and explore Linq
https://ef.readthedocs.io/en/staging/platforms/full-dotnet/existing-db.html
https://www.tutorialsteacher.com/linq/sample-linq-queries
https://code.msdn.microsoft.com/101-LINQ-Samples-3fb9811b
Integrating a DB backend using Linq to a front-end After importing AdventureWorks DB into a local instance of SQL Server
- Connect the DB to the Console App using EntityFramework
- Select all records from the People table using EF
- Output all the first names from the People table
- Read user input from console and then use it to filter based on middlename (where middlename.contains('userinput')
- Use the group by feature to display the number of unique firstname and the count of occurance within the filtered dataset in #4
- Read user input from console and then use it to filter the email field, i.e at this point you will be filtering based on 2 inputs, one for middlename and another for emailaddress
- Change from listing the firstnames to listing the entire people record. To simplify, list it in JSON format
- Finish up last week HW (aka output in JSON), plagiarism is allowed, but i want all of you to understand what is the cause. The feature that cause this problem is both good and bad for you
- Time to learn about the System.IO namespace. Continue to use the console app and do this
- Download https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/adventure-works/oltp-install-script/CurrencyRate.csv
- Read the file via your console app and display it as is line by line
- Cast each line to a class and store it in a list e.g List
- Print SourceCurrency, DestinationCurrency, Conversation rate
- Read user input and filter by DestinationCurrency
- Group by DestinationCurrency and then display the average, low and highest exchange rate in the data set
- PLOT USD-CAD exchange rate over time i.e X is Time, Y is exchange rate
CRUD operations
Bringing it all together
Winform
Webform