We are taking a surprise trip to the Savannah for a safari to see all sorts of exotic animals. During our time there we want to keep track of all the animals we have seen. For this, we need to create a database, as well as a small console application to help record what we see.
Objectives
Use an ORM to query against a database
Requirements
Additional Reading
NOTE: The Additional Resources section below is very helpful. Consider reading this after reading Explorer mode. Then make a plan for the assignment for digging in and writing code.
Explorer Mode
[x] Create a database called SafariVacation
[x] This will have 1 table called SeenAnimals that has the following columns
Id (int)
Species (string)
CountOfTimesSeen (int)
LocationOfLastSeen (string)
NOTE: This should be made all in the code (C#), and not created in the pgcli.
[x] Create a small console application, and create the following queries using your languages ORM.
[x] Display all animals the user has seen
[x] Update the CountOfTimesSeen and LocationOfLastSeen for an animal
[x] Display all animals seen in the Jungle
[x] Remove all animals that I have seen in the Desert.
[x] Add all the CountOfTimesSeen and get a total number of animals seen
[x] Get the CountOfTimesSeen of lions, tigers and bears
Adventure Mode
[ ] Add a new column called LastSeenTime, with a type of DateTime. This will require you to add and run a new migration.
Epic Mode
[ ] Continue to make progress on your capstone project. This should be tasks like Database Schema, HTML, CSS
MichellePolinsky
commented
5 years ago
ORM Safari!
We are taking a surprise trip to the Savannah for a safari to see all sorts of exotic animals. During our time there we want to keep track of all the animals we have seen. For this, we need to create a database, as well as a small console application to help record what we see.
Objectives
Requirements
Additional Reading
NOTE: The Additional Resources section below is very helpful. Consider reading this after reading Explorer mode. Then make a plan for the assignment for digging in and writing code.
Explorer Mode
SafariVacationSeenAnimalsthat has the following columnsId(int)Species(string)CountOfTimesSeen(int)LocationOfLastSeen(string)pgcli.CountOfTimesSeenandLocationOfLastSeenfor an animalJungleDesert.CountOfTimesSeenand get a total number of animals seenCountOfTimesSeenoflions,tigersandbearsAdventure Mode
LastSeenTime, with a type of DateTime. This will require you to add and run a new migration.Epic Mode
Additional Resources
.NET